Database Administrators
Paul White's user avatar
Paul White's user avatar
Paul White's user avatar
Paul White
Moderator
  • Member for 12 years, 8 months
  • Last seen this week
Profile Activity
Stats
82,934
reputation
6.2m
reached
1,329
answers
22
questions
top 0.09% this year
Communities
About

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.

Badges
View all badges
28
gold badges
400
silver badges
630
bronze badges
Top tags
View all tags
10,273
Score
1,157
Posts
86
Posts %
1,814
Score
166
Posts
12
Posts %
1,594
Score
168
Posts
12
Posts %
1,371
Score
140
Posts
10
Posts %
1,183
Score
142
Posts
11
Posts %
1,080
Score
99
Posts
7
Posts %
Top posts
View all questions and answers
All Questions Answers
Score Newest
answer
192
Authoritative source that <> and != are identical in performance in SQL Server
Nov 18, 2016
answer
118
MERGE a subset of the target table
Dec 18, 2012
question
103
Retrieving n rows per group
Dec 17, 2014
answer
97
Is there any benefit to SCHEMABINDING a function beyond Halloween Protection?
Jun 4, 2016
question
63
Date range rolling sum using window functions
Sep 7, 2015
question
62
Is there any benefit to SCHEMABINDING a function beyond Halloween Protection?
Jun 4, 2016
answer
61
Unexpected scans during delete operation using WHERE IN
Jun 3, 2012
answer
61
DELETE vs TRUNCATE
Dec 13, 2012
answer
58
How do you create a view with SNAPSHOT_MATERIALIZATION in SQL Server 2017?
Oct 3, 2017
answer
55
Outer Apply vs Left Join Performance
Dec 21, 2014
Top Meta posts
19
203
41
Let's burninate the SQL tag!
30
Asking query performance questions
28
Why are users correcting my British English answers to the American spelling?
26
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

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.