Hannah Vernon's user avatar
Hannah Vernon's user avatar
Hannah Vernon's user avatar
Hannah Vernon
Moderator
  • Member for 11 years, 6 months
  • Last seen this week
92 votes
Accepted

Best practice between using LEFT JOIN or NOT EXISTS

85 votes
Accepted

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

47 votes
Accepted

Eliminate Key Lookup (Clustered) operator that slows down performance

47 votes
Accepted

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

47 votes
Accepted

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

45 votes
Accepted

varchar(255) or varchar(256)?

45 votes

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

44 votes
Accepted

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

33 votes
Accepted

SQL Server Row by Row Access

33 votes
Accepted

Max number of user connections

26 votes
Accepted

What is the quickest way to purge data?

26 votes
Accepted

Transaction in a stored procedure

26 votes
Accepted

Why would a primary key value change?

26 votes
Accepted

Preferred way to store DateTime

24 votes

Reasons for avoiding large ID values

23 votes
Accepted

Create SQL Randomized Date of Birth

22 votes

Unable to create a Filtered Index on a Computed Column

21 votes
Accepted

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

20 votes
Accepted

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

20 votes
Accepted

Why are multiple COUNT faster than one SUM with CASE?

20 votes
Accepted

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

19 votes

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

19 votes
Accepted

CDC system tables missing from backup

19 votes
Accepted

Adding Nullable Column To Production DB taking too much time

18 votes
Accepted

How to find the query that is still holding a lock?

18 votes
Accepted

How can I stop continuous failed logins on SQL Server

18 votes
Accepted

Why is .bak file size increasing/doubling with each consecutive backup on SQL Server?

18 votes
Accepted

Why would SQL Server ignore an index?

18 votes
Accepted

Why SQL Server has 900 byte index size limit

18 votes
Accepted

Windows OS level scheduled disk defragment tasks and SQL data volumes

1
2 3 4 5
45