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, 5 months
  • Last seen more than a month ago
  • Montreal, Canada
12 votes

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

9 votes
Accepted

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

8 votes
Accepted

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

7 votes

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

5 votes
Accepted

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

4 votes

Which Plan is Better? WHERE EXISTS Instead of INNER JOIN

3 votes

running many CREATE VIEW and GRANT SELECT statements in one execution

3 votes

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

2 votes

How to debug deadlocks in SQL Server 2008 R2?

2 votes
Accepted

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

2 votes
Accepted

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

2 votes

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

2 votes
Accepted

Parameterize table name in dynamic SQL

2 votes
Accepted

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

2 votes
Accepted

Pointing the database secondary data file towards a network drive

2 votes
Accepted

SQL Server 2019 service terminated unexpectedly at startup but manually starts

1 vote

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

1 vote

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

1 vote

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

1 vote

Data storage for analytics

1 vote

Load balancing Availability groups with SQL Server Standard

1 vote

Temporarily disable SQL Server Mirroring

1 vote

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

1 vote
Accepted

Entries in suspect_pages but checkdb shows no error

1 vote

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

1 vote
Accepted

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

1 vote

SQL Query optimization - Long running query

1 vote

Any reasons trigger AFTER INSERT would not fire?

0 votes

SQL Server 2000 performance

0 votes

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