Martin Smith

less info

network profile

18,132 reputation

43782

bio	website
	location	United Kingdom
	age
visits	member for	1 year, 8 months
	seen	24 mins ago
stats	profile views	1,440

Email: stackoverflowmartinsmith@gmail.com

summary answers questions tags badges favorites bounties reputation activity

216 Answers

votes activity newest

207	What's the difference between a temp table and table variable in SQL Server?
27	Why use both TRUNCATE and DROP?
24	Is NOLOCK always bad?
18	Determining how a schema change occurred?
17	how do I insert a default row?

view more

18,132 Reputation

+10	Determining how a schema change occurred?
+115	What is the difference between these two index declarations and do I need both?
+10	Nonclustered index is faster than clustered index?
+10	Need to divide single column into multiple columns

view more

7 Questions

votes activity newest

119	What's the difference between a temp table and table variable in SQL Server?
22	Performance of Non Clustered Indexes on Heaps vs Clustered Indexes
13	Why is using a table variable more than twice as fast as a #temp table in this specific case?
13	Optimising plans with XML readers
12	What is the correct result for this query?

view more

110 Tags

1k sql-server × 157	145 sql-server-2008-r2 × 24
505 sql × 52	116 sql-server-2005 × 20
335 sql-server-2008 × 64	92 sql-server-2012 × 14
301 t-sql × 18	91 index × 18
229 temp-tables × 6	65 performance × 11

view more

19 Accounts

	Stack Overflow	130,757 rep	12138195
	Database Administrators	18,132 rep	43782
	Meta Stack Overflow	1,751 rep	2922
	Server Fault	318 rep	18
	Super User	120 rep	7

49 Badges

recent class name

Enlightened × 19	Necromancer × 5
Nice Answer × 35	Popular Question × 4
sql-server-2005	Great Question
Constituent × 2	Announcer × 2
Caucus × 3	sql-server-2008-r2

view more

0 Active bounties

active offered earned

This user has no active bounties

1,451 Votes Cast

all time			by type			month		week
1,334	up		351	question		35		18
117	down		1,100	answer		35		18

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.20.753

Database Administrators Stack Exchange works best with JavaScript enabled