Reputation
33,048
Next tag badge:
503/400 score
72/80 answers
Badges
8 85 145
Newest
 Necromancer
Impact
~1.1m people reached

6h
revised Why is DistinctSort followed by TopNSort in my query plan?
Lose some zeros and the ANY aggregate goes too.
9h
revised Why is DistinctSort followed by TopNSort in my query plan?
added 116 characters in body
9h
revised Why is DistinctSort followed by TopNSort in my query plan?
added 65 characters in body
9h
answered Why is DistinctSort followed by TopNSort in my query plan?
12h
comment Index performance on ON versus WHERE
Did the plan show an optimiser timeout?
21h
comment Problem with clustered index? Or bad indexes? (SQL Server 2008 R2)
@Aaron pretty sure that 2005 behaved as above. Not sure about earlier versions. I don't have them installed anywhere to test either.
1d
awarded  Necromancer
1d
comment Problem with clustered index? Or bad indexes? (SQL Server 2008 R2)
@Aaron - This isn't the case. See i.stack.imgur.com/SpOf8.png. And regarding * vs constant see stackoverflow.com/a/6140367/73226
1d
comment select n values per group
Is this a documented, guaranteed technique in MySQL?
1d
comment Good, Bad or Indifferent: WHERE 1=1
@Paul - Thanks for the links to the docs.
1d
answered Good, Bad or Indifferent: WHERE 1=1
Jul
29
awarded  Enlightened
Jul
28
awarded  Nice Answer
Jul
28
awarded  Nice Answer
Jul
28
awarded  Caucus
Jul
27
awarded  Nice Answer
Jul
20
comment How to full text search worked with special character like “of”?
it depends...
Jul
19
revised Index on a persisted computed column not seekable?
No need for RIGHT to reproduce the issue
Jul
19
awarded  Nice Answer
Jul
18
comment Index on a persisted computed column not seekable?
Please update this if you get any interesting response!