user avatar
user avatar
user avatar
usr
  • Member for 10 years, 4 months
  • Last seen more than a month ago
28 votes
1 answer
846 views

Is the eager spool operator useful for this delete from a clustered columnstore?

  • 4,188
23 votes
2 answers
24k views

What can cause a mirroring session to timeout then failover?

  • 67.2k
20 votes
2 answers
562 views

Is there a complete list of Online operations for each SQL Server version?

17 votes
1 answer
11k views

Move Primary Key to Filegroup (SQL Server 2012)

  • 7,160
9 votes
2 answers
21k views

Slow Performance Inserting Few Rows Into Huge Table

8 votes
2 answers
2k views

Index fragmentation and SSD disks

  • 95
7 votes
1 answer
408 views

Why does my SQL Server show more than half a million active tasks?

  • 101
6 votes
2 answers
10k views

Comparing binary 0x and 0x00 turns out to be equal on SQL Server

  • 7,160
5 votes
1 answer
3k views

Disadvantages of reorganizing all tables nightly

  • 7,160
5 votes
2 answers
1k views

How to determine when to reduce physical memory for SQL Server?

5 votes
1 answer
73 views

Is it possible to decouple row size estimation from maximum column width?

  • 153
4 votes
1 answer
865 views

Indexes file damaged, was on ramdisk

  • 193
4 votes
1 answer
1k views

SQL Server 2008 R2 Lockup for 10 minutes

  • 471
3 votes
1 answer
900 views

SQL Server Service Broker - CHECKDB found consistency errors, how could this happen?

2 votes
1 answer
391 views

Why 2 allocation units during online index rebuild to different file group?

  • 7,160
2 votes
1 answer
806 views

Is it possible to replicate wide table in MS SQL?

  • 255
1 vote
2 answers
2k views

What's the official successor for sp_resetstatus in case of a SUSPECT database?

  • 7,160