User Chris Aldrich

475 votes

2 answers

248k views

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

Martin Smith

78.1k

asked Apr 11, 2012 at 22:22

241 votes

18 answers

118k views

How do you document your databases?

sql-server documentation

user316

961

asked Jan 11, 2011 at 7:39

170 votes

19 answers

55k views

Should developers be able to query production databases?

sql-server best-practices permissions

Tom Hunter

2,099

asked Jan 6, 2012 at 15:57

149 votes

6 answers

130k views

Guid vs INT - Which is better as a primary key?

performance sql-server primary-key uniqueidentifier

BrunoLM

3,133

asked Jan 5, 2011 at 7:46

138 votes

8 answers

65k views

Why shouldn't we allow NULLs?

database-design null

Thomas Stringer

41.4k

asked Aug 30, 2011 at 21:11

116 votes

4 answers

20k views

Why are numbers tables "invaluable"?

sql-server

Jeff Atwood

2,314

asked Jan 25, 2012 at 0:45

102 votes

18 answers

37k views

Is adding the ‘tbl’ prefix to table names really a problem?

sql-server table best-practices naming-convention

Racer SQL

7,104

asked Nov 4, 2016 at 12:13

100 votes

2 answers

239k views

Connect to SQL Server with Windows Authentication in a different domain

sql-server authentication logins

stergosz

1,125

asked May 27, 2014 at 21:05

90 votes

2 answers

284k views

How to get the current date without the time part

sql-server sql-server-2005

Piers Myers

1,013

asked Feb 24, 2011 at 14:32

86 votes

6 answers

12k views

Do stored procedures prevent SQL injection?

postgresql security sql-injection

Am1rr3zA

1,483

asked Jan 4, 2011 at 7:24

76 votes

8 answers

61k views

MAXDOP setting algorithm for SQL Server

sql-server configuration maxdop

Hannah Vernon♦

67.2k

asked Mar 12, 2013 at 19:59

73 votes

10 answers

23k views

Why do people recommend not using the name "Id" for an identity column?

identity naming-convention

Rachel

8,269

asked Apr 17, 2012 at 13:33

71 votes

6 answers

43k views

What are the differences between NoSQL and a traditional RDBMS?

nosql rdbms database-recommendation

Spredzy

2,248

asked Jan 3, 2011 at 20:52

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

66 votes

3 answers

80k views

What is the performance impact of using CHAR vs VARCHAR on a fixed-size field?

mysql performance innodb varchar

Jason Baker

761

asked May 10, 2011 at 20:49

65 votes

5 answers

252k views

Write differences between varchar and nvarchar

sql-server varchar

Chris L

923

asked Mar 6, 2013 at 15:38

61 votes

6 answers

60k views

Date range rolling sum using window functions

sql-server sql-server-2012 performance t-sql window-functions query-performance

Paul White♦

70.9k

asked Sep 7, 2015 at 20:13

58 votes

6 answers

75k views

What are the main causes of deadlocks and can they be prevented?

sql-server sql-server-2008 deadlock

CoderHawk

4,382

asked Jan 4, 2011 at 7:14

58 votes

3 answers

50k views

Performance difference for COALESCE versus ISNULL?

sql-server syntax

Richard

6,243

asked Aug 3, 2011 at 14:10

57 votes

9 answers

13k views

Should you design the database before the application code is written?

database-design

Thomas Stringer

41.4k

asked Oct 11, 2011 at 18:03

55 votes

6 answers

114k views

After moving database (backup, restore), I have to re-add user

sql-server backup

xpda

735

asked Apr 24, 2013 at 22:37

51 votes

5 answers

163k views

Sql Server Maintenance Plan - Best Practices on Tasks and Scheduling

sql-server-2005 best-practices maintenance jobs

Josh

673

asked May 12, 2011 at 15:52

48 votes

4 answers

36k views

Clustering vs. transactional replication vs. availability groups

sql-server clustering transactional-replication failover availability-groups

marc_s

8,653

asked Nov 22, 2013 at 19:52

47 votes

8 answers

48k views

SQL Server Agent Jobs and Availability Groups

sql-server sql-server-2012 sql-server-agent availability-groups

nojetlag

2,747

asked Jun 24, 2013 at 8:26

46 votes

12 answers

7k views

How could DBAs be more 'programmer friendly'?

database-design best-practices

Jack Douglas

37.5k

asked May 2, 2011 at 11:05

45 votes

1 answer

37k views

Scalability limitations of PostgreSQL and MySQL

mysql postgresql scalability

Edmon

739

asked Sep 10, 2012 at 14:14

45 votes

1 answer

18k views

Commonly Used Acronyms by Database Administrators

terminology

tacotuesday

611

asked Aug 15, 2012 at 16:17

41 votes

6 answers

12k views

Why does adding a TOP 1 dramatically worsen performance?

sql-server sql-server-2008-r2 performance performance-tuning query-performance

Kenneth Fisher

23.7k

asked Jan 28, 2016 at 18:40

41 votes

2 answers

20k views

In SQL Server 2016, what is the difference between Always Encrypted and Transparent Data Encryption?

sql-server sql-server-2016 transparent-data-encryption always-encrypted

RoastBeast

669

asked May 4, 2016 at 15:37

40 votes

2 answers

22k views

What does a DBA have to know about SSAS?

sql-server ssas

ivanmp

2,302

asked Mar 7, 2012 at 20:25

Stack Exchange Network

current community

your communities

more stack exchange communities

257 Bookmarks

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

How do you document your databases?

Should developers be able to query production databases?

Guid vs INT - Which is better as a primary key?

Why shouldn't we allow NULLs?

Why are numbers tables "invaluable"?

Is adding the ‘tbl’ prefix to table names really a problem?

Connect to SQL Server with Windows Authentication in a different domain

How to get the current date without the time part

Do stored procedures prevent SQL injection?

MAXDOP setting algorithm for SQL Server

Why do people recommend not using the name "Id" for an identity column?

What are the differences between NoSQL and a traditional RDBMS?

Index Seek vs Index Scan

What is the performance impact of using CHAR vs VARCHAR on a fixed-size field?

Write differences between varchar and nvarchar

Date range rolling sum using window functions

What are the main causes of deadlocks and can they be prevented?

Performance difference for COALESCE versus ISNULL?

Should you design the database before the application code is written?

After moving database (backup, restore), I have to re-add user

Sql Server Maintenance Plan - Best Practices on Tasks and Scheduling

Clustering vs. transactional replication vs. availability groups

SQL Server Agent Jobs and Availability Groups

How could DBAs be more 'programmer friendly'?

Scalability limitations of PostgreSQL and MySQL

Commonly Used Acronyms by Database Administrators

Why does adding a TOP 1 dramatically worsen performance?

In SQL Server 2016, what is the difference between Always Encrypted and Transparent Data Encryption?

What does a DBA have to know about SSAS?