User Chris Aldrich

463

votes

2

answers

243k

views

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

Dec 8 at 17:08 Glorfindel 1,650

237

votes

18

answers

114k

views

How do you document your databases?

sql-server documentation

Dec 10 at 20:29 LowlyDBA - John M 10.5k

166

votes

19

answers

51k

views

Should developers be able to query production databases?

sql-server best-practices permissions

Apr 26 '18 at 10:37 Ramakant Dadhichi 2,138

132

votes

8

answers

58k

views

Why shouldn't we allow NULLs?

database-design null

Apr 6 '18 at 23:55 Aaron Bertrand 171k

128

votes

5

answers

102k

views

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

performance sql-server primary-key uniqueidentifier

Jan 25 at 14:07 Hannah Vernon♦ 64.3k

114

votes

4

answers

19k

views

Why are numbers tables “invaluable”?

sql-server

Mar 3 '20 at 12:53 Aaron Bertrand 171k

98

votes

18

answers

33k

views

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

sql-server best-practices naming-convention

Feb 11 '19 at 4:55 sampathsris 284

93

votes

2

answers

216k

views

Connect to SQL Server with Windows Authentication in a different domain

sql-server authentication logins

Jan 22 '20 at 12:54 Community♦ 1

88

votes

2

answers

278k

views

How to get the current date without the time part

sql-server sql-server-2005

Jul 25 '18 at 11:10 gbn 67.9k

85

votes

6

answers

11k

views

Do stored procedures prevent SQL injection?

postgresql security sql-injection

Jun 25 '18 at 11:26 Jasen 2,010

73

votes

8

answers

56k

views

MAXDOP setting algorithm for SQL Server

sql-server configuration maxdop

Jul 7 at 13:26 Preben Huybrechts 137

71

votes

6

answers

43k

views

What are the differences between NoSQL and a traditional RDBMS?

nosql rdbms database-recommendation

May 17 '16 at 23:02 Community♦ 1

71

votes

10

answers

21k

views

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

identity naming-convention

Nov 16 '15 at 6:20 Community♦ 1

66

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 27.9k

65

votes

5

answers

249k

views

Write differences between varchar and nvarchar

sql-server varchar

Mar 27 '19 at 5:32 Joseph Poirier 1

65

votes

3

answers

73k

views

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

mysql performance innodb varchar

Aug 16 '18 at 15:33 Jack Douglas 35.5k

59

votes

6

answers

50k

views

Date range rolling sum using window functions

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

Dec 30 '16 at 18:30 Community♦ 1

57

votes

6

answers

72k

views

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

sql-server sql-server-2008 deadlock

Nov 4 '15 at 0:01 yogi 103

57

votes

9

answers

12k

views

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

database-design

Jun 22 at 14:45 Community♦ 1

55

votes

3

answers

43k

views

Performance difference for COALESCE versus ISNULL?

sql-server syntax

Feb 17 '19 at 0:37 Paul White♦ 59.6k

49

votes

5

answers

154k

views

Sql Server Maintenance Plan - Best Practices on Tasks and Scheduling

sql-server-2005 best-practices maintenance jobs

Feb 10 '16 at 9:35 Community♦ 1

49

votes

4

answers

35k

views

Clustering vs. transactional replication vs. availability groups

sql-server clustering transactional-replication failover availability-groups

Sep 13 '17 at 10:01 Mitch Wheat 1,286

48

votes

6

answers

103k

views

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

sql-server backup

Jan 9 '19 at 17:52 Doreen 111

46

votes

12

answers

6k

views

How could DBAs be more 'programmer friendly'?

database-design best-practices

Apr 7 '16 at 19:49 Community♦ 1

45

votes

1

answer

17k

views

Commonly Used Acronyms by Database Administrators

terminology

Sep 16 '18 at 9:55 Paul White♦ 59.6k

43

votes

8

answers

39k

views

SQL Server Agent Jobs and Availability Groups

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

Oct 27 '18 at 16:52 Aleksey Vitsko 3,141

43

votes

1

answer

35k

views

Scalability limitations of PostgreSQL and MySQL

mysql postgresql scalability

Aug 6 '18 at 15:10 RDFozz 11.2k

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

Apr 14 '17 at 3:39 sajaks 1

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

40

votes

6

answers

10k

views

Why does adding a TOP 1 dramatically worsen performance?

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

Apr 9 '18 at 3:41 Community♦ 1

Stack Exchange Network

current community

your communities

more stack exchange communities

Next privilege

Next badge

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?

Why shouldn't we allow NULLs?

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

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

What are the differences between NoSQL and a traditional RDBMS?

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

Index Seek vs Index Scan

Write differences between varchar and nvarchar

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

Date range rolling sum using window functions

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

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

Performance difference for COALESCE versus ISNULL?

Sql Server Maintenance Plan - Best Practices on Tasks and Scheduling

Clustering vs. transactional replication vs. availability groups

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

How could DBAs be more 'programmer friendly'?

Commonly Used Acronyms by Database Administrators

SQL Server Agent Jobs and Availability Groups

Scalability limitations of PostgreSQL and MySQL

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

What does a DBA have to know about SSAS?

Why does adding a TOP 1 dramatically worsen performance?