Paul White's user avatar
Paul White's user avatar
Paul White's user avatar
Paul White
Moderator
  • Member for 13 years, 1 month
  • Last seen this week

29 Earned bounties for 6,475 reputation

6 votes
Accepted
+150

How does SQL Server estimate cardinality on nested loops index seek

2 votes
Accepted
+50

Querying the sys.dm_db_log_info() function while reducing to the max

12 votes
+500

Scalar function alters estimate for preceding operator

8 votes
Accepted
+250

Query Store plan force fails with NO_PLAN dependent on where filter operator is in plan

6 votes
Accepted
+100

How does SQL estimate the number of rows in a less than < Predicate

17 votes
Accepted
+500

Most cost efficient way to page through a poorly ordered table?

11 votes
Accepted
+50

Apply cardinality estimation problem in SQL Server

31 votes
Accepted
+400

Self referencing scalar function nesting level exceeded when adding a select

8 votes
Accepted
+50

Why am I getting a snapshot isolation issue on INSERT?

11 votes
+250

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

21 votes
Accepted
+500

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

21 votes
Accepted
+250

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

13 votes
+25

Why am I not getting minimal logging when inserting to indexed tables

28 votes
Accepted
+100

Strange behaviour with sample sizes for statistics updates

24 votes
Accepted
+100

Why does a subquery reduce the row estimate to 1?

22 votes
Accepted
+100

Why is my index not being used in a SELECT TOP?

15 votes
Accepted
+100

Query doesn't respond when adding two columns

37 votes
Accepted
+100

IF EXISTS taking longer than embedded select statement

24 votes
Accepted
+500

SQL Server 2014: any explanation for inconsistent self join cardinality estimate?

33 votes
Accepted
+250

Can I rely on reading SQL Server Identity values in order?

24 votes
Accepted
+500

Is the eager spool operator useful for this delete from a clustered columnstore?

120 votes
Accepted
+200

MERGE a subset of the target table

25 votes
Accepted
+100

How to recursively find gaps where 90 days passed, between rows

44 votes
Accepted
+50

difference in execution plans on UAT and PROD server

23 votes
Accepted
+250

Index on Persisted Computed column needs key lookup to get columns in the computed expression

61 votes
Accepted
+500

Unexpected scans during delete operation using WHERE IN

41 votes
Accepted
+100

Optimising plans with XML readers

6 votes
+200

Combine Table Hints INDEX and FORCESEEK with Two Joins Not On PK

61 votes
Accepted
+250

Unexpected scans during delete operation using WHERE IN