Martin Smith

less info

network profile

17,427 reputation

43578

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

Email: stackoverflowmartinsmith@gmail.com

summary answers questions tags badges favorites bounties reputation activity

209 Answers

votes activity newest

199	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,427 Reputation

+10	How can I prevent SSMS from re-writing my code when saving a view?
+10	What's the difference between a temp table and table variable in SQL Server?
+5	What's the difference between a temp table and table variable in SQL Server?
+15	Find top by values by percents using range in SQL Server

view more

7 Questions

votes activity newest

116	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	Optimising plans with XML readers
12	Why is using a table variable more than twice as fast as a #temp table in this specific case?
11	What is the correct result for this query?

view more

105 Tags

1k sql-server × 151	138 sql-server-2008-r2 × 22
486 sql × 50	111 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	126,485 rep	12128187
	Database Administrators	17,427 rep	43578
	Meta Stack Overflow	1,650 rep	2922
	Server Fault	308 rep	18
	Super User	120 rep	7

48 Badges

recent class name

Caucus × 3	Great Question
Enlightened × 18	Announcer × 2
Nice Answer × 32	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,408 Votes Cast

all time			by type			month		week		day
1,298	up		339	question		13		1		1
110	down		1,069	answer		13		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 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.17.690

Database Administrators Stack Exchange works best with JavaScript enabled