Radu Gheorghiu's user avatar
Radu Gheorghiu's user avatar
Radu Gheorghiu's user avatar
Radu Gheorghiu
  • Member for 10 years, 4 months
  • Last seen more than a month ago
14 votes
4 answers
1k views

Change query to improve operator estimates

11 votes
1 answer
2k views

Identify root cause for why database is stuck in RESTORING state

8 votes
1 answer
1k views

Why does OPTION RECOMPILE cause a predicate pushdown?

6 votes
1 answer
597 views

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

5 votes
2 answers
637 views

Alternative to triggers on system views for user auditing

4 votes
2 answers
6k views

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

3 votes
2 answers
13k views

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

3 votes
1 answer
1k views

Improve reporting stored procedure execution time - tuning temporary tables?

3 votes
0 answers
14k views

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

3 votes
1 answer
421 views

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

3 votes
2 answers
522 views

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

2 votes
1 answer
3k views

Forcing a hash join on a temporary table generates error

2 votes
1 answer
8k views

Restore differential backup error - no files are ready to rollforward

2 votes
1 answer
3k views

SQL Server job to use external Powershell

2 votes
0 answers
2k views

Same query on two identical databases take different time

1 vote
3 answers
120 views

Identify cached data for a specific query in data cache

1 vote
1 answer
44 views

Finding source query in execution plan of nested views and UDFs

0 votes
0 answers
156 views

Template error handling in a SQL Server script

0 votes
0 answers
96 views

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

0 votes
3 answers
189 views

Access to tables in SQL Server

0 votes
2 answers
8k views

Check progress of database restore running asynchronously