User Radu Gheorghiu

14 votes

4 answers

1k views

Change query to improve operator estimates

asked Feb 16, 2017 at 11:25

11 votes

1 answer

2k views

Identify root cause for why database is stuck in RESTORING state

asked Oct 2, 2017 at 13:54

9 votes

1 answer

2k views

Why does OPTION RECOMPILE cause a predicate pushdown?

asked Feb 25, 2022 at 1:14

6 votes

1 answer

678 views

Actual rows read in a table scan is multiplied by the number of threads used for the scan

asked Aug 31, 2018 at 14:22

5 votes

2 answers

641 views

Alternative to triggers on system views for user auditing

asked May 16, 2017 at 14:23

4 votes

0 answers

15k views

SQL Server Database Engine cannot obtain a LOCK resource at this time

asked Oct 24, 2017 at 10:04

4 votes

2 answers

7k views

Query to find plan details for a specific stored procedure, searching by name

asked Jul 6, 2016 at 12:41

3 votes

2 answers

13k views

SET STATISTICS TIME ON elapsed time is different than actual execution time

asked Nov 8, 2016 at 15:09

3 votes

1 answer

1k views

Improve reporting stored procedure execution time - tuning temporary tables?

asked Aug 8, 2016 at 7:33

3 votes

1 answer

8k views

Restore differential backup error - no files are ready to rollforward

asked Aug 19, 2016 at 10:44

3 votes

1 answer

3k views

SQL Server job to use external Powershell

asked Aug 30, 2016 at 13:59

3 votes

1 answer

430 views

Why does an index scan read more pages than exist in an index?

asked Jan 12, 2018 at 13:34

3 votes

2 answers

529 views

High number of page reads and PLE counter, but only when tracing with Profiler

asked Dec 22, 2016 at 9:46

2 votes

1 answer

3k views

Forcing a hash join on a temporary table generates error

asked Mar 22, 2017 at 12:49

2 votes

0 answers

2k views

Same query on two identical databases take different time

asked Oct 19, 2016 at 15:47

1 vote

3 answers

145 views

Identify cached data for a specific query in data cache

asked Dec 16, 2016 at 10:53

1 vote

1 answer

52 views

Finding source query in execution plan of nested views and UDFs

asked Dec 2, 2021 at 23:29

0 votes

0 answers

159 views

Template error handling in a SQL Server script

asked Oct 15, 2019 at 8:52

0 votes

0 answers

97 views

NULL value in query_plan column from the sys.dm_exec_query_plan DMV [duplicate]

asked Jul 6, 2016 at 14:05

0 votes

3 answers

189 views

Access to tables in SQL Server

asked Jun 12, 2013 at 8:33

0 votes

2 answers

8k views

Check progress of database restore running asynchronously

asked Apr 2, 2018 at 7:54

Stack Exchange Network

21 Questions

Change query to improve operator estimates

Identify root cause for why database is stuck in RESTORING state

Why does OPTION RECOMPILE cause a predicate pushdown?

Actual rows read in a table scan is multiplied by the number of threads used for the scan

Alternative to triggers on system views for user auditing

SQL Server Database Engine cannot obtain a LOCK resource at this time

Query to find plan details for a specific stored procedure, searching by name

SET STATISTICS TIME ON elapsed time is different than actual execution time

Improve reporting stored procedure execution time - tuning temporary tables?

Restore differential backup error - no files are ready to rollforward

SQL Server job to use external Powershell

Why does an index scan read more pages than exist in an index?

High number of page reads and PLE counter, but only when tracing with Profiler

Forcing a hash join on a temporary table generates error

Same query on two identical databases take different time

Identify cached data for a specific query in data cache

Finding source query in execution plan of nested views and UDFs

Template error handling in a SQL Server script

NULL value in query_plan column from the sys.dm_exec_query_plan DMV [duplicate]

Access to tables in SQL Server

Check progress of database restore running asynchronously