Reputation
50,167
Next tag badge:
114/100 score
19/20 answers
Badges
4 78 137
Newest
 t-sql
Impact
~2.3m people reached

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.
Dec
12
comment Migrate SQL Server binary datadump to postgresql
Not in any readable or useful way. For example, Red Gate Compare tools can read backups but only to compare against another live SQL Server database. Not to read for ETL or to extract data
Dec
12
answered Migrate SQL Server binary datadump to postgresql
Dec
12
answered Is it normal that occasionally Page Life Expectancy drops to 0 and queries start giving timeouts in SQL Server?
Dec
11
answered MS SQL Server 2012 reusing numbers
Dec
8
awarded  Guru