user avatar
user avatar
user avatar
Aaron Bertrand
Staff
  • Member for 11 years, 5 months
  • Last seen this week
2 votes

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

3 votes
Accepted

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

6 votes
Accepted

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

4 votes

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

4 votes
Accepted

Server name contains port

5 votes

Does the Query Optimizer use Incremental Statistics yet?

15 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

6 votes
Accepted

Avoiding a duplicate CASE expression

5 votes
Accepted

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

7 votes
Accepted

Clustered Index and Sorting

2 votes
Accepted

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

3 votes
Accepted

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

6 votes
Accepted

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

2 votes
Accepted

SQL Profiler shows multiple calls for one TVF

2 votes
Accepted

Find a doubled value between two columns in the same row

3 votes

Is Trace Flag 6534 Relevant Past SQL Server 2016?

2 votes

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

1 vote

Difference between statement for declaring variable MSSQL

3 votes
Accepted

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

13 votes

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

3 votes
Accepted

Aggregate PARTITION BY 3 columns, one being year. Adds multiple projects in every year after first

5 votes
Accepted

Fill in missing periods in between periods where missing transactions

2 votes

SQL Server - Create new database without model tables

4 votes
Accepted

In SQL Server, is there a way to pivot on an unknown number columns WITHOUT using dynamic SQL?

10 votes
Accepted

tune WHERE datediff

1 vote
Accepted

Select rows where result appears more than once

1 vote
Accepted

Restore fails in single mode because exclusive access cannot be obtained

1 vote
Accepted

Fill down if no value in period, autoknow the periods

11 votes

Add partitioning to unpartitioned table with minimal downtime

4 votes
Accepted

Watch and log query from a user on SQL server?

1
2 3 4 5
78