Archives: January 2011
Well, what a week it’s been. I started my winning blog post for the SQLskills blogging competition by stating that the blog itself was now starting to pay real dividends. And it seems to continue - in a big way - with a free seat at the Dallas Internals event with… Read more
At last, my blog is starting to pay real dividends. Not only do I get the opportunity to publish my thoughts about SQL Server - hopefully spreading any pearls of wisdom that I might posses throughout the wider SQL community - and have my work peer reviewed by them,… Read more
The object property function appears to be often overlooked.
This function will tell us about any schema scoped object in the current database.
For me, it is far easier to use the OBJECTPROPERTY() function, than to write a complicated query that might join serveral catalog views.
The function takes two parameters Read more
I feel that it is wise move for a script to actually check itself that the database connection that is being used, is infact operating in the intended database.
Occasionally, in the past, I have run scripts on servers where a database was expected to be - except it was… Read more
One of the features that I have been using quite a lot lately is the OUTPUT clause.
This clause can be used with any of the DELETE / INSERT / UPDATE / MERGE statements.
Basically the OUTPUT clause allow us to filter off the affected rows from any of the… Read more