Skip to main content
James Lupolt's user avatar
James Lupolt's user avatar
James Lupolt's user avatar
James Lupolt
  • Member for 12 years, 3 months
  • Last seen more than a week ago
37 votes
3 answers
9k views

Why would a SELECT query cause writes?

29 votes
1 answer
1k views

Is sys.stats_columns incorrect?

28 votes
1 answer
953 views

Is the eager spool operator useful for this delete from a clustered columnstore?

17 votes
2 answers
24k views

"Access is denied" when connecting SSMS to Integration Services

13 votes
1 answer
409 views

Changes to estimates on predicates that contain SUBSTRING() in SQL Server 2016?

13 votes
1 answer
752 views

How deterministic is execution plan creation in SQL Server?

12 votes
2 answers
1k views

Setting READ UNCOMMITTED when reading DMVs

11 votes
1 answer
748 views

Defragmenting SQL Server data and log files live with MoveFile API

9 votes
2 answers
426 views

Is there a way to make this select retrieve the same results with a single seek?

9 votes
1 answer
2k views

Should 'FOR system_time ALL' include rows where the start and end times are equal?

8 votes
1 answer
12k views

How to troubleshoot "client driver has sent multiple requests while the session is in single-user mode"

5 votes
1 answer
18k views

Repairing corrupt SQL Server database backup? [closed]

5 votes
1 answer
1k views

Suggest better design pattern for reverse DNS lookups

4 votes
1 answer
13k views

Analysing SQL Server Network I/O

4 votes
1 answer
3k views

How do I convert between the transaction ID formats in fn_dblog() and sys.dm_tran_database_transactions?

3 votes
0 answers
467 views

Are the following statements concerning sys.dm_exec_requests true?

3 votes
0 answers
2k views

Understanding how sys.dm_exec_requests represents queries being rolled back

2 votes
1 answer
3k views

Resource Usage Statistics by Login

1 vote
1 answer
2k views

Permissions for executing subscription in SSRS