User Aaron Bertrand - Database Administrators Stack Exchange

Aaron Bertrand

Staff

Member for 13 years, 1 month
Last seen this week

GitHub
sqlblog.org
Matthews, NC

2,342 Answers

Score Activity Newest

3 votes

Accepted

Using SQL Server's 2016 Temporal Tables to Record Prior History

answered Dec 11, 2016 at 2:50

3 votes

Merge Failed when update same rows

answered Jan 3, 2017 at 14:38

3 votes

Accepted

SQL Server 2012 Support on Windows Server 2008 R2

answered Jan 16, 2017 at 15:10

3 votes

Accepted

Aggregates per half hour intervals within a time span

answered Jan 16, 2017 at 21:09

3 votes

Accepted

Getting count(column) as well as a specific row in each group

answered Jan 29, 2017 at 17:12

3 votes

Accepted

String that contains letters representing a negative number

answered Apr 29, 2015 at 19:07

3 votes

Improve SQL Performance with LIKE '%ABC%' QUERY

answered Apr 29, 2015 at 11:35

3 votes

Accepted

Question about the UNION operator and its implicit data type conversions

answered Apr 30, 2015 at 19:25

3 votes

Does the scope for 'Alter Any Database' operate similar to 'Create Any Database'?

answered May 29, 2015 at 0:13

3 votes

Accepted

Incremental (not differential) backup of SQL Server 2008 R2

answered May 27, 2015 at 14:04

3 votes

Accepted

How to generate an error when backing up to an existing file

answered Apr 22, 2015 at 13:13

3 votes

Accepted

Will adding features pick up previously installed service pack updates?

answered Apr 15, 2015 at 13:36

3 votes

Another Dynamically alias column question

answered Apr 23, 2015 at 22:12

3 votes

Unable to change database owner to a user that is already mapped as user

answered Jul 2, 2015 at 14:11

3 votes

Accepted

How to create a dummy Linked Server in SQL Server 2012

answered May 20, 2015 at 14:03

3 votes

Accepted

DB Re-index failure

answered Jun 9, 2015 at 0:26

3 votes

How to use "BACKUP DATABASE", but the database is in a different server.?

answered Jun 9, 2015 at 15:22

3 votes

SQL Server Client Tools: How can you tell what SQL edition the client tools are from?

answered Jul 16, 2015 at 18:53

3 votes

Accepted

how to define trigger scope variable

answered Nov 24, 2014 at 16:26

3 votes

Accepted

ONLINE vs OFFLINE index rebuilds

answered Dec 8, 2014 at 14:33

3 votes

Accepted

Finding Database Default Locations

answered Dec 8, 2014 at 16:30

3 votes

Can an EXISTS clause be improved when the condition is checked for the same value multiple times?

answered Dec 3, 2014 at 14:24

3 votes

resource wait SQLCLR - wait_type CLR_SEMAPHORE by SPID 0

answered Nov 25, 2014 at 15:01

3 votes

need to replace the blank value as 0

answered Nov 26, 2014 at 14:20

3 votes

Accepted

Change the owner of an offline database without bringing it online

answered Nov 18, 2014 at 22:15

3 votes

Accepted

Upgrading SQL Server 2008 R2 Standard edition to SQL Server 2008 R2 Enterprise edition what is the process and the impact?

answered Nov 17, 2014 at 15:06

3 votes

Accepted

stored procedures location influence their performance?

answered Nov 17, 2014 at 15:29

3 votes

SQL Server 2008 Trigger

answered Nov 3, 2014 at 20:00

3 votes

Accepted

Managing logins with Availabilty Groups

answered Nov 4, 2014 at 17:13

3 votes

How to know the Database user Login History from begining?

answered Nov 11, 2014 at 3:53

…

56

…