2022 Developer Survey is open! Take survey.
Database Administrators
Sponsored by
Sponsored logo
user avatar
user avatar
user avatar
Paul White
Moderator
  • Member for 11 years, 2 months
  • Last seen this week
Profile Activity
Stats
69,239
reputation
5.0m
reached
1,147
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
372
silver badges
578
bronze badges
Top tags
View all tags
9,224
Score
997
Posts
85
Posts %
1,790
Score
157
Posts
13
Posts %
1,427
Score
145
Posts
12
Posts %
1,274
Score
128
Posts
11
Posts %
1,146
Score
137
Posts
12
Posts %
1,046
Score
95
Posts
8
Posts %
Top posts
View all questions and answers
All Questions Answers
Score Newest
answer
173
Authoritative source that <> and != are identical in performance in SQL Server
Nov 18, 2016
answer
110
MERGE a subset of the target table
Dec 18, 2012
question
98
Retrieving n rows per group
Dec 17, 2014
answer
91
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
question
60
Date range rolling sum using window functions
Sep 7, 2015
question
58
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
53
Does the order of columns in a PK index matter?
Aug 21, 2013
Top Meta posts
19
195
40
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.