User Lamak

475 votes

2 answers

249k views

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

Martin Smith

78.5k

asked Apr 11, 2012 at 22:22

186 votes

7 answers

200k views

What's the difference between a CTE and a Temp Table?

sql-server cte

Rachel

8,289

asked Feb 15, 2012 at 16:47

116 votes

4 answers

20k views

Why are numbers tables "invaluable"?

sql-server

Jeff Atwood

2,314

asked Jan 25, 2012 at 0:45

104 votes

9 answers

42k views

Where are some useful SQL puzzles to teach SQL in a workplace?

learning

testerab

477

asked Jan 3, 2011 at 21:26

102 votes

8 answers

20k views

Does SQL Server read all of a COALESCE function even if the first argument is not NULL?

sql-server null coalesce

Curtis

1,245

asked Sep 19, 2011 at 15:06

89 votes

5 answers

24k views

Why can't RDBM's cluster the way NoSQL does?

clustering nosql scalability relational-theory

fregas

1,021

asked Feb 17, 2013 at 16:19

80 votes

4 answers

196k views

How to identify which query is filling up the tempdb transaction log?

sql-server sql-server-2008 sql-server-2005 transaction-log tempdb

prasanth

1,023

asked Jun 25, 2012 at 14:49

68 votes

4 answers

57k views

Index Seek vs Index Scan

sql-server sql-server-2005 performance index execution-plan

Greg

3,152

asked May 20, 2013 at 6:32

63 votes

1 answer

22k views

What event information can I get by default from SQL Server?

sql-server extended-events

Aaron Bertrand

177k

asked Aug 13, 2013 at 16:14

60 votes

2 answers

9k views

Cast to date is sargable but is it a good idea?

sql-server

Mikael Eriksson

21.7k

asked Feb 4, 2013 at 7:58

53 votes

4 answers

290k views

What's the easiest way to create a temp table in SQL Server that can hold the result of a stored procedure?

sql-server t-sql stored-procedures

Just a learner

2,512

asked Feb 13, 2012 at 8:10

51 votes

4 answers

15k views

What are Objective Business Reasons to Prefer SQL Server 2012 over 2008 R2?

sql-server sql-server-2008 sql-server-2008-r2 sql-server-2012

usr

7,180

asked Mar 9, 2012 at 19:41

51 votes

3 answers

84k views

How do I get back some deleted records?

sql-server sql-server-2008 recovery

user755

asked Jan 31, 2011 at 13:46

42 votes

3 answers

18k views

Parameter Sniffing vs VARIABLES vs Recompile vs OPTIMIZE FOR UNKNOWN

sql-server-2008 execution-plan cache

RThomas

3,306

asked Jan 28, 2013 at 22:29

40 votes

3 answers

4k views

Unexpected scans during delete operation using WHERE IN

sql-server-2008-r2 query optimization

Mark S. Rasmussen

1,465

asked May 31, 2012 at 14:49

40 votes

2 answers

22k views

What does a DBA have to know about SSAS?

sql-server ssas

ivanmp

2,303

asked Mar 7, 2012 at 20:25

39 votes

3 answers

6k views

Performance of Non Clustered Indexes on Heaps vs Clustered Indexes

sql-server clustered-index

Martin Smith

78.5k

asked Feb 23, 2011 at 17:19

36 votes

2 answers

4k views

Why are Denali sequences supposed to perform better than identity columns?

sql-server sql-server-2012 sequence

bernd_k

11.8k

asked Mar 8, 2011 at 20:48

34 votes

4 answers

5k views

Still wrong to start the name of a user stored procedure with sp_?

sql-server-2008-r2 stored-procedures

user5147

asked Oct 3, 2012 at 11:33

33 votes

2 answers

6k views

As a DBA, how would I go about transitioning from Oracle to SQL Server?

sql-server oracle

Philᵀᴹ

30.9k

asked Apr 23, 2012 at 9:47

31 votes

1 answer

10k views

Guidelines for full-text index maintenance

sql-server full-text-search index-maintenance

Geoff Patterson

8,167

asked Jul 22, 2015 at 19:48

31 votes

1 answer

62k views

Change length of varchar on live prod table

sql-server sql-server-2008-r2

anataliocs

435

asked Mar 14, 2012 at 16:20

27 votes

1 answer

7k views

What date/time literal formats are LANGUAGE and DATEFORMAT safe?

sql-server t-sql datetime date-format string-representation

Aaron Bertrand

177k

asked Mar 10, 2017 at 2:47

27 votes

4 answers

17k views

SQL Server "empty table" is slow after deleting all (12 million) records?

sql-server sql-server-2008

TheDramaLlama

asked Mar 8, 2012 at 0:16

26 votes

2 answers

1k views

Why does a subquery reduce the row estimate to 1?

sql-server sql-server-2016 cardinality-estimates

Joe Obbish

30.7k

asked Apr 21, 2017 at 15:33

23 votes

1 answer

7k views

Is my SQL Server patched?

sql-server

billinkc

15.6k

asked Sep 22, 2015 at 16:35

23 votes

1 answer

27k views

SQL query for combinations without repetition

sql-server performance query-performance

coditori

1,012

asked Dec 2, 2012 at 5:45

23 votes

2 answers

26k views

Performance difference between Clustered and Non Clustered Index

sql-server sql-server-2008 sql-server-2005

Pankaj Garg

asked May 29, 2012 at 17:32

21 votes

1 answer

3k views

What's the anatomy of a columnstore index?

sql-server index sql-server-2012 columnstore

JNK

17.7k

asked Jan 9, 2012 at 21:36

21 votes

1 answer

6k views

Should I be alarmed by this NO JOIN PREDICATE warning?

sql-server sql-server-2008-r2 execution-plan warning

swasheck

10.4k

asked Feb 5, 2013 at 23:56

Stack Exchange Network

current community

your communities

more stack exchange communities

81 Bookmarks

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

What's the difference between a CTE and a Temp Table?

Why are numbers tables "invaluable"?

Where are some useful SQL puzzles to teach SQL in a workplace?

Does SQL Server read all of a COALESCE function even if the first argument is not NULL?

Why can't RDBM's cluster the way NoSQL does?

How to identify which query is filling up the tempdb transaction log?

Index Seek vs Index Scan

What event information can I get by default from SQL Server?

Cast to date is sargable but is it a good idea?

What's the easiest way to create a temp table in SQL Server that can hold the result of a stored procedure?

What are Objective Business Reasons to Prefer SQL Server 2012 over 2008 R2?

How do I get back some deleted records?

Parameter Sniffing vs VARIABLES vs Recompile vs OPTIMIZE FOR UNKNOWN

Unexpected scans during delete operation using WHERE IN

What does a DBA have to know about SSAS?

Performance of Non Clustered Indexes on Heaps vs Clustered Indexes

Why are Denali sequences supposed to perform better than identity columns?

Still wrong to start the name of a user stored procedure with sp_?

As a DBA, how would I go about transitioning from Oracle to SQL Server?

Guidelines for full-text index maintenance

Change length of varchar on live prod table

What date/time literal formats are LANGUAGE and DATEFORMAT safe?

SQL Server "empty table" is slow after deleting all (12 million) records?

Why does a subquery reduce the row estimate to 1?

Is my SQL Server patched?

SQL query for combinations without repetition

Performance difference between Clustered and Non Clustered Index

What's the anatomy of a columnstore index?

Should I be alarmed by this NO JOIN PREDICATE warning?