SQL Clone
SQLServerCentral is supported by Redgate
Log in  ::  Register  ::  Not logged in

Archives: January 2011

What...you mean I won...and Thank You.

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

3 comments, 2,092 reads

Posted in measure twice, cut once. on 30 January 2011

Internals and Performance class in Dallas


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

6 comments, 3,978 reads

Posted in measure twice, cut once. on 23 January 2011

Remember OBJECTPROPERTY(..) when investigating objects.

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

2 comments, 1,275 reads

Posted in measure twice, cut once. on 20 January 2011

Check that what you expected is actually what you got - DB's and SQLCMD

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

0 comments, 1,387 reads

Posted in measure twice, cut once. on 16 January 2011

The OUTPUT clause

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

2 comments, 916 reads

Posted in measure twice, cut once. on 9 January 2011