Danielle Paquette-Harvey's user avatar
Danielle Paquette-Harvey's user avatar
Danielle Paquette-Harvey's user avatar
Danielle Paquette-Harvey
  • Member for 11 years, 7 months
  • Last seen more than a week ago
  • Montreal, Canada
17 votes
7 answers
77k views

Error 3154 while restoring a backup using WITH REPLACE

16 votes
2 answers
3k views

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

11 votes
1 answer
718 views

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

7 votes
2 answers
981 views

How to make sure change_tracking statistics stays updated

7 votes
1 answer
4k views

SQL Server 2019 service terminated unexpectedly at startup but manually starts

7 votes
1 answer
972 views

Change tracking causing latch contention

6 votes
1 answer
746 views

Should the Query Store be enabled on all databases?

3 votes
1 answer
407 views

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

3 votes
0 answers
120 views

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

2 votes
1 answer
2k views

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

2 votes
2 answers
4k views

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

2 votes
0 answers
1k views

Does Trace Flag 8295 applies to SQL Server 2012?

2 votes
1 answer
559 views

Entries in suspect_pages but checkdb shows no error

1 vote
1 answer
610 views

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

1 vote
1 answer
49 views

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

1 vote
1 answer
427 views

Query Store internal queries being executed thousands of times per minute

1 vote
2 answers
320 views

Custom index maintenance percentages for a very large table

0 votes
1 answer
152 views

How do SQL Server allocate RAM for Job steps?

0 votes
0 answers
62 views

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

0 votes
1 answer
3k views

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

0 votes
1 answer
344 views

Call to sysmail_delete_mailitems_sp keeps deadlocking

0 votes
1 answer
218 views

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

0 votes
1 answer
338 views

SQL job sending email even if not configured to send notifications