Paul White

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

Rockstar Blogger SQL ServerMVP

Blog: SQLblog.com Twitter: @SQL_Kiwi


1,483 Actions

suggestions reviews revisions comments badges posts accepts all
Apr
30
 comment How to determine cause of runtime increase given two query plans with SpillToTempDb warning
A plan is not re-optimized if the estimates turn out to be wrong. Recompile can be a good option to get a plan for particular parameter values; it may also enable certain other optimizations that might be important in your case. It does add an overhead to each execution of course.
Apr
29
 comment Add Contents in a Column and make them 0
Thanks @TravisGan - there's nothing special about a CTE though, one could equally well use a derived table. Also, this is just an alternative - the SUM OVER results in a segment spool which may or may not be as efficient as your original solution :)
Apr
28
 answered Add Contents in a Column and make them 0
Apr
28
 awarded  Reviewer
Apr
28
 reviewed Leave Open mysql performance / cache configuration enigma
Apr
28
 reviewed Leave Open how to import mysql system “mysql” database
Apr
28
 reviewed Close Difference in between HAS MANY and BELONGS TO in Yii framework
Apr
28
 reviewed Leave Open Add Contents in a Column and make them 0
Apr
27
 revised How to determine cause of runtime increase given two query plans with SpillToTempDb warning
Added example
Apr
27
 reviewed Leave Open SQL Server 2008 R2 SP1 - Tempdb “Available free space” showing negative value
Apr
27
 reviewed Close Network Databases - 2
Apr
27
 reviewed Close What is advantages and disadvantages in Horizontal Scaling and Vertical Scaling?
Apr
27
 reviewed Leave Open SQL nested select (query rows after variable), running slow
Apr
27
 reviewed Leave Open Why parallel read/write is more difficult in Relational database?
Apr
27
 reviewed Close In Excel 2007-2010, how does one “attach” or “glue” or “stick” information in one cell to information in another cell?
Apr
27
 reviewed Close Database with history journaling
Apr
27
 reviewed Leave Open Fulltext stoplist replication
Apr
27
 reviewed Leave Open Total Memory capped far below available memory
Apr
27
 answered How to determine cause of runtime increase given two query plans with SpillToTempDb warning
Apr
26
 reviewed Close Network Databases
1 2 3 4 5 … 75