Database Administrators
Hannah Vernon's user avatar
Hannah Vernon's user avatar
Hannah Vernon's user avatar
Hannah Vernon
Moderator
  • Member for 10 years, 1 month
  • Last seen this week
Profile Activity
Stats
67,640
reputation
5.9m
reached
1,303
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

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
161
silver badges
299
bronze badges
Top tags
View all tags
4,417
Score
1,086
Posts
80
Posts %
726
Score
189
Posts
14
Posts %
538
Score
86
Posts
6
Posts %
491
Score
157
Posts
12
Posts %
474
Score
112
Posts
8
Posts %
417
Score
100
Posts
7
Posts %
Top posts
View all questions and answers
All Questions Answers
Score Newest
answer
85
Is there any limit to the number of databases you can put on one SQL server?
Aug 29, 2017
answer
77
Best practice between using LEFT JOIN or NOT EXISTS
Nov 13, 2015
question
75
MAXDOP setting algorithm for SQL Server
Mar 12, 2013
answer
47
Performance of a=0 and b=0 and ... z=0 vs a+b+c+d=0
Mar 29, 2016
answer
45
CPU clock speed versus CPU core count - higher GHz, or more cores for SQL Server?
Apr 4, 2017
answer
44
Which database could handle storage of billions/trillions of records?
Mar 28, 2013
answer
42
varchar(255) or varchar(256)?
Aug 11, 2017
answer
41
Eliminate Key Lookup (Clustered) operator that slows down performance
Aug 10, 2017
answer
38
How to determine if there are [idle connections with] uncommitted transactions in PostgreSQL?
Apr 11, 2013
question
36
Why does CREATE INDEX ... WITH ONLINE=ON block access to the table over a period of minutes?
Apr 29, 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.