Hannah Vernon's user avatar
Hannah Vernon's user avatar
Hannah Vernon's user avatar
Hannah Vernon
Moderator
  • Member for 11 years, 7 months
  • Last seen this week
42 votes
1 answer
85k views

Why does CREATE INDEX ... WITH ONLINE=ON block access to the table over a period of minutes?

75 votes
8 answers
69k views

MAXDOP setting algorithm for SQL Server

33 votes
5 answers
34k views

Handling concurrent access to a key table without deadlocks in SQL Server

23 votes
2 answers
24k views

What can cause a mirroring session to timeout then failover?

11 votes
3 answers
18k views

How can I inspect the security settings of a SQL Server Endpoint?

7 votes
3 answers
15k views

Access Denied error in CREATE DATABASE ... FOR ATTACH

6 votes
5 answers
13k views

How can I tell if a SQL Server backup is compressed?

16 votes
3 answers
12k views

Why should a CTE start with a semi-colon?

4 votes
1 answer
12k views

CREATE DATABASE permission denied for sysadmin

13 votes
3 answers
11k views

How can I reliably determine if a given SQL Server instance has the "Lock Pages in Memory" right?

9 votes
3 answers
9k views

How might a corrupt partition in TempDB result in DBCC CHECKDB reporting no issue?

26 votes
1 answer
9k views

How does this syntax work? {fn CurDate()} or {fn Now()} etc

3 votes
1 answer
8k views

0x80131904 - An existing connection was forcibly closed by the remote host

31 votes
3 answers
8k views

What is a deterministic method for evaluating a sensible buffer pool size?

21 votes
4 answers
7k views

What's up with the collation of some columns in sys.databases?

8 votes
2 answers
7k views

Kerberos authentication not working with Linked Servers in SQL Server 2012

16 votes
3 answers
7k views

Predicates: in the WHERE clause or the JOIN clause? [duplicate]

9 votes
1 answer
6k views

BACKUP MASTER KEY failing with cannot find symmetric master key because it does not exist

12 votes
1 answer
6k views

SQL Server TempDB behaviour in large memory environment

28 votes
3 answers
6k views

Do natural keys provide higher or lower performance in SQL Server than surrogate integer keys?

17 votes
2 answers
5k views

Are the cost percentages in this SQL Server plan over 100% for a valid reason?

12 votes
1 answer
5k views

Non-yielding IOCP Listener

6 votes
3 answers
5k views

sqlcmd :out not working as expected?

10 votes
2 answers
4k views

Return xml sequences where an attribute doesn't contain a specific character

3 votes
1 answer
4k views

What are the most compelling reasons to upgrade from SQL Server 2005 to SQL Server 2012?

6 votes
2 answers
3k views

Optimize extraction of json data via OPENJSON

28 votes
9 answers
3k views

What is the most efficient method of performing the FIZZBUZZ test in SQL Server?

12 votes
1 answer
3k views

What is the cause of this problem with CONVERT()?

3 votes
1 answer
2k views

Is EXECUTE AS OWNER in msdb a security risk?

3 votes
0 answers
2k views

Msg 22830 level 16 on sp_cdc_enable_db_internal - could not update metadata that indicates database is enabled for Change Data Capture