Paul White

less info
meta site favicon meta user | stack exchange network profile network profile
7,975 reputation
2457
bio website sqlblog.com/blogs/paul_white/…
location New Zealand
age 43
visits member for 2 years, 2 months
seen 8 hours ago
stats profile views 1,356

Rockstar Blogger SQL ServerMVP

Blog: SQLblog.com Twitter: @SQL_Kiwi


100 Answers

newest activity votes
32
Unexpected scans during delete operation using WHERE IN
26
Execution plan shows expensive CONVERT_IMPLICIT operation. Can I fix this with indexing or do I need to change the table?
21
Does SQL Server read all of a COALESCE function even if the first argument is not NULL?
19
DELETE vs TRUNCATE
18
SQL query for combinations without repetition
16
Forcing an index spool
16
SLEEP_TASK Wait Type in SQL Server - What does it indicate?
15
Is the SQL Server Express memory and CPU limit per instance?
14
Improve performance of query using IN()
13
MERGE a subset of the target table
12
How (and why) does TOP impact an execution plan?
12
Using EXCEPT in a recursive common table expression
11
Index fragmentation and SSD disks
11
Estimated versus actual query plan with function calls
11
What's the anatomy of a columnstore index?
11
Inclusion of ORDER BY on query that returns no rows drastically affects performance
10
Is a join optimized to a where clause at runtime?
10
Why does this cursor produce results in the incorrect order?
10
Slow deletion of records when a trigger is enabled
9
Is there any way to prevent the memo structure from being pruned?
9
Parameter Sniffing vs VARIABLES vs Recompile vs OPTIMIZE FOR UNKNOWN
9
Optimising plans with XML readers
9
Performance tuning a cascading delete with many foreign keys
9
DBCC TRACEON (652) does not disable read ahead reads
9
Index with multiple leaf levels
8
How to Optimise Query
8
Logging query text without Profiler
8
What is the actual lowest possible positive REAL number
8
Reducing Key Lookups
7
LIKE character length limitation
1 2 3 4