Skip to main content
Database Administrators
Paul White's user avatar
Paul White's user avatar
Paul White's user avatar
Paul White
Moderator
  • Member for 13 years, 4 months
  • Last seen this week
Profile Activity
Stats
86,825
reputation
6.5m
reached
1,365
answers
23
questions
Communities
About

SQL Server Data Platform MVP 2011-2022

Blog: sql.kiwi or paulwhite.nz
Articles: 𝕏 articles and SQLPerformance.com
Find me on 𝕏: @SQL_Kiwi
Email: [email protected]

Latest article: SQL Server Parallel Index Builds

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

Badges
View all badges
30
gold badges
414
silver badges
647
bronze badges
Top tags
View all tags
10,606
Score
1,191
Posts
86
Posts %
1,822
Score
168
Posts
12
Posts %
1,647
Score
174
Posts
13
Posts %
1,391
Score
142
Posts
10
Posts %
1,196
Score
142
Posts
10
Posts %
1,085
Score
99
Posts
7
Posts %
Top posts
View all questions and answers
191
Authoritative source that <> and != are identical in performance in SQL Server
Nov 18, 2016
120
MERGE a subset of the target table
Dec 18, 2012
105
Retrieving n rows per group
Dec 17, 2014
101
Is there any benefit to SCHEMABINDING a function beyond Halloween Protection?
Jun 4, 2016
65
Is there any benefit to SCHEMABINDING a function beyond Halloween Protection?
Jun 4, 2016
63
Date range rolling sum using window functions
Sep 7, 2015
61
DELETE vs TRUNCATE
Dec 13, 2012
61
Unexpected scans during delete operation using WHERE IN
Jun 3, 2012
58
How do you create a view with SNAPSHOT_MATERIALIZATION in SQL Server 2017?
Oct 3, 2017
57
Outer Apply vs Left Join Performance
Dec 21, 2014
Top Meta posts
20
206
41
Let's burninate the SQL tag!
31
Asking query performance questions
28
Why are users correcting my British English answers to the American spelling?
27
Asking query performance questions
24
Should we change the formatting of backtick markdown elements?
Top network posts
View all network posts
21
Should moderators be able to undelete any comment, including self-deletions?
20
Should Jeff Atwood's question about downvote weight be unlocked?
14
Moderators can undelete answers to deleted questions
12
How to use EXISTS and NOT EXISTS in one query?
8
Site footer copyright scope and meaning