User Paul White

191 votes

Accepted

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

answered Nov 18, 2016 at 5:44

120 votes

Accepted

MERGE a subset of the target table

answered Dec 18, 2012 at 9:20

101 votes

Accepted

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

answered Jun 4, 2016 at 6:35

61 votes

Accepted

DELETE vs TRUNCATE

answered Dec 13, 2012 at 11:02

61 votes

Accepted

Unexpected scans during delete operation using WHERE IN

answered Jun 3, 2012 at 9:51

58 votes

Accepted

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

answered Oct 3, 2017 at 15:14

57 votes

Accepted

Outer Apply vs Left Join Performance

answered Dec 21, 2014 at 12:21

54 votes

Accepted

Does the order of columns in a PK index matter?

answered Aug 21, 2013 at 8:42

52 votes

Accepted

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

answered Nov 25, 2012 at 12:44

51 votes

Accepted

Why is COALESCE not a function?

answered Apr 28 at 13:09

48 votes

Accepted

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

answered Aug 19, 2015 at 10:44

47 votes

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

answered Jul 13, 2013 at 13:49

44 votes

Accepted

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

answered Sep 25, 2012 at 7:10

44 votes

Accepted

difference in execution plans on UAT and PROD server

answered Nov 26, 2013 at 23:38

43 votes

Methods for finding new Trace Flags in SQL Server

answered Jun 14, 2016 at 14:24

42 votes

Accepted

Excessive sort memory grant

answered Dec 17, 2014 at 10:12

41 votes

Accepted

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

answered Feb 13, 2014 at 20:49

41 votes

Accepted

Optimising plans with XML readers

answered Dec 22, 2012 at 6:40

40 votes

Accepted

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

answered Jan 28, 2012 at 0:06

40 votes

Accepted

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

answered Nov 18, 2014 at 12:07

39 votes

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

answered Sep 19, 2011 at 18:43

38 votes

Accepted

SQL query for combinations without repetition

answered Dec 2, 2012 at 7:11

38 votes

SQL Server unpredictable select results (dbms error?)

answered Apr 21, 2015 at 3:13

37 votes

Accepted

IF EXISTS taking longer than embedded select statement

answered Jan 15, 2016 at 0:03

37 votes

Accepted

Why does a simple loop result in ASYNC_NETWORK_IO waits?

answered Mar 22, 2019 at 6:42

36 votes

Accepted

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

answered Oct 1, 2017 at 6:21

36 votes

Accepted

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

answered Jan 5, 2012 at 17:42

35 votes

Merge statement deadlocking itself

answered Sep 3, 2012 at 13:48

34 votes

Accepted

How do I drop a database which has brackets in its name?

answered Jul 26 at 7:00

33 votes

Accepted

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

answered May 21, 2014 at 13:31

Stack Exchange Network

1,387 Answers

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

MERGE a subset of the target table

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

DELETE vs TRUNCATE

Unexpected scans during delete operation using WHERE IN

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

Outer Apply vs Left Join Performance

Does the order of columns in a PK index matter?

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

Why is COALESCE not a function?

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

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

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

difference in execution plans on UAT and PROD server

Methods for finding new Trace Flags in SQL Server

Excessive sort memory grant

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

Optimising plans with XML readers

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

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

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

SQL query for combinations without repetition

SQL Server unpredictable select results (dbms error?)

IF EXISTS taking longer than embedded select statement

Why does a simple loop result in ASYNC_NETWORK_IO waits?

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

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

Merge statement deadlocking itself

How do I drop a database which has brackets in its name?

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