User Danielle Paquette-Harvey

12 votes

Is It normal to keep log file larger than data file?

answered Oct 1, 2019 at 15:30

9 votes

Accepted

SQL Server Long Running Transaction - WAITFOR(RECEIVE conversation....DatabaseMail)

answered Jan 18, 2021 at 19:07

8 votes

Accepted

What's the most efficient way to safely convert from Datetime2 back to Datetime

answered Dec 23, 2020 at 20:00

7 votes

Why is the processor % different in Activity Monitor vs Resource Monitor?

answered Sep 8, 2016 at 14:21

5 votes

Accepted

Drop the last character of string, if the last character is s

answered Jan 21, 2021 at 13:42

4 votes

Which Plan is Better? WHERE EXISTS Instead of INNER JOIN

answered Oct 29, 2019 at 15:18

3 votes

running many CREATE VIEW and GRANT SELECT statements in one execution

answered Sep 4, 2018 at 19:54

3 votes

Is there a way to determine if SQL Server queries are running in memory or going to disk?

answered Jan 30, 2013 at 13:53

2 votes

How to debug deadlocks in SQL Server 2008 R2?

answered Sep 26, 2012 at 13:49

2 votes

Accepted

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

answered Jun 22, 2017 at 16:11

2 votes

Accepted

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

answered Mar 6, 2015 at 14:16

2 votes

SQL Server Management Studio - Cannot connect - Method not found SqlConnectionInfo.set_IsActiveDirectoryUniversalAuth

answered Feb 9, 2018 at 16:26

2 votes

Accepted

Parameterize table name in dynamic SQL

answered Jul 20, 2018 at 18:42

2 votes

Accepted

Does SQL Server optimize two ">" operations on same column

answered Dec 23, 2020 at 13:43

2 votes

Accepted

Pointing the database secondary data file towards a network drive

answered Jan 14, 2021 at 15:25

2 votes

Accepted

SQL Server 2019 service terminated unexpectedly at startup but manually starts

answered Aug 8, 2022 at 19:53

1 vote

How to monitor performance in application insights of an on prem SQL Server database?

answered Jan 26, 2021 at 11:25

1 vote

ERROR 1064 (42000): You have an error in your SQL syntax - Cannot understand what the error means

answered Jan 4, 2021 at 19:26

1 vote

intra-query parallel thread deadlocks with only Page Locks with snapshot isolation and change tracking

answered Dec 23, 2020 at 18:17

1 vote

Data storage for analytics

answered Dec 24, 2020 at 13:58

1 vote

Load balancing Availability groups with SQL Server Standard

answered Jan 18, 2019 at 15:00

1 vote

Temporarily disable SQL Server Mirroring

answered Oct 8, 2019 at 14:04

1 vote

`CHANGE_TRACKING = AUTO` fails to populate full-text index

answered Oct 8, 2019 at 14:16

1 vote

Accepted

Entries in suspect_pages but checkdb shows no error

answered Nov 18, 2019 at 13:32

1 vote

SQL Query taking long to execute especially with offset and fetch for pagination

answered May 11, 2020 at 14:45

1 vote

Accepted

How to select info about indexes with specified columns from all databases in the instance using TSQL?

answered Aug 27, 2018 at 14:00

1 vote

SQL Query optimization - Long running query

answered Dec 5, 2017 at 15:25

1 vote

Any reasons trigger AFTER INSERT would not fire?

answered Mar 5, 2015 at 18:36

0 votes

SQL Server 2000 performance

answered Jan 9, 2013 at 16:10

0 votes

Is it possible to improve the execution performance of a query with 'simple' joins?

answered Jun 22, 2017 at 17:55

Stack Exchange Network

42 Answers

Is It normal to keep log file larger than data file?

SQL Server Long Running Transaction - WAITFOR(RECEIVE conversation....DatabaseMail)

What's the most efficient way to safely convert from Datetime2 back to Datetime

Why is the processor % different in Activity Monitor vs Resource Monitor?

Drop the last character of string, if the last character is s

Which Plan is Better? WHERE EXISTS Instead of INNER JOIN

running many CREATE VIEW and GRANT SELECT statements in one execution

Is there a way to determine if SQL Server queries are running in memory or going to disk?

How to debug deadlocks in SQL Server 2008 R2?

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

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

SQL Server Management Studio - Cannot connect - Method not found SqlConnectionInfo.set_IsActiveDirectoryUniversalAuth

Parameterize table name in dynamic SQL

Does SQL Server optimize two ">" operations on same column

Pointing the database secondary data file towards a network drive

SQL Server 2019 service terminated unexpectedly at startup but manually starts

How to monitor performance in application insights of an on prem SQL Server database?

ERROR 1064 (42000): You have an error in your SQL syntax - Cannot understand what the error means

intra-query parallel thread deadlocks with only Page Locks with snapshot isolation and change tracking

Data storage for analytics

Load balancing Availability groups with SQL Server Standard

Temporarily disable SQL Server Mirroring

`CHANGE_TRACKING = AUTO` fails to populate full-text index

Entries in suspect_pages but checkdb shows no error

SQL Query taking long to execute especially with offset and fetch for pagination

How to select info about indexes with specified columns from all databases in the instance using TSQL?

SQL Query optimization - Long running query

Any reasons trigger AFTER INSERT would not fire?

SQL Server 2000 performance

Is it possible to improve the execution performance of a query with 'simple' joins?