Martin Smith

less info

network profile

17,497 reputation

43579

bio	website
	location	United Kingdom
	age
visits	member for	1 year, 7 months
	seen	2 hours ago
stats	profile views	1,395

Email: stackoverflowmartinsmith@gmail.com

summary answers questions tags badges favorites bounties reputation activity

209 Answers

votes activity newest

200	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?
17	how do I insert a default row?
17	Determining how a schema change occurred?

view more

17,497 Reputation

+10	Why are Denali sequences supposed to perform better than identity columns?
+10	Why is using a table variable more than twice as fast as a #temp table in this specific case?
+5	Why is using a table variable more than twice as fast as a #temp table in this specific case?
+10	What's the difference between a temp table and table variable in SQL Server?

view more

7 Questions

votes activity newest

117	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
11	What is the correct result for this query?

view more

105 Tags

1k sql-server × 151	138 sql-server-2008-r2 × 22
487 sql × 50	112 sql-server-2005 × 19
332 sql-server-2008 × 64	91 sql-server-2012 × 14
290 t-sql × 17	65 performance × 11
220 temp-tables × 6	59 index × 14

view more

18 Accounts

	Stack Overflow	127,060 rep	12129190
	Database Administrators	17,497 rep	43579
	Meta Stack Overflow	1,650 rep	2922
	Server Fault	308 rep	18
	Super User	120 rep	7

48 Badges

recent class name

Nice Answer × 33	Great Question
Caucus × 3	Announcer × 2
Enlightened × 18	sql-server-2008-r2
Necromancer × 5	Custodian × 6
Popular Question × 4	Nice Question × 5

view more

0 Active bounties

active offered earned

This user has no active bounties

1,410 Votes Cast

all time			by type			month		week		day
1,300	up		339	question		15		3		1
110	down		1,071	answer		15		3		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 Arqade (gaming) Bicycles Role-playing Games more (22)	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.5.23.698

Database Administrators Stack Exchange works best with JavaScript enabled