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

2,284 Answers

Votes Activity Newest
239
Why shouldn't we allow NULLs?
Aug 30 '11 at 23:01
118
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
95
SQL Server Cannot drop database <dbname> because it is currently in use… but no sessions displayed
Apr 27 '11 at 12:21
83
Connect to SQL Server with Windows Authentication in a different domain
May 27 '14 at 21:33
77
How to identify which query is filling up the tempdb transaction log?
Jun 25 '12 at 14:55
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
71
What is the difference between a “record” and a “row” in SQL Server?
Jan 13 '13 at 0:17
67
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
62
What are Objective Business Reasons to Prefer SQL Server 2012 over 2008 R2?
Mar 9 '12 at 20:10
59
Best way to get last identity inserted in a table
Dec 30 '15 at 14:49
57
Is there any difference at all between NUMERIC and DECIMAL?
Aug 29 '14 at 18:14
56
Why are numbers tables “invaluable”?
Jan 25 '12 at 15:12
56
Why does a UNIQUE constraint allow only one NULL?
Oct 17 '14 at 18:39
55
Would using varchar(5000) be bad compared to varchar(255)?
Jan 24 '17 at 19:21
53
Running total with count?
Jun 19 '12 at 3:31
51
Write differences between varchar and nvarchar
Mar 6 '13 at 17:12
49
In what data type should I store an email address in database?
Mar 19 '13 at 14:59
48
In SQL Server 2016, what is the difference between Always Encrypted and Transparent Data Encryption?
May 4 '16 at 15:43
48
At what point does one database per client become unfeasible?
Mar 19 '14 at 13:30
48
Why does ALTER COLUMN to NOT NULL cause massive log file growth?
Nov 29 '12 at 17:17
47
How to use COALESCE with multiple rows and without preceding comma?
Jun 12 '14 at 2:27
47
Stored procedures vs. inline SQL
Jun 14 '13 at 15:17
47
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
42
Formatting T-SQL in SSMS 2012
Jun 21 '13 at 17:32
40
Query to report disk space allocation and used space
Nov 29 '12 at 19:22
39
Why does ORDER BY not belong in a View?
Jul 24 '12 at 20:34
1
2 3 4 5
…
77