User Aaron Bertrand

262 votes

Accepted

Why shouldn't we allow NULLs?

answered Aug 30, 2011 at 23:01

131 votes

Why Does the Transaction Log Keep Growing or Run Out of Space?

answered Aug 18, 2013 at 1:13

122 votes

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

answered Nov 4, 2016 at 13:06

103 votes

SQL Server Cannot drop database <dbname> because it is currently in use... but no sessions displayed

answered Apr 27, 2011 at 12:21

102 votes

Accepted

Connect to SQL Server with Windows Authentication in a different domain

answered May 27, 2014 at 21:33

84 votes

Accepted

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

answered Jun 25, 2012 at 14:55

76 votes

Accepted

What is the difference between a "record" and a "row" in SQL Server?

answered Jan 13, 2013 at 0:17

75 votes

Accepted

Can I install SQL Server Management Studio locally?

answered Aug 13, 2014 at 16:31

75 votes

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

answered Sep 19, 2011 at 17:47

70 votes

Accepted

Best way to get last identity inserted in a table

answered Dec 30, 2015 at 14:49

69 votes

Accepted

Would using varchar(5000) be bad compared to varchar(255)?

answered Jan 24, 2017 at 19:21

68 votes

Accepted

What is the actual behavior of compatibility level 80?

answered Jun 20, 2013 at 4:18

67 votes

Accepted

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

answered Aug 13, 2013 at 16:14

64 votes

Accepted

Why does a UNIQUE constraint allow only one NULL in SQL Server?

answered Oct 17, 2014 at 18:39

63 votes

Accepted

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

answered Mar 9, 2012 at 20:10

63 votes

Why are numbers tables "invaluable"?

answered Jan 25, 2012 at 15:12

59 votes

Accepted

Is there any difference at all between NUMERIC and DECIMAL?

answered Aug 29, 2014 at 18:14

58 votes

Accepted

In what data type should I store an email address in database?

answered Mar 19, 2013 at 14:59

53 votes

Accepted

At what point does one database per client become unfeasible?

answered Mar 19, 2014 at 13:30

53 votes

Running total with count?

answered Jun 19, 2012 at 3:31

51 votes

Accepted

How do I identify the column(s) responsible for "String or binary data would be truncated."

answered Dec 12, 2013 at 19:17

51 votes

Accepted

Write differences between varchar and nvarchar

answered Mar 6, 2013 at 17:12

50 votes

Retrieving n rows per group

answered Dec 17, 2014 at 14:55

49 votes

Accepted

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

answered May 4, 2016 at 15:43

49 votes

Accepted

Why does ALTER COLUMN to NOT NULL cause massive log file growth?

answered Nov 29, 2012 at 17:17

49 votes

Accepted

Stored procedures vs. inline SQL

answered Jun 14, 2013 at 15:17

48 votes

Accepted

How to use COALESCE with multiple rows and without preceding comma?

answered Jun 12, 2014 at 2:27

48 votes

Accepted

How do I drop all constraints from all tables?

answered Jan 23, 2015 at 18:08

45 votes

Why do we use Group by 1 and Group by 1,2,3 in SQL query?

answered Dec 19, 2014 at 12:17

45 votes

How do you kick users out of a SQL Server 2008 database?

answered Sep 21, 2011 at 22:18

Stack Exchange Network

2,340 Answers

Why shouldn't we allow NULLs?

Why Does the Transaction Log Keep Growing or Run Out of Space?

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

SQL Server Cannot drop database <dbname> because it is currently in use... but no sessions displayed

Connect to SQL Server with Windows Authentication in a different domain

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

What is the difference between a "record" and a "row" in SQL Server?

Can I install SQL Server Management Studio locally?

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

Best way to get last identity inserted in a table

Would using varchar(5000) be bad compared to varchar(255)?

What is the actual behavior of compatibility level 80?

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

Why does a UNIQUE constraint allow only one NULL in SQL Server?

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

Why are numbers tables "invaluable"?

Is there any difference at all between NUMERIC and DECIMAL?

In what data type should I store an email address in database?

At what point does one database per client become unfeasible?

Running total with count?

How do I identify the column(s) responsible for "String or binary data would be truncated."

Write differences between varchar and nvarchar

Retrieving n rows per group

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

Why does ALTER COLUMN to NOT NULL cause massive log file growth?

Stored procedures vs. inline SQL

How to use COALESCE with multiple rows and without preceding comma?

How do I drop all constraints from all tables?

Why do we use Group by 1 and Group by 1,2,3 in SQL query?

How do you kick users out of a SQL Server 2008 database?