Aaron Bertrand

Staff

Member for 12 years
Last seen this week

GitHub
sqlblog.org
Matthews, NC

Summary

Reputation

178,018

178k
166k
153k

2020
2021
2022
2023

Next tag badge

sql-server-2016

366/400 score

82/80 answers

Badges

27

388

599

Newest

Yearling

Next badge

344/500

Illuminator

Answers

View all 2,340 answers

Score Activity Newest

262

Why shouldn't we allow NULLs?

Aug 30, 2011

131

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

Aug 18, 2013

122

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

Nov 4, 2016

103

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

Apr 27, 2011

102

Connect to SQL Server with Windows Authentication in a different domain

May 27, 2014

Questions

View all 6 questions

Score Activity Newest Views

63

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

Aug 13, 2013

36

How do I drop all constraints from all tables?

Jan 23, 2015

29

What date/time literal formats are LANGUAGE and DATEFORMAT safe?

Mar 10, 2017

17

Does sys.sql_logins.is_policy_checked mean that the policy has been checked?

Apr 30, 2015

13

What is the SSMS option "Execute stored procedure shortcuts without additional execution options"?

Jan 31, 2017

Tags

View all 436 tags

sql-server

13,511

Score

1,893

posts

sql-server-2008

2,539

Score

349

posts

sql-server-2008-r2

2,352

Score

365

posts

sql-server-2012

2,258

Score

327

posts

t-sql

1,971

Score

296

posts

Reputation

+10

Check constraint references another column in same table

+10

How to find all positions of a string within another string

+15

Is there a way to use standard CLR functions on Azure SQL Edge for Ubuntu Docker on an M1 Mac?

+10

'CONCAT' is not a recognized built-in function name

Badges

View all badges

27

gold badges

sql-server-2008-r2

Oct 31, 2014
sql-server-2012

Jul 27, 2015
t-sql

Jan 10, 2018

388

silver badges

stored-procedures

Nov 26, 2015
ssms

Jan 15, 2016
sql-server-2005

Feb 19, 2014

599

bronze badges

metadata

May 6, 2019
disk-space

May 7, 2019
shrink

Nov 16, 2018

Accounts

View all 26 accounts

270k
36
461
486

Database Administrators

178k
27
388
599

Meta Stack Exchange

34.8k
9
84
172

340
3
10

323
2
9

Active bounties (0)

Active Offered Earned

This user has no active bounties

Votes cast

3,968

upvotes

2,912

downvotes

3,087

question votes

3,793

answer votes

9

this month