Database Administrators
Meta user
Network profile
25,006
reputation
3
36
72

David Spillett

Bit of a jack of many trades with experience everywhere along the stack from UI work all the way down to a bit of electronics passing through databases, networking, assembly and so forth along the way; though admittedly I'm a bit out of date in some areas. Professionally I'm currently trying to specialise more along a database admin/developer focus while still keeping an eye on what is going on elsewhere.

568
answers
1
question
~2.5m
people reached
  • York, UK
  • Member for 9 years
  • 1,015 profile views
  • Last seen 5 hours ago

Communities (29)

Top network posts

Top tags (295)

Score 1,070
Posts 243
Posts % 43
Score 536
Posts 127
Score 388
Posts 72
Score 373
Posts 32
Score 204
Posts 65
Score 132
Posts 43
View all tags →

Top posts (569) All Questions Answers | Votes Newest

162 When should I use a unique constraint instead of a unique index? Jan 4 '11
135 How can I optimize a mysqldump of a large database? Jan 3 '11
76 Index Seek vs Index Scan May 20 '13
27 Do I need separate indexes for each type of query, or will one multi-column index work? Jan 4 '11
27 What are reasons **NOT** to use the MEMORY storage engine in MySQL? Mar 20 '11
25 NULL or NOT NULL by default? Jan 3 '11
24 Use CASE to select columns in UPDATE query? Apr 12 '13
21 Why should an application not use the sa account Apr 3 '13
21 How should deletions be handled in the database? Jan 4 '11
18 What are the best practices for running SQL Server in a Virtual Machine? Mar 3 '11
View all questions and answers →

Badges (111)

Gold

3

Rarest

Silver

36

Rarest

Bronze

72

Rarest

View all badges →