Database Administrators
Profile Activity
Meta user
Network profile
25,934
reputation
3
38
75

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.

588
answers
1
question
~2.7m
people reached
  • York, UK
  • Member for 9 years, 7 months
  • 1,102 profile views
  • Last seen 17 hours ago

Communities (29)

Top network posts

Top tags (304)

Score 1,118
Posts 250
Posts % 42
Score 555
Posts 131
Score 400
Posts 73
Score 388
Posts 33
Score 209
Posts 65
Score 137
Posts 49
View all tags →

Top posts (589)

All Questions Answers
Votes Newest
174 When should I use a unique constraint instead of a unique index? Jan 4 '11
142 How can I optimize a mysqldump of a large database? Jan 3 '11
77 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
26 Use CASE to select columns in UPDATE query? Apr 12 '13
25 NULL or NOT NULL by default? Jan 3 '11
21 How should deletions be handled in the database? Jan 4 '11
21 Why should an application not use the sa account Apr 3 '13
18 What are the best practices for running SQL Server in a Virtual Machine? Mar 3 '11
View all questions and answers →

Badges (116)

Gold

3

Rarest

Silver

38

Rarest

Bronze

75

Rarest

View all badges →