usr's user avatar
usr's user avatar
usr's user avatar
usr
  • Member for 10 years, 7 months
  • Last seen this week
51 votes
4 answers
15k views

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

23 votes
1 answer
5k views

What exactly can SQL Server 2014 execute in batch mode?

21 votes
2 answers
45k views

SQL Server: Should we use TCP or Named Pipes or use the default?

17 votes
1 answer
12k views

Move Primary Key to Filegroup (SQL Server 2012)

17 votes
2 answers
2k views

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

16 votes
3 answers
8k views

Securely generate a UNIQUEIDENTIFIER in SQL Server

16 votes
2 answers
537 views

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

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?

9 votes
1 answer
1k views

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

7 votes
1 answer
3k views

Placing an ASSERT in a SQL Server query

7 votes
3 answers
11k views

Using the sysadmin role with EXECUTE AS

7 votes
2 answers
2k views

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

6 votes
2 answers
539 views

Why does a Columnstore index build often wait on SLEEP_TASK?

6 votes
2 answers
3k views

Strange query results for DELETE with ROW_NUMBER

6 votes
2 answers
3k views

What happens in this strange SQL Server Mirroring situation?

6 votes
2 answers
1k views

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

6 votes
1 answer
488 views

Query the Differential Changed Maps in SQL Server

6 votes
2 answers
11k views

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

6 votes
4 answers
7k views

Script Contents of SQL Server Database From a Batch File

5 votes
1 answer
3k views

Disadvantages of reorganizing all tables nightly

5 votes
1 answer
295 views

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

4 votes
1 answer
189 views

Simulate more RAM with SQL Server

3 votes
1 answer
61 views

Execution plan for COMPUTE BY

3 votes
2 answers
272 views

When did a specific database come online?

2 votes
2 answers
2k views

Make sure two columns are sorted in the same order

2 votes
1 answer
396 views

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

2 votes
0 answers
322 views

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

2 votes
2 answers
2k views

How to archive a whole database?

2 votes
2 answers
599 views

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