Database Administrators
Profile Activity
Meta user
Network profile
27,877
reputation
3
41
80

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.

640
answers
1
question
~3.0m
people reached
  • York, UK
  • Member for 10 years, 3 months
  • 1,182 profile views
  • Last seen 30 mins ago

Communities (30)

Top network posts

Top tags (323)

Score 1,207
Posts 276
Posts % 43
Score 581
Posts 136
Score 417
Posts 77
Score 413
Posts 40
Score 224
Posts 73
Score 153
Posts 57
View all tags →

Top posts (641)

All Questions Answers
Votes Newest
187 When should I use a unique constraint instead of a unique index? Jan 4 '11
149 How can I optimize a mysqldump of a large database? Jan 3 '11
77 Index Seek vs Index Scan May 20 '13
31 Use CASE to select columns in UPDATE query? Apr 12 '13
27 What are reasons **NOT** to use the MEMORY storage engine in MySQL? Mar 20 '11
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
22 How should deletions be handled in the database? Jan 4 '11
22 Why should an application not use the sa account Apr 3 '13
19 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? Jan 29
View all questions and answers →

Badges (124)

Gold

3

Rarest

Silver

41

Rarest

Bronze

80

Rarest

View all badges →

Your privacy

By clicking “Accept all cookies”, you agree Stack Exchange can store cookies on your device and disclose information in accordance with our Cookie Policy.