Skip to main content
Database Administrators
Aaron Bertrand's user avatar
Aaron Bertrand's user avatar
Aaron Bertrand's user avatar
Aaron Bertrand
Staff
  • Member for 13 years, 4 months
  • Last seen more than a month ago
Profile Activity
Stats
180,810
reputation
22.0m
reached
2,342
answers
6
questions
Communities
View all
About

Proud dad, 🇨🇦, 26-time MVP, and I blog at Simple Talk, MSSQLTips.com, and sqlblog.org.

If I've helped you here or elsewhere, considering buying me a coffee!

profile for Aaron Bertrand on Stack Exchange, a network of free, community-driven Q&A sites
Badges
View all badges
28
gold badges
401
silver badges
617
bronze badges
Top tags
View all tags
13,741
Score
1,895
Posts
81
Posts %
2,553
Score
348
Posts
15
Posts %
2,393
Score
365
Posts
16
Posts %
2,292
Score
327
Posts
14
Posts %
2,005
Score
296
Posts
13
Posts %
1,084
Score
165
Posts
7
Posts %
Top posts
View all questions and answers
270
Why shouldn't we allow NULLs?
Aug 30, 2011
132
Why Does the Transaction Log Keep Growing or Run Out of Space?
Aug 18, 2013
121
Is adding the ‘tbl’ prefix to table names really a problem?
Nov 4, 2016
106
SQL Server Cannot drop database <dbname> because it is currently in use... but no sessions displayed
Apr 27, 2011
104
Connect to SQL Server with Windows Authentication in a different domain
May 27, 2014
85
How to identify which query is filling up the tempdb transaction log?
Jun 25, 2012
79
Best way to get last identity inserted in a table
Dec 30, 2015
76
What is the difference between a "record" and a "row" in SQL Server?
Jan 13, 2013
75
Can I install SQL Server Management Studio locally?
Aug 13, 2014
75
Does SQL Server read all of a COALESCE function even if the first argument is not NULL?
Sep 19, 2011
Top Meta posts
12
62
34
Whether we should be CAP COPs
34
Whether we should be CAP COPs
29
Are licensing questions within our scope?
23
Why is dba.stackexchange so...welcoming?
22
Community Promotion Ads - 2018
Top network posts
View all network posts
1824
Update a table using JOIN in SQL Server?
882
How do you clear the SQL Server transaction log?
548
How to pass an array into a SQL Server stored procedure
344
Add unique constraint to combination of two columns
332
Why can't I use an alias in a DELETE statement?