Paul White

New Zealand

https://sql.kiwi

SQL Server Data Platform MVP 2011-2022

Blog: sql.kiwi or paulwhite.nz
Articles: SQLPerformance.com
Twitter: @SQL_Kiwi
Email: [email protected]

I will not respond to DBA site moderation questions off site. Use Database Administrators meta instead.

top accounts reputation activity subscriptions

Retrieving n rows per group

sql-server t-sql greatest-n-per-group asked Dec 17, 2014 at 14:33

dba.stackexchange.com

65 votes

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

sql-server functions asked Jun 4, 2016 at 6:35

dba.stackexchange.com

63 votes

Date range rolling sum using window functions

sql-server sql-server-2012 performance t-sql window-functions query-performance asked Sep 7, 2015 at 20:13

dba.stackexchange.com

47 votes

Excessive sort memory grant

sql-server execution-plan memory-grant asked Dec 17, 2014 at 10:12

dba.stackexchange.com

27 votes

Logical reads different when accessing the same LOB data

sql-server performance blob database-internals asked May 8, 2016 at 14:07

dba.stackexchange.com

24 votes

Does SQL Server cache the result of a multi-statement table-valued function?

sql-server execution-plan table-valued-functions asked Dec 28, 2016 at 13:20

dba.stackexchange.com

24 votes

When does SQL Server warn about an Excessive Memory Grant?

sql-server execution-plan warning memory-grant asked Jan 28, 2019 at 12:15

dba.stackexchange.com

21 votes

Should moderators be able to undelete any comment, including self-deletions?

discussion moderator-tools moderator-abilities deleted-comments asked Jun 19, 2021 at 10:30

meta.stackexchange.com

20 votes

Should Jeff Atwood's question about downvote weight be unlocked?

discussion locked-questions locked-votes asked Jun 15, 2021 at 11:28

meta.stackexchange.com

20 votes

Nonclustered index storage on clustered columnstore

sql-server sql-server-2016 database-internals columnstore asked Jan 6, 2017 at 8:30

dba.stackexchange.com

Top Answers

193

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

dba.stackexchange.com

120

MERGE a subset of the target table

dba.stackexchange.com

101

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

dba.stackexchange.com

DELETE vs TRUNCATE

dba.stackexchange.com

Unexpected scans during delete operation using WHERE IN

dba.stackexchange.com

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

dba.stackexchange.com

Outer Apply vs Left Join Performance

dba.stackexchange.com

Does the order of columns in a PK index matter?

dba.stackexchange.com

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

dba.stackexchange.com

Why is COALESCE not a function?

dba.stackexchange.com

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

dba.stackexchange.com

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

dba.stackexchange.com

difference in execution plans on UAT and PROD server

dba.stackexchange.com

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

dba.stackexchange.com

Methods for finding new Trace Flags in SQL Server

dba.stackexchange.com

Excessive sort memory grant

dba.stackexchange.com

Optimising plans with XML readers

dba.stackexchange.com

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

dba.stackexchange.com

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

dba.stackexchange.com

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

dba.stackexchange.com

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

dba.stackexchange.com

SQL query for combinations without repetition

dba.stackexchange.com

SQL Server unpredictable select results (dbms error?)

dba.stackexchange.com

IF EXISTS taking longer than embedded select statement

dba.stackexchange.com

Why does a simple loop result in ASYNC_NETWORK_IO waits?

dba.stackexchange.com

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

dba.stackexchange.com

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

dba.stackexchange.com

Merge statement deadlocking itself

dba.stackexchange.com

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

dba.stackexchange.com

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

dba.stackexchange.com