Reputation
50,812
Next tag badge:
119/100 score
19/20 answers
Badges
4 82 141
Newest
 Good Answer
Impact
~2.5m people reached

Jul
28
awarded  Good Answer
Jul
22
awarded  Convention
Jul
19
awarded  Nice Answer
Jun
18
awarded  Nice Answer
Jun
1
awarded  Enlightened
Jun
1
awarded  Nice Answer
May
29
awarded  Enlightened
May
29
awarded  Nice Answer
May
21
awarded  t-sql
May
20
awarded  Nice Answer
May
6
revised What are valid usage scenarios for HEAP tables?
added 87 characters in body
May
6
comment What are valid usage scenarios for HEAP tables?
@BrentOzar: Agree, I do it all the time myself. The spirit of my answer is "long term and persistent tables" but I will update
Mar
12
awarded  Nice Answer
Mar
6
awarded  Nice Answer
Feb
12
comment What is more efficient, a where clause or a join with million plus row tables?
@ajeh: I would suggest that your experience is very untypical. You have bigger issues with queries if you have x70 differences: it is that simple
Feb
4
awarded  Enlightened
Feb
4
awarded  Nice Answer
Jan
29
comment SQL Server 2005/2008 UTF-8 Collation/Charset
@Seiyria: no, same behaviour
Jan
23
awarded  Yearling
Dec
23
comment Does Sql Server 2008 support Database Sharding
@clickstefan: which is what SQL Server/Oracle.PG/Sybase do too