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

Archives: July 2010

Count(*) or Count(1) ?

Every so often on the on-line forums, the question of : Which is better Count(*) or Count(1) ? will occur.  So can it categorically be proved than one is better than the other ?

What we need to do is populate a table and use both count(*) and count(1) and… Read more

7 comments, 1,451 reads

Posted in Dave Ballantynes blog on 27 July 2010

SQLBits 7

For those that may of missed it,  voting for SQLBits sessions is now open.  Make your voice heard and get voting.  It is quite a choice to pick a mere 10 sessions from the nearly 100 session listed, but it will give the committee a really good idea of… Read more

1 comments, 382 reads

Posted in Dave Ballantynes blog on 20 July 2010

Using a UDF as a SARG. Make a hash of it!

I am somewhat uncomfortable blogging this, as I feel that it falls into “Polish a turd” category.  Having said that, it is a particularly ugly turd and it does polish up rather well.  Though as the saying goes, it is still a turd.

The evils and inadequacies of…

Read more

0 comments, 636 reads

Posted in Dave Ballantynes blog on 2 July 2010