Paul White

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

Rockstar Blogger SQL ServerMVP

Blog: SQLblog.com Twitter: @SQL_Kiwi


103 Answers

newest activity votes
33
Unexpected scans during delete operation using WHERE IN
jun 3 '12 at 9:51
27
Execution plan shows expensive CONVERT_IMPLICIT operation. Can I fix this with indexing or do I need to change the table?
nov 25 at 12:44
21
Does SQL Server read all of a COALESCE function even if the first argument is not NULL?
sep 19 '11 at 18:43
20
DELETE vs TRUNCATE
dec 13 at 11:02
18
SQL query for combinations without repetition
dec 2 at 7:11
16
Forcing an index spool
dec 11 at 15:53
16
SLEEP_TASK Wait Type in SQL Server - What does it indicate?
jan 28 '12 at 0:06
15
Is the SQL Server Express memory and CPU limit per instance?
dec 3 at 17:06
14
Improve performance of query using IN()
dec 18 at 20:41
14
MERGE a subset of the target table
dec 18 at 9:20
12
How (and why) does TOP impact an execution plan?
sep 25 at 7:10
12
Using EXCEPT in a recursive common table expression
dec 23 '11 at 1:34
11
Is there any way to prevent the memo structure from being pruned?
may 21 at 20:37
11
Index fragmentation and SSD disks
dec 20 at 7:54
11
Estimated versus actual query plan with function calls
dec 4 at 5:41
11
What's the anatomy of a columnstore index?
jan 11 '12 at 16:40
11
Inclusion of ORDER BY on query that returns no rows drastically affects performance
jan 5 '12 at 17:42
10
Is a join optimized to a where clause at runtime?
feb 28 at 2:02
10
Parameter Sniffing vs VARIABLES vs Recompile vs OPTIMIZE FOR UNKNOWN
jan 29 at 11:32
10
Optimising plans with XML readers
dec 22 at 6:40
10
Why does this cursor produce results in the incorrect order?
sep 21 at 23:33
10
Slow deletion of records when a trigger is enabled
jul 12 '12 at 4:58
9
Performance tuning a cascading delete with many foreign keys
dec 14 at 19:11
9
DBCC TRACEON (652) does not disable read ahead reads
nov 29 at 13:12
9
Index with multiple leaf levels
oct 31 at 5:55
8
What Problems Does an Eager Spool Indicate
may 28 at 4:40
8
Why won't SQL Server optimize the UNIONs?
dec 11 at 18:31
8
How to Optimise Query
sep 6 at 2:05
8
Logging query text without Profiler
dec 6 at 22:34
8
Why is this query not using my nonclustered index, and how can I make it?
sep 5 at 13:43
1 2 3 4