Stack Exchange

Aaron Bertrand

Matthews, NC

https://sqlblog.org

24-time Data Platform MVP; @AaronBertrand on twitter; blogger at sqlperformance.com, mssqltips.com, and sqlblog.org; Mac person, curler, Bruins/Patriots/Nadal fan, big-time loser at fantasy football, proud father of two beautiful girls, and Canadian, eh?

top accounts reputation activity subscriptions

Top Questions

Make first draft of a new answer part of the permanent revision history

feature-request status-declined edits attribution grace-period asked Jun 28, 2012 at 14:50

meta.stackexchange.com

Reset question grace period once an answer has been posted

feature-request status-completed grace-period asked Jan 17, 2014 at 16:08

meta.stackexchange.com

Lock a post for editing, or at least display a warning

feature-request edits asked Jul 26, 2012 at 19:15

meta.stackexchange.com

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

sql-server extended-events asked Aug 13, 2013 at 16:14

dba.stackexchange.com

Make moderator election questionnaire mandatory

feature-request election nominations asked Feb 20, 2014 at 4:38

meta.stackexchange.com

Edit comment yields [object Object] instead of comment text

bug status-completed comments edits asked Aug 17, 2018 at 19:07

meta.stackexchange.com

How do I drop all constraints from all tables?

sql-server ddl constraints asked Jan 23, 2015 at 18:08

dba.stackexchange.com

Clarify what "score" means in badge descriptions

feature-request badges score asked Jul 10, 2013 at 16:55

meta.stackexchange.com

Make links in comments immune to being hidden by username

feature-request comments user-interface hyperlinks design asked Oct 15, 2013 at 22:44

meta.stackexchange.com

The current SEDE refresh was delayed overnight

discussion status-completed data-explorer announcements asked Jan 21 at 22:14

meta.stackexchange.com

Top Answers

Update a table using JOIN in SQL Server?

stackoverflow.com

SQL Server - inner join when updating

stackoverflow.com

How do you clear the SQL Server transaction log?

stackoverflow.com

How to pass an array into a SQL Server stored procedure

stackoverflow.com

Add unique constraint to combination of two columns

stackoverflow.com

Why can't I use an alias in a DELETE statement?

stackoverflow.com

How to see query history in SQL Server Management Studio

stackoverflow.com

Reference alias (calculated in SELECT) in WHERE clause

stackoverflow.com

Why shouldn't we allow NULLs?

dba.stackexchange.com

Database Diagram Support Objects cannot be Installed ... no valid owner

stackoverflow.com

How to remove "Server name" items from history of SQL Server Management Studio

stackoverflow.com

Calculate running total / running balance

stackoverflow.com

Finding the data types of a SQL temporary table

stackoverflow.com

How to remove cached server names from the Connect to Server dialog?

stackoverflow.com

Get first day of week in SQL Server

stackoverflow.com

SQL Server file names vs versions

stackoverflow.com

How do I avoid character encoding when using "FOR XML PATH"?

stackoverflow.com

Getting total row count from OFFSET / FETCH NEXT

stackoverflow.com

Solutions for INSERT OR UPDATE on SQL Server

stackoverflow.com

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

dba.stackexchange.com

Ctrl R not working in SQL Server 2012

stackoverflow.com

How do I create a table based on another table

stackoverflow.com

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

dba.stackexchange.com

Temporarily disable all foreign key constraints

stackoverflow.com

UPDATE if exists else INSERT in SQL Server 2008

stackoverflow.com

Retrieve column names and types of a stored procedure?

stackoverflow.com

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

dba.stackexchange.com

Is there a performance difference between CTE , Sub-Query, Temporary Table or Table Variable?

stackoverflow.com

Connect to SQL Server with Windows Authentication in a different domain

dba.stackexchange.com

Create a view with ORDER BY clause

stackoverflow.com