Reputation
Next tag badge:
116/100 score
19/20 answers
Badges
4 80 140
Newest
 Nice Answer
Impact
~2.4m people reached

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
Dec
22
comment Does Sql Server 2008 support Database Sharding
@clickstefan: none of those are real "scaling out" in the sense of "add more nodes"
Dec
22
comment What are the arguments against or for putting application logic in the database layer?
@Pacerier: adds complexity and now you have many scale out nodes to manage. When should these flush to persistent storage in the database. However, this Q is about ORMs and logic
Dec
12
comment Migrate SQL Server binary datadump to postgresql
You need to attach or restore it depends on the source format.