User crokusek

11 votes

2 answers

11k views

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

asked Jun 1, 2013 at 1:01

11 votes

2 answers

3k views

Is support for Parallel Scalar UDF a reasonable feature request?

sql-server parallelism functions

asked Jul 24, 2014 at 21:43

10 votes

3 answers

20k views

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

sql-server backup error-handling

asked Jun 25, 2012 at 19:41

10 votes

2 answers

20k views

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

sql-server sql-server-agent active-directory jobs

asked Dec 6, 2013 at 2:01

9 votes

3 answers

386 views

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

sql-server sql-server-2012 optimization view

asked Apr 8, 2016 at 23:54

8 votes

1 answer

458 views

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

sql-server join hints azure-sql-data-warehouse sql-server-pdw

asked Jan 24, 2019 at 20:20

8 votes

1 answer

463 views

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

sql-server index optimization group-by distinct

asked Mar 26, 2015 at 17:41

7 votes

1 answer

1k views

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

sql-server execution-plan view cross-apply

asked Jan 25, 2019 at 1:15

6 votes

2 answers

1k views

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

sql-server optimization join hints merge

asked Jun 15, 2012 at 2:53

6 votes

1 answer

5k views

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

sql-server type-conversion cast sql-variant-property

asked Jan 14, 2014 at 2:36

6 votes

1 answer

449 views

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

sql-server statistics eav cardinality-estimates

asked May 20, 2014 at 3:45

5 votes

1 answer

9k views

Querying True Physical Database File Sizes

sql-server database-size

asked Jun 23, 2016 at 18:35

4 votes

1 answer

2k views

Read system_health event_file instead of ring_buffer for deadlocks extended events

sql-server sql-server-2012 deadlock xml extended-events

asked Mar 10, 2017 at 3:55

4 votes

1 answer

247 views

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

sql-server columnstore sql-server-2019

asked Jun 1, 2020 at 22:36

4 votes

1 answer

834 views

Why does Recursive CTE estimate just 1 row?

sql-server sql-server-2012 cte recursive cardinality-estimates

asked Aug 8, 2014 at 20:51

3 votes

1 answer

3k views

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

sql-server trigger delete exception raiserror

asked Jan 30, 2014 at 19:47

3 votes

0 answers

237 views

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

sql-server performance clustered-index parallelism nonclustered-index

asked Oct 25, 2013 at 2:18

3 votes

1 answer

2k views

Unable to run union in parallel on SQL Server

sql-server union

asked Mar 22, 2013 at 21:54

3 votes

1 answer

948 views

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

sql-server execution-plan tempdb

asked Apr 25, 2013 at 23:44

3 votes

1 answer

86 views

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

sql-server query-performance execution-plan cardinality-estimates

asked Oct 29, 2021 at 23:36

3 votes

0 answers

76 views

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

sql-server update insert

asked Aug 21, 2018 at 19:07

2 votes

1 answer

636 views

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

sql-server locking deadlock upsert

asked Jan 9, 2014 at 20:33

2 votes

2 answers

3k views

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

sql-server statistics optimization cardinality-estimates

asked Apr 28, 2014 at 18:28

1 vote

0 answers

739 views

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

sql-server-2012 permissions sql-server-agent

asked Aug 23, 2014 at 3:46

1 vote

1 answer

759 views

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

sql-server parallelism

asked Nov 20, 2013 at 1:04

1 vote

2 answers

166 views

Workaround to implement Minimum Degree of Parallelism

sql-server maxdop

asked Dec 10, 2018 at 18:35

1 vote

0 answers

129 views

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

information-schema

asked Nov 8, 2016 at 23:21

0 votes

1 answer

1k views

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

sql-server transaction timeout

asked Jul 23, 2014 at 0:02

-4 votes

2 answers

2k views

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

sql-server optimization tempdb

asked Aug 2, 2013 at 23:56

Stack Exchange Network

current community

your communities

more stack exchange communities

29 Questions

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

Is support for Parallel Scalar UDF a reasonable feature request?

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

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

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

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

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

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

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

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

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

Querying True Physical Database File Sizes

Read system_health event_file instead of ring_buffer for deadlocks extended events

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

Why does Recursive CTE estimate just 1 row?

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

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

Unable to run union in parallel on SQL Server

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

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

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

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

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

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

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

Workaround to implement Minimum Degree of Parallelism

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

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

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