Reputation
3,353
Top tag
Next privilege 5,000 Rep.
Approve tag wiki edits
Badges
1 12 37
Impact
~128k people reached

2d
comment RAID 10 array configuration for SQL Server
You seem to be interested in IOPS. Are you open to use SSDs? One SSD would blast away 24 magnetic disks.
Aug
17
comment Dropping a large table
Isn't it necessary to add error handling to that rename transaction? I think if the first rename fails the second one will still be executed (which is stupid). I like XACT_ABORT ON for this.
Aug
11
comment How are these two SQL Server rollbacks different?
I believe rollback takes log space. When the log becomes full during rollback the DB becomes suspect. It is not touched any further. This looks like instantaneous rollback but rollback has been deferred until you are able to take the database back online (when there is disk space available).; Also, when the log becomes full SQL Server might try to make room by checkpointing which might explain spikes in IO activity.
Aug
8
comment DBCC CHECKDB Consistency Error
Looks like a checkdb bug. Delete everything in that database except for that row. Make sure CHECKDB still reports the error. Then, report the bug and attach the MDF and LDF privately on MS Connect.
Aug
6
awarded  Popular Question
Aug
3
awarded  Constituent
Aug
3
comment Select statements during long update
@Kin that's absolutely basic indexing knowledge. I assume the OP will research that.
Aug
3
answered Select statements during long update
Aug
3
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!).