User Danielle Paquette-Harvey

17 votes

7 answers

77k views

Error 3154 while restoring a backup using WITH REPLACE

asked Jun 20, 2013 at 15:21

16 votes

2 answers

3k views

SQL estimates are way off on DELETE statement with Triggers on huge tables

asked Mar 17, 2020 at 13:58

11 votes

1 answer

663 views

What does it means when you have "sql_exit_invoked" in System Health?

asked Dec 13, 2018 at 14:43

7 votes

2 answers

923 views

How to make sure change_tracking statistics stays updated

asked Nov 1, 2019 at 14:29

7 votes

1 answer

3k views

SQL Server 2019 service terminated unexpectedly at startup but manually starts

asked Jan 18, 2021 at 16:35

7 votes

1 answer

871 views

Change tracking causing latch contention

asked Jan 22, 2020 at 15:50

5 votes

1 answer

602 views

Should the Query Store be enabled on all databases?

asked Feb 19, 2019 at 19:35

3 votes

1 answer

400 views

SQL Server 2016 All Queries recompile all the time (plan cache corruption?)

asked Mar 19, 2018 at 20:36

3 votes

0 answers

112 views

SQL Server should I format with ReFS to get rid of operating system error 665? [duplicate]

asked Aug 31, 2021 at 19:25

2 votes

1 answer

2k views

Is there a way to get index fragmentation without using dm_db_index_physical_stats? [duplicate]

asked Jun 22, 2017 at 14:00

2 votes

2 answers

4k views

What is the best way to compare values of whole tables between many databases?

asked Mar 5, 2015 at 18:57

2 votes

0 answers

998 views

Does Trace Flag 8295 applies to SQL Server 2012?

asked May 4, 2016 at 17:28

1 vote

1 answer

46 views

Does an INSTEAD OF trigger gets re-created every time you insert into a view?

asked Nov 8, 2017 at 19:31

1 vote

1 answer

513 views

Entries in suspect_pages but checkdb shows no error

asked Nov 15, 2019 at 18:05

1 vote

1 answer

569 views

What is the best way to find rows where a datetime is included in the range of two datetime columns [duplicate]

asked Jan 27, 2021 at 16:36

1 vote

1 answer

312 views

Query Store internal queries being executed thousands of times per minute

asked Nov 26, 2021 at 20:09

1 vote

2 answers

276 views

Custom index maintenance percentages for a very large table

asked Dec 16, 2020 at 20:20

0 votes

1 answer

108 views

How do SQL Server allocate RAM for Job steps?

asked Oct 13, 2022 at 14:54

0 votes

0 answers

54 views

SQL Server 2019 Log shipping standby Server stops responding and has a big "Index Searches/Sec" and "Locks" surge (running queries at 0)

asked May 3 at 18:42

0 votes

1 answer

199 views

High Latch Wait time with Logon trigger enabled while full backups are running

asked Feb 22, 2021 at 20:41

0 votes

1 answer

294 views

SQL job sending email even if not configured to send notifications

asked Jun 17, 2021 at 15:42

0 votes

1 answer

3k views

What can cause DBCC CheckDB to take longer than usual? [closed]

asked Oct 18, 2017 at 14:33

0 votes

1 answer

331 views

Call to sysmail_delete_mailitems_sp keeps deadlocking

asked Jul 14, 2016 at 13:14

Stack Exchange Network

23 Questions

Error 3154 while restoring a backup using WITH REPLACE

SQL estimates are way off on DELETE statement with Triggers on huge tables

What does it means when you have "sql_exit_invoked" in System Health?

How to make sure change_tracking statistics stays updated

SQL Server 2019 service terminated unexpectedly at startup but manually starts

Change tracking causing latch contention

Should the Query Store be enabled on all databases?

SQL Server 2016 All Queries recompile all the time (plan cache corruption?)

SQL Server should I format with ReFS to get rid of operating system error 665? [duplicate]

Is there a way to get index fragmentation without using dm_db_index_physical_stats? [duplicate]

What is the best way to compare values of whole tables between many databases?

Does Trace Flag 8295 applies to SQL Server 2012?

Does an INSTEAD OF trigger gets re-created every time you insert into a view?

Entries in suspect_pages but checkdb shows no error

What is the best way to find rows where a datetime is included in the range of two datetime columns [duplicate]

Query Store internal queries being executed thousands of times per minute

Custom index maintenance percentages for a very large table

How do SQL Server allocate RAM for Job steps?

SQL Server 2019 Log shipping standby Server stops responding and has a big "Index Searches/Sec" and "Locks" surge (running queries at 0)

High Latch Wait time with Logon trigger enabled while full backups are running

SQL job sending email even if not configured to send notifications

What can cause DBCC CheckDB to take longer than usual? [closed]

Call to sysmail_delete_mailitems_sp keeps deadlocking