crokusek's user avatar
crokusek's user avatar
crokusek's user avatar
crokusek
  • Member for 11 years, 5 months
  • Last seen this week
11 votes
2 answers
11k views

How can row estimates be improved in order to reduce chances of spills to tempdb

11 votes
2 answers
3k views

Is support for Parallel Scalar UDF a reasonable feature request?

10 votes
3 answers
21k views

How to log error details when using using try/catch for dynamic SQL backup commands

10 votes
2 answers
21k views

How to clear an Error 15404 after a DB restart (besides rebooting)

9 votes
3 answers
433 views

How to improve estimate of 1 row in a View constrained by DateAdd() against an index

8 votes
1 answer
634 views

What cases benefit from the Reduce, Replicate, and Redistribute join hints?

8 votes
1 answer
583 views

Is it possible to get seek based parallel plan for distinct/group by?

7 votes
1 answer
2k views

How to get cross apply to operate row by row on a view?

6 votes
2 answers
1k views

How to use merge hints to isolate complex queries in SQL Server

6 votes
1 answer
5k views

Why does implicit conversion from sql_variant (basetype decimal) not work well with float

6 votes
1 answer
463 views

Why is an additional filtered statistic being ignored (EAV schema)?

5 votes
1 answer
467 views

How to control Segmentation min/max data_id on a non-clustered ColumnStore index

5 votes
1 answer
10k views

Querying True Physical Database File Sizes

5 votes
1 answer
3k views

Read system_health event_file instead of ring_buffer for deadlocks extended events

4 votes
1 answer
950 views

Why does Recursive CTE estimate just 1 row?

3 votes
0 answers
242 views

Why does removing a RID by creating a clustered index lose parallelism and slow down execution by 2X

3 votes
1 answer
2k views

Unable to run union in parallel on SQL Server

3 votes
1 answer
1k views

How to determine cause of runtime increase given two query plans with SpillToTempDb warning

3 votes
0 answers
76 views

Where is Newid(), Rand(), and Sysutcdatetime() new value per query vs. row behavior documented? [duplicate]

3 votes
1 answer
220 views

How to correct row estimates due to join of 2 well-estimated results

2 votes
1 answer
684 views

How to use proper hints for Upsert involving a top 1 subquery

2 votes
1 answer
3k views

Is it possible to raiserror within a For Delete Trigger that rolls back the deletes

2 votes
2 answers
3k views

How to improve row estimate of 1 row in join for newly inserted data

1 vote
0 answers
782 views

What are recommended (working) permissions for a user to view all SQL Agent jobs

1 vote
1 answer
782 views

How is parallelism threshold (seconds) used if query CPU cost is actually unitless

1 vote
2 answers
195 views

Workaround to implement Minimum Degree of Parallelism

1 vote
0 answers
130 views

Schema transfer of SP does not update information_schema.routines.routine_definition / object_definition?

0 votes
1 answer
1k views

Is is possible to handle a UserAbort or ClientTimeOut within a Stored Procedure?

-4 votes
2 answers
2k views

How to improve TempDb on RAMDisk showing performance on par with physical hard drive [closed]