Database Administrators
Paul White's user avatar
Paul White's user avatar
Paul White's user avatar
Paul White
Moderator
  • Member for 12 years, 6 months
  • Last seen this week
Profile Activity
Stats
82,157
reputation
6.0m
reached
1,317
answers
22
questions
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
398
silver badges
624
bronze badges
Top tags
View all tags
10,205
Score
1,145
Posts
86
Posts %
1,809
Score
166
Posts
12
Posts %
1,577
Score
165
Posts
12
Posts %
1,368
Score
140
Posts
10
Posts %
1,182
Score
142
Posts
11
Posts %
1,078
Score
99
Posts
7
Posts %
Top posts
View all questions and answers
All Questions Answers
Score Newest
answer
190
Authoritative source that <> and != are identical in performance in SQL Server
Nov 18, 2016
answer
116
MERGE a subset of the target table
Dec 18, 2012
question
103
Retrieving n rows per group
Dec 17, 2014
answer
95
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
61
Is there any benefit to SCHEMABINDING a function beyond Halloween Protection?
Jun 4, 2016
answer
61
DELETE vs TRUNCATE
Dec 13, 2012
answer
61
Unexpected scans during delete operation using WHERE IN
Jun 3, 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.