Aaron Bertrand's user avatar
Aaron Bertrand's user avatar
Aaron Bertrand's user avatar
Aaron Bertrand
Staff
  • Member for 11 years, 11 months
  • Last seen this week
261 votes
Accepted

Why shouldn't we allow NULLs?

130 votes

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

123 votes

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

103 votes

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

102 votes
Accepted

Connect to SQL Server with Windows Authentication in a different domain

84 votes
Accepted

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

75 votes

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

75 votes
Accepted

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

75 votes
Accepted

Can I install SQL Server Management Studio locally?

69 votes
Accepted

Best way to get last identity inserted in a table

68 votes
Accepted

What is the actual behavior of compatibility level 80?

67 votes
Accepted

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

67 votes
Accepted

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

63 votes
Accepted

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

63 votes

Why are numbers tables "invaluable"?

63 votes
Accepted

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

59 votes
Accepted

Is there any difference at all between NUMERIC and DECIMAL?

58 votes
Accepted

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

53 votes

Running total with count?

53 votes
Accepted

At what point does one database per client become unfeasible?

51 votes
Accepted

Write differences between varchar and nvarchar

50 votes

Retrieving n rows per group

49 votes
Accepted

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

49 votes
Accepted

Stored procedures vs. inline SQL

49 votes
Accepted

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

48 votes
Accepted

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

47 votes
Accepted

How do I drop all constraints from all tables?

47 votes
Accepted

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

45 votes

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

44 votes

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

1
2 3 4 5
78