Skip to main content
usr's user avatar
usr's user avatar
usr's user avatar
usr
  • Member for 12 years, 4 months
  • Last seen more than a month ago
6 votes
1 answer
515 views

Query the Differential Changed Maps in SQL Server

17 votes
3 answers
8k views

Securely generate a UNIQUEIDENTIFIER in SQL Server

51 votes
4 answers
15k views

What are Objective Business Reasons to Prefer SQL Server 2012 over 2008 R2?

5 votes
1 answer
3k views

Disadvantages of reorganizing all tables nightly

15 votes
3 answers
4k views

Why are there execution plan differences between OFFSET ... FETCH and the old-style ROW_NUMBER scheme?

11 votes
2 answers
1k views

What significance does an index_id < 256000 have?

24 votes
1 answer
5k views

What exactly can SQL Server 2014 execute in batch mode?

17 votes
2 answers
2k views

DBCC CHECKDB unfixable corruption: Indexed view contains rows that were not produced by the view definition

16 votes
2 answers
566 views

Is it legal for SQL Server to fill PERSISTED columns with data that does not match the definition?

8 votes
2 answers
3k views

What do the HT* wait types mean? (HTREPARTITION, HTDELETE, ...)

2 votes
2 answers
2k views

How to archive a whole database?

9 votes
1 answer
1k views

How to "hack-drop" a database snapshot after SQL Server upgrade has botched it

6 votes
4 answers
7k views

Script Contents of SQL Server Database From a Batch File

3 votes
1 answer
62 views

Execution plan for COMPUTE BY

6 votes
2 answers
622 views

Why does a Columnstore index build often wait on SLEEP_TASK?

2 votes
0 answers
493 views

Why does shrinking the transaction log generate lots of log (LOP_SHRINK_NOOP) and not shrink the log?

2 votes
2 answers
762 views

Programmatically determine whether a database was shut down cleanly or whether it required crash recovery

4 votes
1 answer
194 views

Simulate more RAM with SQL Server

6 votes
2 answers
3k views

What happens in this strange SQL Server Mirroring situation?

7 votes
2 answers
3k views

Strange query results for DELETE with ROW_NUMBER

2 votes
2 answers
184 views

Did a SQL Server instance ever participate in replication?

5 votes
1 answer
307 views

What is the minimum required compatibility level to use parallel SELECT INTO?

1 vote
1 answer
123 views

How to guard against backup corruption due to spurious bit errors?

7 votes
3 answers
13k views

Using the sysadmin role with EXECUTE AS

7 votes
1 answer
3k views

Placing an ASSERT in a SQL Server query

7 votes
2 answers
1k views

In the SQL Server RESTORE statement, in what time zone is the STOPAT argument?

1 vote
2 answers
2k views

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

8 votes
2 answers
12k views

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

2 votes
0 answers
344 views

What is an incremental checkpoint (in the context of indirect checkpoints)?

2 votes
1 answer
438 views

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