Hannah Vernon

Canada

https://www.sqlserverscience.com/

Hannah Vernon

My pronouns are she/her.

top accounts reputation activity subscriptions

MAXDOP setting algorithm for SQL Server

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

dba.stackexchange.com

40 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

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

31 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

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

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

26 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

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

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

Best practice between using LEFT JOIN or NOT EXISTS

dba.stackexchange.com

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

dba.stackexchange.com

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

bitcoin.stackexchange.com

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

dba.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

Eliminate Key Lookup (Clustered) operator that slows down performance

dba.stackexchange.com

varchar(255) or varchar(256)?

dba.stackexchange.com

SQL Server Row by Row Access

dba.stackexchange.com

Max number of user connections

dba.stackexchange.com

Why would a primary key value change?

dba.stackexchange.com

What is the quickest way to purge data?

dba.stackexchange.com

Preferred way to store DateTime

dba.stackexchange.com

Transaction in a stored procedure

dba.stackexchange.com

Reasons for avoiding large ID values

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

Create SQL Randomized Date of Birth

dba.stackexchange.com

Is there a word/phrase for "unperformant"?

english.stackexchange.com

Starting the Prompt Design Site: A New Home in our Stack Exchange Neighborhood

meta.stackexchange.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

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

dba.stackexchange.com

Is ALTER TABLE ... DROP COLUMN really a metadata only operation?

dba.stackexchange.com

Why are multiple COUNT faster than one SUM with CASE?

dba.stackexchange.com

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

dba.stackexchange.com

CDC system tables missing from backup

dba.stackexchange.com

Adding Nullable Column To Production DB taking too much time

dba.stackexchange.com