2022 Developer Survey is open! Take survey.
Database Administrators
Sponsored by
Sponsored logo
user avatar
user avatar
user avatar
Hannah Vernon
Moderator
  • Member for 9 years, 9 months
  • Last seen this week
Profile Activity
Stats
67,088
reputation
5.6m
reached
1,292
answers
62
questions
Communities
View all
About

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.

Badges
View all badges
22
gold badges
158
silver badges
298
bronze badges
Top tags
View all tags
4,380
Score
1,081
Posts
80
Posts %
717
Score
189
Posts
14
Posts %
532
Score
86
Posts
6
Posts %
488
Score
157
Posts
12
Posts %
473
Score
112
Posts
8
Posts %
412
Score
99
Posts
7
Posts %
Top posts
View all questions and answers
All Questions Answers
Score Newest
answer
84
Is there any limit to the number of databases you can put on one SQL server?
Aug 29, 2017
question
76
MAXDOP setting algorithm for SQL Server
Mar 12, 2013
answer
73
Best practice between using LEFT JOIN or NOT EXISTS
Nov 13, 2015
answer
47
Performance of a=0 and b=0 and ... z=0 vs a+b+c+d=0
Mar 29, 2016
answer
44
CPU clock speed versus CPU core count - higher GHz, or more cores for SQL Server?
Apr 4, 2017
answer
43
Which database could handle storage of billions/trillions of records?
Mar 28, 2013
answer
42
varchar(255) or varchar(256)?
Aug 11, 2017
answer
39
Eliminate Key Lookup (Clustered) operator that slows down performance
Aug 10, 2017
answer
34
How to determine if there are [idle connections with] uncommitted transactions in PostgreSQL?
Apr 11, 2013
question
33
Handling concurrent access to a key table without deadlocks in SQL Server
Mar 13, 2013
Top Meta posts
23
59
20
Are two answers by a single person on one question A Good Thing™?
18
Minimal, Complete, and Verifiable Example
18
Disclosures, every post/comment or is profile enough?
15
Is this ageism or acceptable humour?
15
Should old questions that have no answers and are "too localized" or "too broad" be closed?
Top network posts
View all network posts
137
The company’s commitment to rebuilding the relationship with you, our community
58
What happens if I buy Bitcoins and the price goes down?
22
tSQL - Conversion from varchar to numeric works for all but integer
22
Database design : preferred field length for file paths
18
Is there a word/phrase for "unperformant"?

Your privacy

By clicking “Accept all cookies”, you agree Stack Exchange can store cookies on your device and disclose information in accordance with our Cookie Policy.