Joe Obbish's user avatar
Joe Obbish's user avatar
Joe Obbish's user avatar
Joe Obbish
  • Member for 7 years, 6 months
  • Last seen this week
31 votes
4 answers
3k views

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

30 votes
1 answer
3k views

Why is a scan faster than seek for this predicate?

29 votes
5 answers
8k views

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

28 votes
2 answers
3k views

What is a "Partial Matching Index"?

26 votes
2 answers
1k views

Why does a subquery reduce the row estimate to 1?

26 votes
1 answer
3k views

Why does a simple loop result in ASYNC_NETWORK_IO waits?

24 votes
1 answer
3k views

Why doesn't this query use an index spool?

22 votes
2 answers
1k views

How to prevent statistics creation on a column?

21 votes
3 answers
756 views

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

20 votes
2 answers
2k views

Why is this join cardinality estimate so large?

16 votes
1 answer
500 views

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

14 votes
1 answer
2k views

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

14 votes
5 answers
459 views

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

14 votes
3 answers
1k views

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

14 votes
2 answers
2k views

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

13 votes
1 answer
2k views

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

12 votes
1 answer
1k views

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

12 votes
1 answer
911 views

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

11 votes
2 answers
220 views

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

10 votes
1 answer
237 views

Could I have an undetected deadlock?

10 votes
1 answer
1k views

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

9 votes
2 answers
508 views

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

9 votes
2 answers
245 views

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

7 votes
1 answer
2k views

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

7 votes
1 answer
382 views

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

7 votes
2 answers
1k views

Do BIT columns offer any performance advantages for CCIs?

6 votes
1 answer
818 views

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

6 votes
1 answer
646 views

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

5 votes
1 answer
271 views

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

4 votes
1 answer
230 views

What are the advantages of a long timeout for RECEIVE in activation procedures?