Database Administrators
Profile Activity
Meta user
Network profile
58,810
reputation
25
351
536

Paul White♦
Moderator

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

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

1,000
answers
19
questions
~4.3m
people reached

Communities (2)

Top Meta Posts
19
190

Top network posts

We respect a laser-like focus on one topic.

Top tags (350)

Score 8,350
Posts 877
Posts % 86
Score 1,712
Posts 150
Score 1,326
Posts 134
Score 1,165
Posts 115
Score 1,108
Posts 133
Score 1,019
Posts 92
View all tags →

Top posts (1,019)

All Questions Answers
Votes Newest
154 Authoritative source that <> and != are identical in performance in SQL Server Nov 18 '16
108 MERGE a subset of the target table Dec 18 '12
93 Retrieving n rows per group Dec 17 '14
86 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
59 Date range rolling sum using window functions Sep 7 '15
59 DELETE vs TRUNCATE Dec 13 '12
56 Is there any benefit to SCHEMABINDING a function beyond Halloween Protection? Jun 4 '16
56 How do you create a view with SNAPSHOT_MATERIALIZATION in SQL Server 2017? Oct 3 '17
53 Does the order of columns in a PK index matter? Aug 21 '13
View all questions and answers →

Badges (912)

Gold

25

Rarest

Silver

351

Rarest

Bronze

536

Rarest

View all badges →

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.