Database Administrators
Profile Activity
Meta user
Network profile
Aaron Bertrand
Summary Answers Questions Tags Badges Bookmarks Bounties Reputation All actions

2,307 Answers

Votes Activity Newest
249
Why shouldn't we allow NULLs?
Aug 30 '11 at 23:01
122
Why Does the Transaction Log Keep Growing or Run Out of Space?
Aug 18 '13 at 1:13
118
Is adding the ‘tbl’ prefix to table names really a problem?
Nov 4 '16 at 13:06
103
SQL Server Cannot drop database <dbname> because it is currently in use… but no sessions displayed
Apr 27 '11 at 12:21
90
Connect to SQL Server with Windows Authentication in a different domain
May 27 '14 at 21:33
80
How to identify which query is filling up the tempdb transaction log?
Jun 25 '12 at 14:55
75
What is the difference between a “record” and a “row” in SQL Server?
Jan 13 '13 at 0:17
75
Can I install SQL Server Management Studio locally?
Aug 13 '14 at 16:31
75
Does SQL Server read all of a COALESCE function even if the first argument is not NULL?
Sep 19 '11 at 17:47
68
What is the actual behavior of compatibility level 80?
Jun 20 '13 at 4:18
66
What event information can I get by default from SQL Server?
Aug 13 '13 at 16:14
64
Best way to get last identity inserted in a table
Dec 30 '15 at 14:49
63
What are Objective Business Reasons to Prefer SQL Server 2012 over 2008 R2?
Mar 9 '12 at 20:10
60
Would using varchar(5000) be bad compared to varchar(255)?
Jan 24 '17 at 19:21
58
Why are numbers tables “invaluable”?
Jan 25 '12 at 15:12
58
Is there any difference at all between NUMERIC and DECIMAL?
Aug 29 '14 at 18:14
58
Why does a UNIQUE constraint allow only one NULL?
Oct 17 '14 at 18:39
53
Running total with count?
Jun 19 '12 at 3:31
52
In what data type should I store an email address in database?
Mar 19 '13 at 14:59
51
Write differences between varchar and nvarchar
Mar 6 '13 at 17:12
49
Why does ALTER COLUMN to NOT NULL cause massive log file growth?
Nov 29 '12 at 17:17
49
In SQL Server 2016, what is the difference between Always Encrypted and Transparent Data Encryption?
May 4 '16 at 15:43
49
At what point does one database per client become unfeasible?
Mar 19 '14 at 13:30
48
How to use COALESCE with multiple rows and without preceding comma?
Jun 12 '14 at 2:27
48
Stored procedures vs. inline SQL
Jun 14 '13 at 15:17
48
Retrieving n rows per group
Dec 17 '14 at 14:55
45
How do you kick users out of a SQL Server 2008 database?
Sep 21 '11 at 22:18
44
How do I drop all constraints from all tables?
Jan 23 '15 at 18:08
42
How do I identify the column(s) responsible for “String or binary data would be truncated.”
Dec 12 '13 at 19:17
42
Formatting T-SQL in SSMS 2012
Jun 21 '13 at 17:32
1
2 3 4 5
…
77

Your privacy

By clicking “Accept all cookies”, you agree Stack Exchange can store cookies on your device and disclose information in accordance with our Cookie Policy.