Martin Smith

less info

network profile

7,729 reputation

21535

bio	website
	location	United Kingdom
	age
visits	member for	7 months
	seen	4 hours ago
stats	profile views	318

Email: stackoverflowmartinsmith@gmail.com

summary answers questions tags badges favorites 1 bounties reputation activity

110 Answers

votes activity newest

101	What's the difference between a temp table and table variable in SQL Server?
20	Why use both TRUNCATE and DROP?
16	Is NOLOCK always bad?
15	Using EXCEPT in a recursive common table expression
14	Determining how a schema change occurred?

view more

7,729 Reputation

+20	Why use both TRUNCATE and DROP?
+30	How are foreign key indexes helpful?
+10	SQL Server tempdb question
+5	What's the difference between a temp table and table variable in SQL Server?

view more

4 Questions

votes activity newest

53	What's the difference between a temp table and table variable in SQL Server?
18	Performance of Non Clustered Indexes on Heaps vs Clustered Indexes
9	Why is using a table variable more than twice as fast as a #temp table in this specific case?
3	Will {fn concat} work without issue in MySQL, SQL Server and Oracle?

74 Tags

543 sql-server × 86	64 sql-server-2005 × 11
231 sql × 23	46 sql-server-2008-r2 × 9
148 sql-server-2008 × 35	43 locking × 6
129 t-sql × 6	40 performance × 9
108 temp-tables × 4	29 constraint × 5

view more

14 Accounts

	Stack Overflow	89,983 rep	115996
	Database Administrators	7,729 rep	21535
	Meta Stack Overflow	1,164 rep	2714
	Server Fault	298 rep	16
	Super User	105 rep	5

52 Badges

recent class name

Investor	Good Question
Great Answer	Good Answer
Favorite Question	Popular Question
sql-server	Nice Question × 2
Notable Question	Nice Answer × 13

view more

1 Active bounty

active offered earned

+250	Why use both TRUNCATE and DROP?

view more

613 Votes Cast

all time			by type			month		week
572	up		155	question		5		1
41	down		458	answer		5		1

view more

Database Administrators - Stack Exchange works best with JavaScript enabled