Stack Exchange

Paul White 9

New Zealand

https://sql.kiwi

SQL Server Data Platform MVP
SQL Server Data Platform MVP since 2011

Blog: sql.kiwi or paulwhite.nz
Articles: SQLPerformance.com
Twitter: @SQL_Kiwi

top accounts reputation activity bookmarks subscriptions
Top Questions
93 votes

Retrieving n rows per group

sql-server t-sql greatest-n-per-group asked Dec 17 '14 at 14:33
dba.stackexchange.com

59 votes

Date range rolling sum using window functions

sql-server sql-server-2012 performance t-sql window-functions query-performance asked Sep 7 '15 at 20:13
dba.stackexchange.com

56 votes

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

sql-server functions asked Jun 4 '16 at 6:35
dba.stackexchange.com

47 votes

Excessive sort memory grant

sql-server execution-plan memory-grant asked Dec 17 '14 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 '16 at 14:07
dba.stackexchange.com

23 votes

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

sql-server execution-plan table-valued-functions asked Dec 28 '16 at 13:20
dba.stackexchange.com

21 votes

When does SQL Server warn about an Excessive Memory Grant?

sql-server execution-plan warning memory-grant asked Jan 28 '19 at 12:15
dba.stackexchange.com

19 votes

Single-row INSERT…SELECT much slower than separate SELECT

sql-server performance execution-plan insert query-performance asked Feb 25 '19 at 10:22
dba.stackexchange.com

19 votes

CROSS APPLY produces outer join

sql-server execution-plan cross-apply asked Jun 5 '19 at 14:08
dba.stackexchange.com

19 votes

Nonclustered index storage on clustered columnstore

sql-server sql-server-2016 database-internals columnstore asked Jan 6 '17 at 8:30
dba.stackexchange.com

1 2

Top Answers
154
Authoritative source that <> and != are identical in performance in SQL Server
dba.stackexchange.com

108
MERGE a subset of the target table
dba.stackexchange.com

86
Is there any benefit to SCHEMABINDING a function beyond Halloween Protection?
dba.stackexchange.com

61
Unexpected scans during delete operation using WHERE IN
dba.stackexchange.com

59
DELETE vs TRUNCATE
dba.stackexchange.com

56
How do you create a view with SNAPSHOT_MATERIALIZATION in SQL Server 2017?
dba.stackexchange.com

53
Does the order of columns in a PK index matter?
dba.stackexchange.com

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

48
Cannot execute as the database principal because the principal “dbo” does not exist
dba.stackexchange.com

48
Outer Apply vs Left Join Performance
dba.stackexchange.com

45
Check existence with EXISTS outperform COUNT! … Not?
dba.stackexchange.com

44
difference in execution plans on UAT and PROD server
dba.stackexchange.com

42
Methods for finding new Trace Flags in SQL Server
dba.stackexchange.com

42
Excessive sort memory grant
dba.stackexchange.com

41
Why does query error with empty result set in SQL Server 2012?
dba.stackexchange.com

39
How (and why) does TOP impact an execution plan?
dba.stackexchange.com

38
Does SQL Server read all of a COALESCE function even if the first argument is not NULL?
dba.stackexchange.com

38
SLEEP_TASK Wait Type in SQL Server - What does it indicate?
dba.stackexchange.com

38
Optimising plans with XML readers
dba.stackexchange.com

37
SQL Server unpredictable select results (dbms error?)
dba.stackexchange.com

36
SQL query for combinations without repetition
dba.stackexchange.com

35
Inclusion of ORDER BY on query that returns no rows drastically affects performance
dba.stackexchange.com

34
Why does a simple loop result in ASYNC_NETWORK_IO waits?
dba.stackexchange.com

33
Merge statement deadlocking itself
dba.stackexchange.com

33
Why is the speed of executing statements dependent on the network connection?
dba.stackexchange.com

33
Is there a way to prevent Scalar UDFs in computed columns from inhibiting parallelism?
dba.stackexchange.com

33
IF EXISTS taking longer than embedded select statement
dba.stackexchange.com

32
Using MAX text or more specific, smaller type
dba.stackexchange.com

32
Can you use COUNT DISTINCT with an OVER clause?
dba.stackexchange.com

32
What exactly can SQL Server 2014 execute in batch mode?
dba.stackexchange.com

1 2 3 4 5 … 10