David Spillett

less info

network profile

3,434 reputation

815

bio	website
	location
	age
visits	member for	1 year, 4 months
	seen	May 17 at 15:12
stats	profile views	94

summary answers questions tags badges favorites bounties reputation activity

41 Answers

votes activity newest

27	How can I optimize a mysqldump of a large database?
21	Do I need separate indexes for each type of query, or will one multi-column index work?
20	When should I use a unique constraint instead of a unique index?
18	How should deletions be handled in the database?
15	Is "CREATE INDEX` in MySQL a Linear Operation?

view more

3,434 Reputation

+10	SQL Server Management Studio for a remote database
+35	When is it OK to shrink a Database?
+10	Is "CREATE INDEX` in MySQL a Linear Operation?
+10	When should I use a unique constraint instead of a unique index?

view more

1 Question

votes activity newest

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

47 Tags

108 sql-server × 13	35 sql-server-2008 × 4
93 mysql × 11	35 innodb × 2
66 index × 5	28 performance × 3
54 sql × 11	27 best-practices × 2
37 sql-server-2005 × 7	27 mysql-5

view more

12 Accounts

	Server Fault	15,536 rep	1234
	Super User	14,266 rep	1331
	Database Administrators	3,434 rep	815
	Webmasters	601 rep	14
	Unix and Linux	576 rep	14

23 Badges

recent class name

Good Answer	Enthusiast
Yearling	Beta
Nice Answer × 8	Commentator
Student	Organizer
Enlightened × 4	Mortarboard

view more

0 Active bounties

active offered earned

This user has no active bounties

6 Votes Cast

all time			by type
6	up		2	question
0	down		4	answer

view more

Database Administrators - Stack Exchange works best with JavaScript enabled