usr
  • Member for 9 years, 11 months
  • Last seen more than a month ago
2 answers
23 votes
24k views
10 bookmarks
What can cause a mirroring session to timeout then failover?
2 answers
9 votes
20k views
3 bookmarks
Slow Performance Inserting Few Rows Into Huge Table
1 answers
16 votes
11k views
4 bookmarks
Move Primary Key to Filegroup (SQL Server 2012)
2 answers
6 votes
10k views
2 bookmarks
Comparing binary 0x and 0x00 turns out to be equal on SQL Server
1 answers
5 votes
3k views
2 bookmarks
Disadvantages of reorganizing all tables nightly
2 answers
8 votes
2k views
1 bookmarks
Index fragmentation and SSD disks
2 answers
1 votes
2k views
1 bookmarks
What's the official successor for sp_resetstatus in case of a SUSPECT database?
1 answers
4 votes
1k views
1 bookmarks
SQL Server 2008 R2 Lockup for 10 minutes
2 answers
5 votes
1k views
1 bookmarks
How to determine when to reduce physical memory for SQL Server?
1 answers
3 votes
874 views
2 bookmarks
SQL Server Service Broker - CHECKDB found consistency errors, how could this happen?
1 answers
4 votes
862 views
1 bookmarks
Indexes file damaged, was on ramdisk
1 answers
28 votes
823 views
6 bookmarks
Is the eager spool operator useful for this delete from a clustered columnstore?
1 answers
2 votes
791 views
1 bookmarks
Is it possible to replicate wide table in MS SQL?
2 answers
20 votes
558 views
7 bookmarks
Is there a complete list of Online operations for each SQL Server version?
1 answers
7 votes
407 views
1 bookmarks
Why does my SQL Server show more than half a million active tasks?
1 answers
2 votes
384 views
1 bookmarks
Why 2 allocation units during online index rebuild to different file group?
1 answers
5 votes
72 views
1 bookmarks
Is it possible to decouple row size estimation from maximum column width?