User Chris Aldrich

467

votes

2

answers

245k

views

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

Jun 6 at 7:59 Glorfindel 2,037

238

votes

18

answers

116k

views

How do you document your databases?

sql-server documentation

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

167

votes

19

answers

53k

views

Should developers be able to query production databases?

sql-server best-practices permissions

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

135

votes

5

answers

114k

views

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

performance sql-server primary-key uniqueidentifier

Jan 25 at 14:07 Hannah Vernon♦ 66.3k

135

votes

8

answers

61k

views

Why shouldn't we allow NULLs?

database-design null

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

116

votes

4

answers

19k

views

Why are numbers tables "invaluable"?

sql-server

May 12 at 7:28 Glorfindel 2,037

101

votes

18

answers

35k

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

97

votes

2

answers

230k

views

Connect to SQL Server with Windows Authentication in a different domain

sql-server authentication logins

Jan 22 '20 at 12:54 CommunityBot 1

89

votes

2

answers

282k

views

How to get the current date without the time part

sql-server sql-server-2005

Jul 25 '18 at 11:10 gbn 68.5k

85

votes

6

answers

12k

views

Do stored procedures prevent SQL injection?

postgresql security sql-injection

Jun 21 at 8:54 Glorfindel 2,037

74

votes

8

answers

58k

views

MAXDOP setting algorithm for SQL Server

sql-server configuration maxdop

Jul 7 '20 at 13:26 Preben Huybrechts 137

72

votes

10

answers

22k

views

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

identity naming-convention

Nov 16 '15 at 6:20 CommunityBot 1

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 CommunityBot 1

66

votes

4

answers

57k

views

Index Seek vs Index Scan

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

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

66

votes

3

answers

77k

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

65

votes

5

answers

250k

views

Write differences between varchar and nvarchar

sql-server varchar

Mar 27 '19 at 5:32 Joseph Poirier 101

60

votes

6

answers

55k

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 CommunityBot 1

57

votes

6

answers

74k

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

3

answers

46k

views

Performance difference for COALESCE versus ISNULL?

sql-server syntax

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

57

votes

9

answers

12k

views

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

database-design

Jun 22 '20 at 14:45 CommunityBot 1

53

votes

6

answers

109k

views

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

sql-server backup

Jan 9 '19 at 17:52 Doreen 111

51

votes

5

answers

159k

views

Sql Server Maintenance Plan - Best Practices on Tasks and Scheduling

sql-server-2005 best-practices maintenance jobs

Jun 19 at 9:44 CommunityBot 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,316

46

votes

12

answers

6k

views

How could DBAs be more 'programmer friendly'?

database-design best-practices

Apr 7 '16 at 19:49 CommunityBot 1

45

votes

1

answer

36k

views

Scalability limitations of PostgreSQL and MySQL

mysql postgresql scalability

Aug 6 '18 at 15:10 RDFozz 11.3k

45

votes

1

answer

17k

views

Commonly Used Acronyms by Database Administrators

terminology

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

44

votes

8

answers

44k

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,925

41

votes

6

answers

11k

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 CommunityBot 1

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

Aug 16 at 16:55 Hannah Vernon♦ 66.3k

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?

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

How could DBAs be more 'programmer friendly'?

Scalability limitations of PostgreSQL and MySQL

Commonly Used Acronyms by Database Administrators

SQL Server Agent Jobs and Availability Groups

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?