Database Administrators
Paul White's user avatar
Paul White's user avatar
Paul White's user avatar
Paul White
Moderator
  • Member for 11 years, 6 months
  • Last seen this week
Profile Activity
Stats
73,840
reputation
5.3m
reached
1,210
answers
21
questions
Communities
About

SQL Server Data Platform MVP 2011-2022

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

Badges
View all badges
26
gold badges
381
silver badges
596
bronze badges
Top tags
View all tags
9,571
Score
1,050
Posts
85
Posts %
1,764
Score
157
Posts
13
Posts %
1,479
Score
152
Posts
12
Posts %
1,295
Score
131
Posts
11
Posts %
1,153
Score
137
Posts
11
Posts %
1,058
Score
96
Posts
8
Posts %
Top posts
View all questions and answers
All Questions Answers
Score Newest
answer
176
Authoritative source that <> and != are identical in performance in SQL Server
Nov 18, 2016
answer
111
MERGE a subset of the target table
Dec 18, 2012
question
99
Retrieving n rows per group
Dec 17, 2014
answer
92
Is there any benefit to SCHEMABINDING a function beyond Halloween Protection?
Jun 4, 2016
question
61
Date range rolling sum using window functions
Sep 7, 2015
answer
61
Unexpected scans during delete operation using WHERE IN
Jun 3, 2012
answer
61
DELETE vs TRUNCATE
Dec 13, 2012
question
59
Is there any benefit to SCHEMABINDING a function beyond Halloween Protection?
Jun 4, 2016
answer
58
How do you create a view with SNAPSHOT_MATERIALIZATION in SQL Server 2017?
Oct 3, 2017
answer
54
Does the order of columns in a PK index matter?
Aug 21, 2013
Top Meta posts
19
196
41
Let's burninate the SQL tag!
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?
24
Burninate the [dba] and [database-administration] tags?
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
8
Site footer copyright scope and meaning
8
How to use EXISTS and NOT EXISTS in one query?

Your privacy

By clicking “Accept all cookies”, you agree Stack Exchange can store cookies on your device and disclose information in accordance with our Cookie Policy.