David Spillett

less info

network profile

4,843 reputation

1126

bio	website
	location
	age
visits	member for	2 years, 5 months
	seen	1 hour ago
stats	profile views	130

summary answers questions tags badges favorites bounties reputation activity

76 Answers

votes activity newest

32	How can I optimize a mysqldump of a large database?
27	When should I use a unique constraint instead of a unique index?
22	Do I need separate indexes for each type of query, or will one multi-column index work?
20	How should deletions be handled in the database?
17	Why should an application not use the sa account

view more

4,843 Reputation

+10	Help wrapping my mind around many-to-many relationships
+40	trigger is not working properly
+20	What is the timeout of a query in SQL Server 2008
+10	NULL or NOT NULL by default?

view more

1 Question

votes activity newest

2	Optimising a Database Shrink (in terms of speed and reducing fragmentation)

76 Tags

170 sql-server × 28	57 performance × 8
128 mysql × 20	53 sql-server-2005 × 8
98 sql × 21	41 innodb × 2
95 index × 7	36 database-design × 6
66 sql-server-2008 × 12	34 best-practices × 2

view more

15 Accounts

	Server Fault	17,108 rep	1743
	Super User	16,187 rep	2136
	Database Administrators	4,843 rep	1126
	Webmasters	681 rep	25
	Unix & Linux	606 rep	24

19 Badges

recent class name

mysql	Revival
Critic	Quorum
Nice Answer × 13	Yearling × 2
Good Answer × 2	Enlightened × 5
sql-server	Custodian

view more

0 Active bounties

active offered earned

This user has no active bounties

9 Votes Cast

all time			by type			month		week
8	up		3	question		1		1
1	down		6	answer		1		1

Technology			Life / Arts	Culture / Recreation	Science	Other
Stack Overflow Server Fault Super User Web Applications Ask Ubuntu Webmasters Game Development TeX - LaTeX	Programmers Unix & Linux Ask Different (Apple) WordPress Answers Geographic Information Systems Electrical Engineering Android Enthusiasts IT Security	Database Administrators Drupal Answers SharePoint User Experience Mathematica more (14)	Photography Science Fiction & Fantasy Seasoned Advice (cooking) Home Improvement more (13)	English Language & Usage Skeptics Mi Yodeya (Judaism) Travel Christianity Arqade (gaming) Bicycles Role-playing Games more (21)	Mathematics Cross Validated (stats) Theoretical Computer Science Physics more (7)	Stack Apps Meta Stack Overflow Area 51 Stack Overflow Careers

site design / logo © 2013 stack exchange inc; user contributions licensed under cc-wiki with attribution required

rev 2013.6.19.749

Database Administrators Stack Exchange works best with JavaScript enabled