User Paul White - Database Administrators Stack Exchange

Paul White

Moderator

Member for 12 years, 8 months
Last seen this week

Twitter
GitHub
sql.kiwi
New Zealand

Summary

Badges

28

400

630

Newest

Revival

Next badge

376/500

Illuminator

Answers

View all 1,329 answers

Score Activity Newest

192

Authoritative source that <> and != are identical in performance in SQL Server

Nov 18, 2016

118

MERGE a subset of the target table

Dec 18, 2012

97

Is there any benefit to SCHEMABINDING a function beyond Halloween Protection?

Jun 4, 2016

61

DELETE vs TRUNCATE

Dec 13, 2012

61

Unexpected scans during delete operation using WHERE IN

Jun 3, 2012

Questions

View all 22 questions

Score Activity Newest Views

103

Retrieving n rows per group

Dec 17, 2014

63

Date range rolling sum using window functions

Sep 7, 2015

62

Is there any benefit to SCHEMABINDING a function beyond Halloween Protection?

Jun 4, 2016

47

Excessive sort memory grant

Dec 17, 2014

26

Logical reads different when accessing the same LOB data

May 8, 2016

Tags

View all 404 tags

sql-server

10,273

Score

1,157

posts

performance

1,814

Score

166

posts

execution-plan

1,594

Score

168

posts

query-performance

1,371

Score

140

posts

sql-server-2012

1,183

Score

142

posts

Reputation

top 0.09% this year

+30

SQL: How to look within each "cluster" value in one column and return those that ONLY have one specific value in another column

+10

Does SQL Server use multiversion concurrency control (MVCC)?

+10

Latin1_General_BIN performance impact when changing the database default collation

+10

Why sql server prefer index scan over the seek?

Badges

View all badges

28

gold badges

Sheriff

Aug 10, 2016
Marshal

Dec 26, 2014
Copy Editor

Dec 10, 2014

400

silver badges

execution-plan

Oct 25, 2017
Epic

Dec 22, 2016
sql-server-2016

Jul 5, 2022

630

bronze badges

database-internals

Jun 29, 2017
isolation-level

Aug 9, 2021
parallelism

Mar 7, 2021

Accounts

Database Administrators ♦

82.9k
28
400
630

Meta Stack Exchange

718
4
14

230
4
16

Active bounties (0)

Active Offered Earned

This user has no active bounties

Votes cast

20,745

upvotes

11,992

downvotes

14,587

question votes

18,150

answer votes

10

this month

6

this week

6

today