Skip to main content
Aaron Bertrand's user avatar
Aaron Bertrand's user avatar
Aaron Bertrand's user avatar
Aaron Bertrand
Staff
  • Member for 13 years, 3 months
  • Last seen more than a month ago
270 votes
Accepted

Why shouldn't we allow NULLs?

132 votes

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

121 votes

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

106 votes

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

103 votes
Accepted

Connect to SQL Server with Windows Authentication in a different domain

85 votes
Accepted

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

79 votes
Accepted

Best way to get last identity inserted in a table

76 votes
Accepted

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

75 votes

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

75 votes
Accepted

Can I install SQL Server Management Studio locally?

71 votes
Accepted

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

68 votes
Accepted

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

68 votes
Accepted

What is the actual behavior of compatibility level 80?

68 votes
Accepted

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

65 votes

Why are numbers tables "invaluable"?

63 votes
Accepted

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

60 votes
Accepted

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

59 votes
Accepted

Is there any difference at all between NUMERIC and DECIMAL?

58 votes
Accepted

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

53 votes

Running total with count?

53 votes
Accepted

At what point does one database per client become unfeasible?

51 votes
Accepted

How do I drop all constraints from all tables?

51 votes

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

51 votes
Accepted

Write differences between varchar and nvarchar

50 votes
Accepted

Stored procedures vs. inline SQL

50 votes

Retrieving n rows per group

50 votes
Accepted

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

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?

45 votes

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

1
2 3 4 5
79