Hint Abuse: SQL Server vs Oracle

thatjeffsmith Expired

I’ve overheard the SQL Server folks talking about the challenges of support applications where the NOLOCK (or is it NO_LOCK?) hint has been deployed to make transactions and queries go faster. This probably causes more problems than it solves, and rather trying to rehash what …

Oracle Discovery Tool?

thatjeffsmith Expired 2 Comments

My employer has a freeware utility you can run on your network to find and document instances of SQL Server. One of SQL Server’s primary advantages is also one of its primary disadvantages – you can spin one up in a manner of minutes. To …

Oracle 12g This Fall?

thatjeffsmith General 6 Comments

Post Updated on November 10, 2011. 11gR2 was supposed to be 12g..or so the story goes. You can read tons of posts on OTN from several years ago where 12g is referenced. Nothing recent though. So… Oracle Open World 2011 is coming soon, and you …