User Gabe

475 votes

2 answers

249k views

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

Martin Smith

78.4k

asked Apr 11, 2012 at 22:22

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

101 votes

2 answers

240k views

Connect to SQL Server with Windows Authentication in a different domain

sql-server authentication logins

stergosz

1,135

asked May 27, 2014 at 21:05

75 votes

1 answer

88k views

MERGE a subset of the target table

sql-server t-sql merge

KutuluMike

1,539

asked Dec 17, 2012 at 21:17

62 votes

6 answers

91k views

When should I rebuild indexes?

sql-server index-maintenance

Nick Chammas

14.3k

asked Aug 3, 2011 at 18:43

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

43 votes

2 answers

2k views

Why does changing the declared join column order introduce a sort?

sql-server sql-server-2014 join sql-server-2017 sort-operator

Daniel Hutmacher

8,879

asked Aug 16, 2018 at 11:58

41 votes

3 answers

9k views

difference in execution plans on UAT and PROD server

sql-server-2008-r2 performance query-performance

Kin Shah

61.3k

asked Nov 21, 2013 at 17:18

32 votes

2 answers

127k views

What is the fastest way to insert large numbers of rows?

sql-server sql-server-2012 performance insert query-performance

nojetlag

2,777

asked Feb 19, 2014 at 14:28

31 votes

4 answers

2k views

What is a scalable way to simulate HASHBYTES using a SQL CLR scalar function?

sql-server sql-server-2016 etl sql-clr hashing

Joe Obbish

30.7k

asked Feb 3, 2019 at 16:57

26 votes

5 answers

41k views

SQL Server 2012: Generate Scripts from command line

sql-server scripting

Harald

403

asked Jan 12, 2014 at 14:03

23 votes

4 answers

34k views

FOR XML could not serialize the data because it contains character (0x0000)

sql-server sql-server-2008-r2 xml

Racer SQL

7,156

asked Jul 16, 2015 at 18:16

23 votes

4 answers

19k views

Choosing the right algorithm in HashBytes function

sql-server sql-server-2008-r2 t-sql hashing

Sky

3,664

asked Feb 22, 2013 at 5:44

23 votes

1 answer

5k views

What exactly can SQL Server 2014 execute in batch mode?

sql-server sql-server-2014 columnstore batch-mode

usr

7,180

asked Apr 12, 2015 at 14:11

23 votes

1 answer

17k views

Insert with OUTPUT correlated to sub query table

sql-server insert output-clause

Yugo Amaryl

423

asked Apr 9, 2014 at 15:53

22 votes

3 answers

2k views

Why would a table with a Clustered Columnstore Index have many open rowgroups?

sql-server sql-server-2017 columnstore

Taryn

9,496

asked Dec 19, 2019 at 18:23

20 votes

3 answers

17k views

Trace Flag 4199 - Enable globally?

sql-server optimization execution-plan

FilamentUnities

681

asked May 22, 2015 at 15:56

19 votes

2 answers

189k views

Converting a VARCHAR to VARBINARY

sql-server sql-server-2012 xml varchar varbinary

Mark Sinkinson

10.1k

asked Apr 23, 2014 at 14:31

19 votes

4 answers

23k views

SSMS Tools Pack Alternative [closed]

sql-server sql-server-2012 ssms

WernerCD

1,185

asked Oct 1, 2012 at 19:49

18 votes

2 answers

43k views

Sql Server - Best Practices for Growing Database Files

sql-server sql-server-2008 sql-server-2008-r2 transaction-log best-practices

Ross Bush

417

asked Aug 28, 2012 at 17:57

18 votes

1 answer

5k views

SQL Server--If logic in stored procedure and the plan cache

sql-server performance sql-server-2016 query-performance

Nicole G.

305

asked Sep 6, 2017 at 21:38

17 votes

5 answers

4k views

Inclusion of ORDER BY on query that returns no rows drastically affects performance

sql-server performance

Hafthor

273

asked Jan 5, 2012 at 0:18

17 votes

1 answer

1k views

Query strategies using SQL Server 2016 system-versioned temporal tables for Slowly-Changing Dimensions

sql-server data-warehouse slowly-changing-dimension sql-server-2016 temporal-tables

Justin Grant

741

asked Jul 10, 2015 at 23:05

16 votes

2 answers

16k views

How to optimise T-SQL query using Execution Plan

sql-server sql-server-2008 t-sql optimization execution-plan

Neo

425

asked Aug 2, 2013 at 20:48

14 votes

6 answers

8k views

SQL Server Checklists

sql-server-2008 sql-server-2005 maintenance

Stuart Blackler

4,392

asked Aug 19, 2011 at 18:19

14 votes

2 answers

33k views

Why is this query not using my nonclustered index, and how can I make it?

sql-server sql-server-2008-r2 index optimization

Nate

1,667

asked Aug 31, 2012 at 14:49

13 votes

4 answers

9k views

Rebuilding Indexes, DB now 10x the size

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

Jeffrey Bane

389

asked Jul 8, 2012 at 16:35

12 votes

1 answer

3k views

Should I disable "auto update statistics" in a data warehousing scenario?

sql-server data-warehouse statistics

saso

223

asked Dec 11, 2013 at 13:27

11 votes

2 answers

19k views

why is io_stall_writes_ms so much higher for tempdb?

sql-server sql-server-2008

SQLSpartan

asked Dec 10, 2012 at 21:50

11 votes

1 answer

1k views

Definitive list of steps for SQL Server baseline testing?

sql-server dbcc performance cache performance-testing

Eric Higgins

2,679

asked Mar 6, 2012 at 16:43

Stack Exchange Network

current community

your communities

more stack exchange communities

47 Bookmarks

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

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

Connect to SQL Server with Windows Authentication in a different domain

MERGE a subset of the target table

When should I rebuild indexes?

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

Why does changing the declared join column order introduce a sort?

difference in execution plans on UAT and PROD server

What is the fastest way to insert large numbers of rows?

What is a scalable way to simulate HASHBYTES using a SQL CLR scalar function?

SQL Server 2012: Generate Scripts from command line

FOR XML could not serialize the data because it contains character (0x0000)

Choosing the right algorithm in HashBytes function

What exactly can SQL Server 2014 execute in batch mode?

Insert with OUTPUT correlated to sub query table

Why would a table with a Clustered Columnstore Index have many open rowgroups?

Trace Flag 4199 - Enable globally?

Converting a VARCHAR to VARBINARY

SSMS Tools Pack Alternative [closed]

Sql Server - Best Practices for Growing Database Files

SQL Server--If logic in stored procedure and the plan cache

Inclusion of ORDER BY on query that returns no rows drastically affects performance

Query strategies using SQL Server 2016 system-versioned temporal tables for Slowly-Changing Dimensions

How to optimise T-SQL query using Execution Plan

SQL Server Checklists

Why is this query not using my nonclustered index, and how can I make it?

Rebuilding Indexes, DB now 10x the size

Should I disable "auto update statistics" in a data warehousing scenario?

why is io_stall_writes_ms so much higher for tempdb?

Definitive list of steps for SQL Server baseline testing?