Martin Smith

United Kingdom

Email: stackoverflowmartinsmith@gmail.com

top accounts reputation activity favorites subscriptions

What's the difference between a temp table and table variable in SQL Server?

sql-server sql t-sql temp-tables asked Apr 11 '12 at 22:22

dba.stackexchange.com

30 votes

Don't auto community wiki answers to questions made CW through too many edits

feature-request community-wiki asked Nov 14 '12 at 10:01

meta.stackoverflow.com

25 votes

When will a FAST_FORWARD cursor have a work table (and is this something to avoid)?

sql sql-server sql-server-2008 cursor database-performance asked Oct 23 '11 at 21:01

stackoverflow.com

22 votes

Performance of Non Clustered Indexes on Heaps vs Clustered Indexes

sql-server clustered-index asked Feb 23 '11 at 17:19

dba.stackexchange.com

21 votes

Can more be done to stop off topic Facebook questions?

discussion mini-site facebook.stackoverflow asked Aug 27 '11 at 22:06

meta.stackoverflow.com

15 votes

Why was my comment auto deleted?

support specific-question deleted-comments asked Feb 14 at 17:01

meta.stackoverflow.com

14 votes

User deletes questions as soon as they get answer

support specific-question asked Jan 10 '11 at 5:24

meta.stackoverflow.com

13 votes

Why is using a table variable more than twice as fast as a #temp table in this specific case?

sql-server sql temp-tables asked Feb 18 '12 at 21:30

dba.stackexchange.com

13 votes

Optimising plans with XML readers

sql-server sql-server-2012 execution-plan xml database-internals asked Dec 20 '12 at 20:51

dba.stackexchange.com

12 votes

Close as duplicate circle detection bug

support bug status-completed vote-to-close asked Sep 8 '11 at 8:39

meta.stackoverflow.com

Top Answers

240

What is the significance of 1/1/1753 in SQL Server?

stackoverflow.com

211

How to check if column exists in SQL Server table

stackoverflow.com

206

How can I remove duplicate rows?

stackoverflow.com

201

What's the difference between a temp table and table variable in SQL Server?

dba.stackexchange.com

Can we have multiple <tbody> in same <table>?

stackoverflow.com

How to drop table if exists in SQL Server 2005?

stackoverflow.com

NOT IN vs NOT EXISTS

stackoverflow.com

how can I Update top 100 records in sql server

stackoverflow.com

is there an advantage to varchar(500) over varchar(8000)?

stackoverflow.com

MySQL SELECT only not null values

stackoverflow.com

Can select * usage ever be justified?

stackoverflow.com

SQL update from one Table to another based on a ID match

stackoverflow.com

Code golf: Word frequency chart

stackoverflow.com

How to check if a function exists on a SQL database

stackoverflow.com

table-valued function vs view

stackoverflow.com

SQL NOT IN not working

stackoverflow.com

Why use both TRUNCATE and DROP?

dba.stackexchange.com

UPDATE from SELECT using SQL Server

stackoverflow.com

MS SQL compare dates?

stackoverflow.com

Drop all databases from server

stackoverflow.com

Subquery using Exists 1 or Exists *

stackoverflow.com

Is NOLOCK always bad?

dba.stackexchange.com

How do you perform an IF…THEN in an SQL SELECT?

stackoverflow.com

Equivalent of Oracle's RowID in SQL Server

stackoverflow.com

Mysql AVG to ignore zero

stackoverflow.com

SQL RANK() versus ROW_NUMBER()

stackoverflow.com

How to return default value from SQL query

stackoverflow.com

CASE IN statement with multiple values

stackoverflow.com

Multiple INSERT statements vs. single INSERT with multiple VALUES

stackoverflow.com

How do I view the full content of a text or varchar(MAX) column in SQL Server 2008 Management Studio?

stackoverflow.com