Paul White

less info
meta site favicon meta user | stack exchange network profile network profile
7,865 reputation
2357
bio website sqlblog.com/blogs/paul_white/…
location New Zealand
age 43
visits member for 2 years, 2 months
seen May 14 at 21:59
stats profile views 1,332

Rockstar Blogger SQL ServerMVP

Blog: SQLblog.com Twitter: @SQL_Kiwi


99 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
Using EXCEPT in a recursive common table expression
11
Index fragmentation and SSD disks
11
Estimated versus actual query plan with function calls
11
How (and why) does TOP impact an execution plan?
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
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
7
32-bit ODBC driver on 64-bit SQL Server
1 2 3 4