Database Administrators
Meta user
Network profile
24,015
reputation
3
34
71

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.

542
answers
1
question
~2.3m
people reached
  • York, UK
  • Member for 8 years, 8 months
  • 944 profile views
  • Last seen Sep 11 at 19:46

Communities (29)

Top network posts

Top tags (286)

Score 1,018
Posts 231
Posts % 43
Score 525
Posts 123
Score 362
Posts 31
Score 298
Posts 36
Score 201
Posts 64
Score 125
Posts 40
View all tags →

Top posts (543) All Questions Answers | Votes Newest

153 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
75 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
25 NULL or NOT NULL by default? Jan 3 '11
25 What are reasons *not* to use the MEMORY storage engine in MySQL? Mar 20 '11
22 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 (108)

Gold

3

Rarest

Silver

34

Rarest

Bronze

71

Rarest

View all badges →