Database Administrators
Profile Activity
Meta user
60,226
reputation
25
356
540

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,020
answers
19
questions
~4.5m
people reached

Communities (1)

Top Meta Posts
19
190

Top network posts

We respect a laser-like focus on one topic.

Top tags (353)

Score 8,449
Posts 892
Posts % 86
Score 1,734
Posts 152
Score 1,335
Posts 135
Score 1,178
Posts 116
Score 1,112
Posts 134
Score 1,025
Posts 93
View all tags →

Top posts (1,039)

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
96 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 (921)

Gold

25

Rarest

Silver

356

Rarest

Bronze

540

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.