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…
0 comments, 636 reads
Posted in Dave Ballantynes blog on 2 July 2010