Skip to main content
OverflowAI is here! AI power for your Stack Overflow for Teams knowledge community. Learn more
David Spillett's user avatar
David Spillett's user avatar
David Spillett's user avatar
David Spillett
  • Member for 13 years, 4 months
  • Last seen this week
  • York, UK
226 votes
Accepted

When should I use a unique constraint instead of a unique index?

170 votes
Accepted

How can I optimize a mysqldump of a large database?

80 votes
Accepted

Index Seek vs Index Scan

32 votes
Accepted

Use CASE to select columns in UPDATE query?

30 votes
Accepted

What are reasons **NOT** to use the MEMORY storage engine in MySQL?

28 votes
Accepted

Do I need separate indexes for each type of query, or will one multi-column index work?

25 votes
Accepted

NULL or NOT NULL by default?

23 votes

How should deletions be handled in the database?

23 votes

Why should an application not use the sa account

23 votes
Accepted

Should I call my UUID primary key column ID or not?

22 votes

What is the best way to get a random ordering?

20 votes
Accepted

Is there any time where we should avoid cascading delete?

19 votes
Accepted

As there is no unsigned int in SQL Server doesn't an Identity Seed of -2,147,483,648 make more sense for large tables?

18 votes
Accepted

What are the best practices for running SQL Server in a Virtual Machine?

18 votes

Why does MySQL not have hash indices on MyISAM or InnoDB?

18 votes
Accepted

SQL Data types and SmallInt/TinyInt vs Regular Integer

17 votes

Why do primary keys have names of their own?

16 votes
Accepted

Is "CREATE INDEX` in MySQL a Linear Operation?

16 votes
Accepted

When is it OK to shrink a Database?

16 votes
Accepted

rebuild on clustered index, why does datasize shrink?

15 votes

Downgrading from SQL Server 2008 to 2005

15 votes
Accepted

Ordering of table is based on Clustered index or non clustered primary key?

14 votes

DELETE statement conflicted with the REFERENCE constraint

14 votes
Accepted

Database "frozen" on ALTER TABLE

14 votes
Accepted

SQL Server: SET NOCOUNT ON still returning data

14 votes

Linked Server Risks

14 votes
Accepted

Why does auto increment jumps by more than the number of rows inserted?

13 votes
Accepted

SQL Server 2012 compress column for whole table

13 votes
Accepted

What kind of database to store Quotes

12 votes

Is it REALLY possible that the order will not be guaranteed for this particular redundant derived table?

1
2 3 4 5
25