User Joe Obbish

31 votes

4 answers

3k views

What is a scalable way to simulate HASHBYTES using a SQL CLR scalar function?

asked Feb 3, 2019 at 16:57

30 votes

1 answer

3k views

Why is a scan faster than seek for this predicate?

asked Oct 3, 2018 at 3:26

29 votes

5 answers

8k views

Why does my SELECT DISTINCT TOP N query scan the entire table?

asked Feb 20, 2017 at 14:39

28 votes

2 answers

3k views

What is a "Partial Matching Index"?

asked Dec 6, 2017 at 13:24

26 votes

2 answers

1k views

Why does a subquery reduce the row estimate to 1?

asked Apr 21, 2017 at 15:33

26 votes

1 answer

3k views

Why does a simple loop result in ASYNC_NETWORK_IO waits?

asked Mar 22, 2019 at 4:21

24 votes

1 answer

4k views

Why doesn't this query use an index spool?

asked May 18, 2017 at 13:47

22 votes

2 answers

2k views

How to prevent statistics creation on a column?

asked Dec 1, 2016 at 18:50

21 votes

3 answers

768 views

Why can it take up to 30 seconds to create a simple CCI rowgroup?

asked Jun 7, 2017 at 15:49

20 votes

2 answers

2k views

Why is this join cardinality estimate so large?

asked Dec 14, 2016 at 22:20

16 votes

1 answer

503 views

Does SQL Server 2019 have task scheduling differences between enterprise and standard editions?

asked Nov 25, 2021 at 3:23

14 votes

1 answer

2k views

Why does a simple natively compiled stored procedure run out of memory when table variables are used?

asked Nov 18, 2022 at 21:13

14 votes

5 answers

503 views

What is the fastest way to convert many nullable ints 1:1 to a binary string?

asked May 8, 2019 at 21:01

14 votes

3 answers

1k views

How can I convert the first 100 million positive integers to strings?

asked May 11, 2017 at 12:22

14 votes

2 answers

2k views

Why is a temp table a more efficient solution to the Halloween Problem than an eager spool?

asked Feb 26, 2019 at 1:27

13 votes

1 answer

2k views

How can I force a scalar UDF to be evaluated just once in a query?

asked Mar 6, 2017 at 14:46

12 votes

1 answer

1k views

How can I prevent UNPIVOT from being transformed into UNION ALL?

asked Mar 29, 2017 at 19:19

12 votes

1 answer

946 views

Why is a parallel top N sort apparently much more CPU efficient than a serial top N sort?

asked Mar 23, 2022 at 23:01

11 votes

2 answers

233 views

What are the practical impacts of the sys.dm_exec_query_stats warning in the documentation?

asked Jun 13, 2019 at 23:25

10 votes

1 answer

250 views

Could I have an undetected deadlock?

asked Sep 16, 2021 at 22:52

10 votes

1 answer

1k views

Can AT TIME ZONE return inaccurate results for data before 2004?

asked Oct 26, 2022 at 17:44

9 votes

2 answers

513 views

How can I get rid of an unhelpful parallel branch when unpivoting a single row?

asked Apr 26, 2019 at 0:25

9 votes

2 answers

266 views

Why does this TVF throw error 9820 with GETDATE() as an input parameter?

asked Jan 10, 2022 at 22:59

7 votes

1 answer

2k views

Why does TRY_CAST throw an error when attempting to convert VARCHAR to UNIQUEIDENTIFIER?

asked Dec 12, 2022 at 16:32

7 votes

1 answer

420 views

Why do some rows returned by sys.dm_exec_query_profiles have "???" for the physical operator name?

asked Mar 22, 2017 at 14:36

7 votes

2 answers

1k views

Do BIT columns offer any performance advantages for CCIs?

asked Aug 15, 2017 at 19:57

6 votes

1 answer

891 views

Is it safe to use Strings instead of SqlStrings for CLR function input parameters?

asked May 19, 2019 at 22:16

6 votes

1 answer

732 views

Why do permission errors doom a transaction with XACT_ABORT set to OFF and ANSI_WARNINGS set to ON?

asked Jul 18, 2022 at 18:40

5 votes

2 answers

295 views

How can I delete extended event files from within Managed Instance?

asked Mar 20 at 19:38

5 votes

1 answer

291 views

How can I verify that all possible FLOAT(53) values convert to unique BINARY(8) values?

asked Jul 10, 2019 at 18:55

Stack Exchange Network

40 Questions

What is a scalable way to simulate HASHBYTES using a SQL CLR scalar function?

Why is a scan faster than seek for this predicate?

Why does my SELECT DISTINCT TOP N query scan the entire table?

What is a "Partial Matching Index"?

Why does a subquery reduce the row estimate to 1?

Why does a simple loop result in ASYNC_NETWORK_IO waits?

Why doesn't this query use an index spool?

How to prevent statistics creation on a column?

Why can it take up to 30 seconds to create a simple CCI rowgroup?

Why is this join cardinality estimate so large?

Does SQL Server 2019 have task scheduling differences between enterprise and standard editions?

Why does a simple natively compiled stored procedure run out of memory when table variables are used?

What is the fastest way to convert many nullable ints 1:1 to a binary string?

How can I convert the first 100 million positive integers to strings?

Why is a temp table a more efficient solution to the Halloween Problem than an eager spool?

How can I force a scalar UDF to be evaluated just once in a query?

How can I prevent UNPIVOT from being transformed into UNION ALL?

Why is a parallel top N sort apparently much more CPU efficient than a serial top N sort?

What are the practical impacts of the sys.dm_exec_query_stats warning in the documentation?

Could I have an undetected deadlock?

Can AT TIME ZONE return inaccurate results for data before 2004?

How can I get rid of an unhelpful parallel branch when unpivoting a single row?

Why does this TVF throw error 9820 with GETDATE() as an input parameter?

Why does TRY_CAST throw an error when attempting to convert VARCHAR to UNIQUEIDENTIFIER?

Why do some rows returned by sys.dm_exec_query_profiles have "???" for the physical operator name?

Do BIT columns offer any performance advantages for CCIs?

Is it safe to use Strings instead of SqlStrings for CLR function input parameters?

Why do permission errors doom a transaction with XACT_ABORT set to OFF and ANSI_WARNINGS set to ON?

How can I delete extended event files from within Managed Instance?

How can I verify that all possible FLOAT(53) values convert to unique BINARY(8) values?