Skip to main content
Share Your Experience: Take the 2024 Developer Survey
usr's user avatar
usr's user avatar
usr's user avatar
usr
  • Member for 12 years, 3 months
  • Last seen more than a month ago
51 votes
4 answers
15k views

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

24 votes
1 answer
5k views

What exactly can SQL Server 2014 execute in batch mode?

23 votes
2 answers
52k views

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

18 votes
1 answer
12k views

Move Primary Key to Filegroup (SQL Server 2012)

17 votes
3 answers
8k views

Securely generate a UNIQUEIDENTIFIER in SQL Server

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?

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

8 votes
2 answers
12k views

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

8 votes
2 answers
3k views

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

7 votes
2 answers
3k views

Strange query results for DELETE with ROW_NUMBER

7 votes
2 answers
1k views

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

7 votes
1 answer
3k views

Placing an ASSERT in a SQL Server query

7 votes
3 answers
13k views

Using the sysadmin role with EXECUTE AS

6 votes
4 answers
7k views

Script Contents of SQL Server Database From a Batch File

6 votes
1 answer
515 views

Query the Differential Changed Maps in SQL Server

6 votes
2 answers
3k views

What happens in this strange SQL Server Mirroring situation?

6 votes
2 answers
620 views

Why does a Columnstore index build often wait on SLEEP_TASK?

5 votes
1 answer
306 views

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

5 votes
1 answer
3k views

Disadvantages of reorganizing all tables nightly

4 votes
1 answer
194 views

Simulate more RAM with SQL Server

3 votes
1 answer
62 views

Execution plan for COMPUTE BY

3 votes
2 answers
282 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
438 views

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

2 votes
0 answers
343 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
754 views

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