User Aaron Bertrand

4 votes

Accepted

When removing entries in SQL Server, reset the identity seed

answered Mar 13 at 12:44

1 vote

Accepted

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

answered Mar 12 at 13:15

3 votes

Using TRY_PARSE in SQL Server 2008

answered Feb 15 at 12:20

2 votes

io_stall question

answered Jan 23, 2015 at 15:47

11 votes

SQL Server 2012 memory consumption outside the buffer pool

answered Jan 21, 2015 at 17:50

3 votes

JDBC connection error for SQL Server Database

answered Jan 21, 2015 at 14:50

1 vote

Accepted

TRY_CAST fails when fed very long string... but only from column or variable

answered Feb 28 at 7:11

1 vote

Accepted

Mapping Rows To Columns From a Partitioned Value Table

answered Mar 1 at 1:47

0 votes

Accepted

How to create a row for every day in a date range(til the end of year) using while loop in MSSQL?

answered Feb 27 at 17:16

13 votes

Accepted

SQL Server 2012 Standard Edition using more than 64GB of memory, why and how?

answered Dec 5, 2014 at 15:13

6 votes

Why is the length of a value sometimes the width of the column instead of the length of the string?

answered Feb 15 at 1:50

4 votes

Accepted

Getting data file and log file free space size during database restoring

answered Feb 9 at 12:41

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

5 votes

Accepted

What is trace flag 1605?

answered Feb 8 at 15:51

15 votes

Accepted

INSERT takes over 5 hours, when inserting more than specific number of rows

answered Sep 8, 2014 at 19:23

2 votes

Duplicate Statistics?

answered Aug 27, 2014 at 20:53

75 votes

Accepted

Can I install SQL Server Management Studio locally?

answered Aug 13, 2014 at 16:31

15 votes

Accepted

I can't save Database Diagrams

answered Feb 9, 2016 at 20:30

8 votes

Accepted

View the order of triggers firing

answered Sep 2, 2014 at 8:58

3 votes

Accepted

Possible to CREATE EVENT NOTIFICATION with a different owner?

answered Sep 25, 2014 at 20:32

6 votes

Accepted

Installing SQL Server 2012 SP2 on instance with Cumulative Update #10

answered Jun 27, 2014 at 19:13

3 votes

Accepted

force to forget logins

answered Nov 23, 2012 at 17:46

7 votes

Accepted

Why does sys.fn_hadr_backup_is_preferred_replica take so long? Is there a better way?

answered Oct 21, 2015 at 16:34

19 votes

Accepted

How to improve Procedure Cache Hit Ratio?

answered Jan 23, 2014 at 1:20

2 votes

Shrink the database only up to its initial size which is set after creating database

answered Jan 16, 2014 at 14:47

5 votes

Accepted

Empty SQL Server 2000 LDF File

answered Dec 10, 2013 at 13:30

9 votes

Accepted

Join with comma separated values in SQL Server

answered Aug 27, 2015 at 13:54

12 votes

Deadlock Graph and Interpretation, solution to avoid

answered Apr 9, 2019 at 13:28

3 votes

Is there a way that I can export a list of all table triggers on a server?

answered Mar 7, 2013 at 21:42

11 votes

Accepted

Disallow new UDFs that contain a cursor

answered Jun 15, 2012 at 13:59

Stack Exchange Network

2,340 Answers

When removing entries in SQL Server, reset the identity seed

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

Using TRY_PARSE in SQL Server 2008

io_stall question

SQL Server 2012 memory consumption outside the buffer pool

JDBC connection error for SQL Server Database

TRY_CAST fails when fed very long string... but only from column or variable

Mapping Rows To Columns From a Partitioned Value Table

How to create a row for every day in a date range(til the end of year) using while loop in MSSQL?

SQL Server 2012 Standard Edition using more than 64GB of memory, why and how?

Why is the length of a value sometimes the width of the column instead of the length of the string?

Getting data file and log file free space size during database restoring

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

What is trace flag 1605?

INSERT takes over 5 hours, when inserting more than specific number of rows

Duplicate Statistics?

Can I install SQL Server Management Studio locally?

I can't save Database Diagrams

View the order of triggers firing

Possible to CREATE EVENT NOTIFICATION with a different owner?

Installing SQL Server 2012 SP2 on instance with Cumulative Update #10

force to forget logins

Why does sys.fn_hadr_backup_is_preferred_replica take so long? Is there a better way?

How to improve Procedure Cache Hit Ratio?

Shrink the database only up to its initial size which is set after creating database

Empty SQL Server 2000 LDF File

Join with comma separated values in SQL Server

Deadlock Graph and Interpretation, solution to avoid

Is there a way that I can export a list of all table triggers on a server?

Disallow new UDFs that contain a cursor