User Lamak

461

votes

2

answers

240k

views

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

May 13 at 19:14 Aaron Bertrand♦ 168k

182

votes

7

answers

182k

views

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

sql-server cte

Oct 4 '17 at 16:10 Community♦ 1

113

votes

4

answers

18k

views

Why are numbers tables “invaluable”?

sql-server

Mar 3 at 12:53 Aaron Bertrand♦ 168k

102

votes

8

answers

18k

views

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

sql-server null coalesce

Nov 4 at 5:35 Paul White♦ 57.2k

102

votes

9

answers

39k

views

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

learning

Dec 19 at 21:52 testerab 477

90

votes

5

answers

22k

views

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

clustering nosql scalability relational-theory

Sep 5 '18 at 8:11 Chris Travers 12k

72

votes

4

answers

174k

views

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

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

Apr 24 at 9:56 Community♦ 1

65

votes

4

answers

56k

views

Index Seek vs Index Scan

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

May 9 '17 at 9:40 David Spillett 26.3k

61

votes

1

answer

20k

views

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

sql-server extended-events

May 7 at 20:25 Community♦ 1

52

votes

4

answers

284k

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

Oct 8 '18 at 13:03 Aaron Bertrand♦ 168k

51

votes

3

answers

83k

views

How do I get back some deleted records?

sql-server sql-server-2008 recovery

Jul 16 at 14:51 Ronaldo 1,726

50

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

May 8 at 2:19 Aaron Bertrand♦ 168k

49

votes

2

answers

7k

views

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

sql-server

Nov 24 at 11:03 Paul White♦ 57.2k

41

votes

3

answers

18k

views

Parameter Sniffing vs VARIABLES vs Recompile vs OPTIMIZE FOR UNKNOWN

sql-server-2008 execution-plan cache

Mar 3 '16 at 17:56 Paul White♦ 57.2k

40

votes

3

answers

4k

views

Unexpected scans during delete operation using WHERE IN

sql-server-2008-r2 query optimization

Nov 10 at 9:48 Paul White♦ 57.2k

40

votes

2

answers

21k

views

What does a DBA have to know about SSAS?

sql-server ssas

Jan 3 '16 at 0:49 Community♦ 1

39

votes

3

answers

6k

views

Performance of Non Clustered Indexes on Heaps vs Clustered Indexes

sql-server clustered-index

Dec 13 '13 at 19:42 Jack Douglas 34.6k

36

votes

2

answers

4k

views

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

sql-server sql-server-2012 sequence

Apr 20 '16 at 12:40 Community♦ 1

33

votes

2

answers

6k

views

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

sql-server oracle

Oct 31 '16 at 9:53 Community♦ 1

33

votes

4

answers

5k

views

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

sql-server-2008-r2 stored-procedures

Mar 28 '17 at 18:36 Community♦ 1

30

votes

1

answer

8k

views

Guidelines for full-text index maintenance

sql-server full-text-search index-maintenance

May 12 '16 at 14:20 Community♦ 1

27

votes

4

answers

15k

views

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

sql-server sql-server-2008

Mar 8 '12 at 2:33 Community♦ 1

27

votes

1

answer

58k

views

Change length of varchar on live prod table

sql-server sql-server-2008-r2

Jun 2 '16 at 0:17 Community♦ 1

26

votes

2

answers

1k

views

Why does a subquery reduce the row estimate to 1?

sql-server sql-server-2016 cardinality-estimates

Nov 28 at 14:24 Paul White♦ 57.2k

24

votes

1

answer

5k

views

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

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

Mar 14 at 8:10 Arulmouzhi 101

23

votes

1

answer

5k

views

Is my SQL Server patched?

sql-server

Oct 21 '15 at 18:21 billinkc 14.8k

23

votes

2

answers

26k

views

Performance difference between Clustered and Non Clustered Index

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

Apr 6 '19 at 4:55 Glorfindel 1,529

22

votes

1

answer

24k

views

SQL query for combinations without repetition

sql-server performance query-performance

Feb 8 '18 at 5:58 Community♦ 1

21

votes

1

answer

4k

views

Should I be alarmed by this NO JOIN PREDICATE warning?

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

Apr 5 '16 at 16:48 Max Vernon 62k

21

votes

4

answers

20k

views

Determining how a schema change occurred?

sql-server view

Jan 18 '15 at 18:50 Mark Madej 101

Stack Exchange Network

current community

your communities

more stack exchange communities

Next privilege

Next badge

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”?

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

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

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?

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

How do I get back some deleted records?

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

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

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?

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

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

Guidelines for full-text index maintenance

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

Change length of varchar on live prod table

Why does a subquery reduce the row estimate to 1?

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

Is my SQL Server patched?

Performance difference between Clustered and Non Clustered Index

SQL query for combinations without repetition

Should I be alarmed by this NO JOIN PREDICATE warning?

Determining how a schema change occurred?