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
191 votes
Accepted

Authoritative source that <> and != are identical in performance in SQL Server

120 votes
Accepted

MERGE a subset of the target table

98 votes
Accepted

Is there any benefit to SCHEMABINDING a function beyond Halloween Protection?

61 votes
Accepted

DELETE vs TRUNCATE

61 votes
Accepted

Unexpected scans during delete operation using WHERE IN

58 votes
Accepted

How do you create a view with SNAPSHOT_MATERIALIZATION in SQL Server 2017?

56 votes
Accepted

Outer Apply vs Left Join Performance

54 votes
Accepted

Does the order of columns in a PK index matter?

52 votes
Accepted

Execution plan shows expensive CONVERT_IMPLICIT operation. Can I fix this with indexing or do I need to change the table?

48 votes
Accepted

Cannot execute as the database principal because the principal "dbo" does not exist

47 votes

Check existence with EXISTS outperform COUNT! ... Not?

44 votes
Accepted

How (and why) does TOP impact an execution plan?

44 votes
Accepted

difference in execution plans on UAT and PROD server

43 votes

Methods for finding new Trace Flags in SQL Server

42 votes
Accepted

Excessive sort memory grant

41 votes
Accepted

Why does query error with empty result set in SQL Server 2012?

41 votes
Accepted

Optimising plans with XML readers

40 votes
Accepted

SLEEP_TASK Wait Type in SQL Server - What does it indicate?

39 votes

Does SQL Server read all of a COALESCE function even if the first argument is not NULL?

38 votes
Accepted

SQL query for combinations without repetition

38 votes
Accepted

The number of row value expressions in the INSERT statement exceeds the maximum allowed number of 1000 row values

38 votes

SQL Server unpredictable select results (dbms error?)

37 votes
Accepted

IF EXISTS taking longer than embedded select statement

37 votes
Accepted

Why does a simple loop result in ASYNC_NETWORK_IO waits?

36 votes
Accepted

Is there a way to prevent Scalar UDFs in computed columns from inhibiting parallelism?

36 votes
Accepted

Inclusion of ORDER BY on query that returns no rows drastically affects performance

35 votes

Merge statement deadlocking itself

33 votes
Accepted

Why is the speed of executing statements dependent on the network connection?

33 votes
Accepted

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

32 votes
Accepted

What exactly can SQL Server 2014 execute in batch mode?

1
2 3 4 5
45