Tour
About Us
Meta
Loading…
current community
Stack Exchange
chat
Meta Stack Exchange
your communities
Sign up
or
log in
to customize your list.
more stack exchange communities
company blog
Log in
Stack Exchange
All Sites
Top Users
Digests
Hannah Vernon
Canada
https://www.sqlserverscience.com/
My pronouns are she/her.
top
accounts
reputation
activity
subscriptions
Top Questions
75
votes
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
1
2
3
4
5
6
next
Top Answers
137
The company’s commitment to rebuilding the relationship with you, our community
meta.stackexchange.com
92
Best practice between using LEFT JOIN or NOT EXISTS
dba.stackexchange.com
85
Is there any limit to the number of databases you can put on one SQL server?
dba.stackexchange.com
58
What happens if I buy Bitcoins and the price goes down?
bitcoin.stackexchange.com
47
How to determine if there are [idle connections with] uncommitted transactions in PostgreSQL?
dba.stackexchange.com
47
Performance of a=0 and b=0 and ... z=0 vs a+b+c+d=0
dba.stackexchange.com
45
CPU clock speed versus CPU core count - higher GHz, or more cores for SQL Server?
dba.stackexchange.com
45
Which database could handle storage of billions/trillions of records?
dba.stackexchange.com
45
Eliminate Key Lookup (Clustered) operator that slows down performance
dba.stackexchange.com
45
varchar(255) or varchar(256)?
dba.stackexchange.com
33
SQL Server Row by Row Access
dba.stackexchange.com
33
Max number of user connections
dba.stackexchange.com
26
Why would a primary key value change?
dba.stackexchange.com
26
What is the quickest way to purge data?
dba.stackexchange.com
26
Preferred way to store DateTime
dba.stackexchange.com
25
Transaction in a stored procedure
dba.stackexchange.com
24
Reasons for avoiding large ID values
dba.stackexchange.com
24
Database design : preferred field length for file paths
stackoverflow.com
23
tSQL - Conversion from varchar to numeric works for all but integer
stackoverflow.com
23
Create SQL Randomized Date of Birth
dba.stackexchange.com
22
Is there a word/phrase for "unperformant"?
english.stackexchange.com
22
Starting the Prompt Design Site: A New Home in our Stack Exchange Neighborhood
meta.stackexchange.com
22
Unable to create a Filtered Index on a Computed Column
dba.stackexchange.com
21
Is it acceptable to have circular foreign key references\How to avoid them?
dba.stackexchange.com
20
How to use COLUMNS_UPDATED to check if any of certain columns are updated?
dba.stackexchange.com
20
Is ALTER TABLE ... DROP COLUMN really a metadata only operation?
dba.stackexchange.com
20
Why are multiple COUNT faster than one SUM with CASE?
dba.stackexchange.com
19
Statistics: CPU Time vs Elapsed Time. What is more important?
dba.stackexchange.com
19
CDC system tables missing from backup
dba.stackexchange.com
19
Adding Nullable Column To Production DB taking too much time
dba.stackexchange.com
1
2
3
4
5
…
10
next
Stack Exchange works best with JavaScript enabled