User Aaron Bertrand

6 votes

Accepted

T-SQL restore database restores old data only

answered Sep 13 at 14:58

4 votes

Accepted

When removing entries in SQL Server, reset the identity seed

answered Mar 13 at 12:44

3 votes

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

1 vote

Accepted

Mapping Rows To Columns From a Partitioned Value Table

answered Mar 1 at 1:47

1 vote

Accepted

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

answered Feb 28 at 7:11

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

3 votes

Using TRY_PARSE in SQL Server 2008

answered Feb 15 at 12:20

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

5 votes

Accepted

What is trace flag 1605?

answered Feb 8 at 15:51

2 votes

Is there a better way to restore transaction logs to a MSSQL db?

answered Feb 3, 2022 at 14:42

3 votes

Accepted

How do you repair a SQL Server MSSQL15.MSSQLSERVER default instance SQL Server directory after resetting my PC?

answered Jan 31, 2022 at 21:37

6 votes

Accepted

Missing Tables from a Backup and Restore (Migration) on SQL Server

answered Jan 22, 2022 at 14:36

4 votes

How to select sys.views of another database from master databse?

answered Nov 5, 2021 at 18:15

4 votes

Accepted

Server name contains port

answered Oct 26, 2021 at 16:10

5 votes

Does the Query Optimizer use Incremental Statistics yet?

answered Oct 22, 2021 at 18:09

16 votes

Is it possible to do a partial transaction log backup with SQL Server 2017? I don't have enough disk space to do a full backup

answered Oct 15, 2021 at 20:27

6 votes

Accepted

Avoiding a duplicate CASE expression

answered Oct 13, 2021 at 16:04

5 votes

Accepted

How can I use a table as a GUID pool without suffering race conditions?

answered Oct 5, 2021 at 15:20

7 votes

Accepted

Clustered Index and Sorting

answered Oct 3, 2021 at 4:30

2 votes

Accepted

Why I can't take differential backup of primary replica?

answered Sep 30, 2021 at 16:35

3 votes

Accepted

Use trigger on DELETE to retrieve original SQL command and user who did it

answered Sep 29, 2021 at 18:22

6 votes

Accepted

Need to determine log space required for a large transaction (MSSQL)

answered Sep 24, 2021 at 19:59

2 votes

Accepted

SQL Profiler shows multiple calls for one TVF

answered Sep 24, 2021 at 17:23

2 votes

Accepted

Find a doubled value between two columns in the same row

answered Sep 23, 2021 at 18:56

3 votes

Is Trace Flag 6534 Relevant Past SQL Server 2016?

answered Sep 22, 2021 at 21:17

2 votes

Updating varchar column over linked server with parameterized query causes remote scan and cursorfetch

answered Sep 16, 2021 at 18:28

2 votes

Difference between statement for declaring variable MSSQL

answered Sep 16, 2021 at 14:15

3 votes

Accepted

How to group data but taking rows only in a specific order (example should be clearer ;) )

answered Sep 15, 2021 at 13:25

13 votes

How to know which application or user put the SQL Server Database in single user mode

answered Sep 15, 2021 at 13:04

Stack Exchange Network

2,341 Answers

T-SQL restore database restores old data only

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?

Mapping Rows To Columns From a Partitioned Value Table

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

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

Using TRY_PARSE in SQL Server 2008

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

What is trace flag 1605?

Is there a better way to restore transaction logs to a MSSQL db?

How do you repair a SQL Server MSSQL15.MSSQLSERVER default instance SQL Server directory after resetting my PC?

Missing Tables from a Backup and Restore (Migration) on SQL Server

How to select sys.views of another database from master databse?

Server name contains port

Does the Query Optimizer use Incremental Statistics yet?

Is it possible to do a partial transaction log backup with SQL Server 2017? I don't have enough disk space to do a full backup

Avoiding a duplicate CASE expression

How can I use a table as a GUID pool without suffering race conditions?

Clustered Index and Sorting

Why I can't take differential backup of primary replica?

Use trigger on DELETE to retrieve original SQL command and user who did it

Need to determine log space required for a large transaction (MSSQL)

SQL Profiler shows multiple calls for one TVF

Find a doubled value between two columns in the same row

Is Trace Flag 6534 Relevant Past SQL Server 2016?

Updating varchar column over linked server with parameterized query causes remote scan and cursorfetch

Difference between statement for declaring variable MSSQL

How to group data but taking rows only in a specific order (example should be clearer ;) )

How to know which application or user put the SQL Server Database in single user mode