Hannah Vernon

Canada

https://www.sqlserverscience.com?utm_medium=referral&utm_source=dba.stackexchange.com&utm_campaign=profile

As a Database Reliability and Performance Specialist, Hannah Vernon provides world-class SQL Server consulting.

See Hannah's blog at https://www.SQLServerScience.com

Follow SQL Server Science on Twitter at https://twitter.com/ScienceSQL

profile for Hannah Vernon on Stack Exchange, a network of free, community-driven Q&A sites

My pronouns are she/her.

top accounts reputation activity bookmarks subscriptions

MAXDOP setting algorithm for SQL Server

sql-server configuration maxdop asked Mar 12, 2013 at 19:59

dba.stackexchange.com

33 votes

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

sql-server deadlock asked Mar 13, 2013 at 17:25

dba.stackexchange.com

33 votes

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

sql-server index sql-server-2012 asked Apr 29, 2013 at 19:20

dba.stackexchange.com

30 votes

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

sql-server sql-server-2008-r2 sql-server-2012 asked Dec 3, 2014 at 21:08

dba.stackexchange.com

28 votes

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

sql-server sql-server-2012 performance surrogate-key natural-key performance-testing asked Sep 29, 2013 at 1:56

dba.stackexchange.com

27 votes

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

sql-server asked Dec 30, 2014 at 21:06

dba.stackexchange.com

23 votes

What can cause a mirroring session to timeout then failover?

sql-server sql-server-2005 mirroring database-mirroring troubleshooting asked Aug 13, 2012 at 18:54

dba.stackexchange.com

21 votes

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

sql-server functions asked Apr 4, 2013 at 15:59

dba.stackexchange.com

21 votes

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

sql-server collation metadata asked Oct 15, 2015 at 16:44

dba.stackexchange.com

19 votes

Multi-statement TVF vs Inline TVF Performance

sql-server sql-server-2012 table-valued-functions asked May 6, 2016 at 14:08

dba.stackexchange.com

Top Answers

137

The company’s commitment to rebuilding the relationship with you, our community

meta.stackexchange.com

Is there any limit to the number of databases you can put on one SQL server?

dba.stackexchange.com

Best practice between using LEFT JOIN or NOT EXISTS

dba.stackexchange.com

What happens if I buy Bitcoins and the price goes down?

bitcoin.stackexchange.com

Performance of a=0 and b=0 and ... z=0 vs a+b+c+d=0

dba.stackexchange.com

CPU clock speed versus CPU core count - higher GHz, or more cores for SQL Server?

dba.stackexchange.com

Which database could handle storage of billions/trillions of records?

dba.stackexchange.com

varchar(255) or varchar(256)?

dba.stackexchange.com

Eliminate Key Lookup (Clustered) operator that slows down performance

dba.stackexchange.com

How to determine if there are [idle connections with] uncommitted transactions in PostgreSQL?

dba.stackexchange.com

SQL Server Row by Row Access

dba.stackexchange.com

Max number of user connections

dba.stackexchange.com

What is the quickest way to purge data?

dba.stackexchange.com

Preferred way to store DateTime

dba.stackexchange.com

Why would a primary key value change?

dba.stackexchange.com

Reasons for avoiding large ID values

dba.stackexchange.com

Create SQL Randomized Date of Birth

dba.stackexchange.com

Transaction in a stored procedure

dba.stackexchange.com

Database design : preferred field length for file paths

stackoverflow.com

tSQL - Conversion from varchar to numeric works for all but integer

stackoverflow.com

Unable to create a Filtered Index on a Computed Column

dba.stackexchange.com

Is it acceptable to have circular foreign key references\How to avoid them?

dba.stackexchange.com

Why are multiple COUNT faster than one SUM with CASE?

dba.stackexchange.com

How to use COLUMNS_UPDATED to check if any of certain columns are updated?

dba.stackexchange.com

Is there a word/phrase for "unperformant"?

english.stackexchange.com

How can I stop continuous failed logins on SQL Server

dba.stackexchange.com

CDC system tables missing from backup

dba.stackexchange.com

Why would SQL Server ignore an index?

dba.stackexchange.com

Windows OS level scheduled disk defragment tasks and SQL data volumes

dba.stackexchange.com

Statistics: CPU Time vs Elapsed Time. What is more important?

dba.stackexchange.com

current community

your communities

more stack exchange communities

Stack Exchange

Hannah Vernon

MAXDOP setting algorithm for SQL Server

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

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

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

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

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

What can cause a mirroring session to timeout then failover?

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

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

Multi-statement TVF vs Inline TVF Performance