Martin Smith

London, United Kingdom

profile for Martin Smith on Stack Exchange, a network of free, community-driven Q&A sites

top accounts reputation activity subscriptions

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

sql-server t-sql temporary-tables table-variable asked Apr 11, 2012 at 22:22

dba.stackexchange.com

57 votes

How to combine date and time to datetime2 in SQL Server?

sql-server datatypes date time datetime2 asked Oct 13, 2013 at 13:44

dba.stackexchange.com

52 votes

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

feature-request status-completed community-wiki asked Nov 14, 2012 at 10:01

meta.stackexchange.com

40 votes

Performance of Non Clustered Indexes on Heaps vs Clustered Indexes

sql-server clustered-index asked Feb 23, 2011 at 17:19

dba.stackexchange.com

40 votes

Optimising plans with XML readers

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

dba.stackexchange.com

38 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, 2012 at 21:30

dba.stackexchange.com

37 votes

Is there any personal benefit in formally cancelling a (non-refundable) flight?

air-travel tickets cancellations asked May 10, 2014 at 20:28

travel.stackexchange.com

33 votes

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

sql sql-server sql-server-2008 database-performance database-cursor asked Oct 23, 2011 at 21:01

stackoverflow.com

30 votes

User signing up to many stackexchange sites and offering the association bonus as a bounty

discussion bounty bonus-reputation asked Sep 4, 2017 at 21:50

meta.stackexchange.com

29 votes

Why does the estimated cost of (the same) 1000 seeks on a unique index differ in these plans?

sql-server sql-server-2014 optimization asked Sep 15, 2016 at 16:50

dba.stackexchange.com

Top Answers

1590

How to drop a table if it exists?

stackoverflow.com

1169

How to check if a column exists in a SQL Server table

stackoverflow.com

975

What is the difference between "INNER JOIN" and "OUTER JOIN"?

stackoverflow.com

951

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

stackoverflow.com

799

NOT IN vs NOT EXISTS

stackoverflow.com

795

How can I remove duplicate rows?

stackoverflow.com

733

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

dba.stackexchange.com

589

SQL RANK() versus ROW_NUMBER()

stackoverflow.com

536

MySQL SELECT only not null values

stackoverflow.com

501

Changing the maximum length of a varchar column?

stackoverflow.com

497

How to check for Is not Null And Is not Empty string in SQL server?

stackoverflow.com

458

Creating an index on a table variable

stackoverflow.com

401

When should I use a table variable vs temporary table in sql server?

stackoverflow.com

372

How can I update top 100 records in SQL server?

stackoverflow.com

364

What do Clustered and Non-Clustered index actually mean?

stackoverflow.com

322

How do I perform an IF...THEN in an SQL SELECT?

stackoverflow.com

313

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

stackoverflow.com

280

Which are more performant, CTE or temporary tables?

stackoverflow.com

268

SQL NOT IN not working

stackoverflow.com

255

SQL NVARCHAR and VARCHAR Limits

stackoverflow.com

255

How to delete the top 1000 rows from a table using Sql Server 2008?

stackoverflow.com

241

Drop a temporary table if it exists

stackoverflow.com

234

How to check if a function exists in a SQL database?

stackoverflow.com

227

Real life example, when to use OUTER / CROSS APPLY in SQL

stackoverflow.com

215

How do I escape reserved words used as column names? MySQL/Create Table

stackoverflow.com

197

How do I UPDATE from a SELECT in SQL Server?

stackoverflow.com

192

Identity increment is jumping in SQL Server database

stackoverflow.com

188

Add column to SQL Server

stackoverflow.com

174

SQL Update from One Table to Another Based on a ID Match

stackoverflow.com

164

SQL Server: Maximum character length of object names

stackoverflow.com