User crokusek

2

11

votes

2

answers

10k

views

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

Nov 7 '13 at 17:59 crokusek 1,807

3

10

votes

2

answers

2k

views

Is support for Parallel Scalar UDF a reasonable feature request?

sql-server parallelism functions

Nov 24 at 15:07 Paul White 9♦ 54.9k

2

10

votes

3

answers

19k

views

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

sql-server backup error-handling

Feb 8 '17 at 19:01 Aaron Bertrand♦ 167k

4

9

votes

2

answers

17k

views

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

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

Nov 21 '17 at 14:11 Federico 1

3

8

votes

1

answer

278

views

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

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

Jun 12 at 6:01 Community♦ 1

2

8

votes

3

answers

350

views

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

sql-server sql-server-2012 optimization view

May 18 '17 at 15:34 Paul White 9♦ 54.9k

1

7

votes

1

answer

644

views

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

sql-server execution-plan view cross-apply

Jan 26 '19 at 10:12 ypercubeᵀᴹ 86.1k

7

votes

1

answer

340

views

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

sql-server index optimization group-by distinct

Sep 7 '15 at 12:45 Community♦ 1

1

6

votes

1

answer

431

views

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

sql-server statistics eav cardinality-estimates

Aug 19 '15 at 1:33 Paul White 9♦ 54.9k

6

votes

2

answers

927

views

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

sql-server optimization join hints merge

Feb 10 '13 at 19:12 Community♦ 1

5

votes

1

answer

8k

views

Querying True Physical Database File Sizes

sql-server database-size

Aug 14 at 13:22 Aaron Bertrand♦ 167k

5

votes

1

answer

4k

views

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

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

Jan 14 '14 at 10:38 Martin Smith 74.1k

1

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

Aug 18 '17 at 17:39 crokusek 1,807

4

votes

1

answer

674

views

Why does Recursive CTE estimate just 1 row?

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

Sep 28 '15 at 12:01 Community♦ 1

1

3

votes

1

answer

2k

views

Unable to run union in parallel on SQL Server

sql-server union

May 8 at 5:13 Aaron Bertrand♦ 167k

3

votes

0

answers

72

views

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

sql-server update insert

Aug 23 '18 at 11:27 ypercubeᵀᴹ 86.1k

3

votes

1

answer

2k

views

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

sql-server trigger delete exception raiserror

Jan 30 '14 at 21:52 Community♦ 1

1

3

votes

0

answers

227

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

Oct 25 '13 at 19:25 crokusek 1,807

3

votes

1

answer

899

views

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

sql-server execution-plan tempdb

Apr 27 '13 at 12:13 Paul White 9♦ 54.9k

2

votes

1

answer

43

views

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

sql-server columnstore sql-server-2019

Jun 3 at 21:03 crokusek 1,807

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

May 7 '14 at 18:31 Community♦ 1

2

votes

1

answer

552

views

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

sql-server locking deadlock upsert

Jan 10 '14 at 0:39 Community♦ 1

1

vote

2

answers

126

views

Workaround to implement Minimum Degree of Parallelism

sql-server maxdop

Dec 11 '18 at 14:17 John aka hot2use 11.3k

1

vote

0

answers

106

views

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

information-schema

Nov 8 '16 at 23:21 crokusek 1,807

1

vote

0

answers

673

views

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

sql-server-2012 permissions sql-server-agent

Aug 23 '14 at 3:46 Community♦ 1

1

vote

1

answer

733

views

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

sql-server parallelism

Nov 20 '13 at 1:29 Community♦ 1

0

votes

0

answers

17

views

Why do tempdb spills still occur even with good row and data size estimates (better than actuals)?

tempdb cardinality-estimates spills

May 28 at 4:46 Niels Broertjes 379

0

votes

1

answer

1k

views

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

sql-server transaction timeout

Jul 23 '14 at 19:40 Community♦ 1

-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

Aug 5 '13 at 5:08 crokusek 1,807

Stack Exchange Network

current community

your communities

more stack exchange communities

Next privilege

Next badge

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)

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

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

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

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

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

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

Querying True Physical Database File Sizes

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

Read system_health event_file instead of ring_buffer for deadlocks extended events

Why does Recursive CTE estimate just 1 row?

Unable to run union in parallel on SQL Server

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

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

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

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

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

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

Workaround to implement Minimum Degree of Parallelism

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

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

Why do tempdb spills still occur even with good row and data size estimates (better than actuals)?

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]