Database Administrators
Sponsored by
Sponsored logo
Paul White
Moderator
  • Member for 10 years, 9 months
  • Last seen this week
Profile Activity
Stats
64,638
reputation
4.8m
reached
1,089
answers
20
questions
Communities
About

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

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

Badges
View all badges
25
gold badges
364
silver badges
562
bronze badges
Top tags
View all tags
8,811
Score
944
Posts
85
Posts %
1,750
Score
154
Posts
14
Posts %
1,376
Score
140
Posts
13
Posts %
1,218
Score
123
Posts
11
Posts %
1,137
Score
136
Posts
12
Posts %
1,038
Score
93
Posts
8
Posts %
Top posts
View all questions, answers, and articles
All Questions Answers Articles
Votes Newest
155
Authoritative source that <> and != are identical in performance in SQL Server
Nov 18 '16
109
MERGE a subset of the target table
Dec 18 '12
97
Retrieving n rows per group
Dec 17 '14
87
Is there any benefit to SCHEMABINDING a function beyond Halloween Protection?
Jun 4 '16
61
Unexpected scans during delete operation using WHERE IN
Jun 3 '12
60
Date range rolling sum using window functions
Sep 7 '15
60
DELETE vs TRUNCATE
Dec 13 '12
58
How do you create a view with SNAPSHOT_MATERIALIZATION in SQL Server 2017?
Oct 3 '17
57
Is there any benefit to SCHEMABINDING a function beyond Halloween Protection?
Jun 4 '16
53
Does the order of columns in a PK index matter?
Aug 21 '13
Top Meta posts
19
190
40
Let's burninate the SQL tag!
28
Why are users correcting my British English answers to the American spelling?
25
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.