Reputation
3,333
Top tag
Next privilege 5,000 Rep.
Approve tag wiki edits
Badges
1 12 36
Newest
 Constituent
Impact
~123k people reached

1d
awarded  Constituent
1d
comment Select statements during long update
@Kin that's absolutely basic indexing knowledge. I assume the OP will research that.
1d
answered Select statements during long update
1d
comment Compress backup taken from two different environments take different time to restore
Is the size of the backup files similar? If not that would be an important clue.
Jul
31
comment Very high transactions per second
Maybe you can profile the server by executing sp_whoisactive repeatedly. What queries come up most often?
Jul
27
awarded  Caucus
Jul
25
comment What do the HT* wait types mean? (HTREPARTITION, HTDELETE, …)
The query is running and completing fine. There really is no problem I need to solve. I just want to know what these wait types mean.
Jul
24
comment What do the HT* wait types mean? (HTREPARTITION, HTDELETE, …)
No columnstore indexes. I'm using the left join ZeroRowCsTable on 0=1 trick to enable batch mode for row mode tables.
Jul
24
asked What do the HT* wait types mean? (HTREPARTITION, HTDELETE, …)
Jul
19
revised Operation System error 665 with VLDB backup (The requested operation could not be completed due to a file system limitation)
added 1 character in body; edited tags; edited title
Jul
19
answered Operation System error 665 with VLDB backup (The requested operation could not be completed due to a file system limitation)
Jul
15
comment SQL Server - Alter table vs drop and create
"but my colleague can't remember why they trained him that way" How can he be of an opinion that he cannot argue for?!
Jul
12
accepted Execution plan for COMPUTE BY
Jul
12
comment Execution plan for COMPUTE BY
Thanks! How did you obtain the stacks? Infinite query loop and sampling using PerfView or Process Explorer?
Jul
10
comment Benefits of SET TRANSACTION ISOLATION LEVEL READ UNCOMMITTED
Look into the SNAPSHOT isolation models. They are very much stronger than RCU and also do not block or cause blocking. They sound like a good default model for you (instead of defaulting to RCU!).
Jul
10
comment How can I profile SQL Azure?
Probably, you should replicate the condition in a testing environment that you control. There you can optimize the app.
Jul
9
asked Execution plan for COMPUTE BY
Jul
9
comment CLR/C# equivalent to XACT_STATE()
I wish ADO.NET was exposing more of the TDS protocol. Command sets and the bulk insert ORDER hint come to mind as similar unexposed facilities.
Jul
9
comment CLR/C# equivalent to XACT_STATE()
Hm is this value really accurate? For example if a statement on the server crashed and killed the tran, would this variable be updated in all cases?
Jul
8
comment Execution plan has TOP operator for query without TOP or ORDER BY
Try rewriting the not exists as a left hash join. The loop join is probably due to cardinality misestimation.