Stack Exchange Network

Stack Exchange network consists of 174 Q&A communities including Stack Overflow, the largest, most trusted online community for developers to learn, share their knowledge, and build their careers.

Visit Stack Exchange

  7. current community

    your communities

    more stack exchange communities

    company blog
Meta User
Network Profile
21,418 reputation
2
31
67

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.

487 answers
1 question
~1.7m people reached
  • York, UK
  • Member for 7 years, 8 months
  • 787 profile views
  • Last seen 21 hours ago

Communities (27)

Top Network Posts

Top Tags (261)

Score 904
Posts 201
Posts % 41
Score 479
Posts 114
Score 315
Posts 95
Score 270
Posts 30
Score 163
Posts 55
Score 117
Posts 41
View all tags →

Top Posts (488) All Questions Answers | Votes Newest

132 When should I use a unique constraint instead of a unique index? Jan 4 '11
122 How can I optimize a mysqldump of a large database? Jan 3 '11
72 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
22 What are reasons *not* to use the MEMORY storage engine in MySQL? Mar 20 '11
21 Why should an application not use the sa account Apr 3 '13
20 Use CASE to select columns in UPDATE query? Apr 12 '13
20 How should deletions be handled in the database? Jan 4 '11
18 SQL Data types and SmallInt/TinyInt vs Regular Integer Sep 25 '17
View all questions and answers →

Badges (100)

Gold 2

Rarest
Silver 31

Rarest
Bronze 67

Rarest
View all badges →