Erin Stellato (@erinstellato) talks about the implications of holding onto data, beyond its reasonable lifetime, in monolithic, single-partition tables.
Continue Reading »Jul 302013
Jul 262013
SQL Sentry's Aaron Bertrand (@AaronBertrand) reflects on the presentation he gave during the PASS Performance VC Summer Performance Palooza 2013 on June 27th, including a wealth of responses to Q & A.
Continue Reading »Jul 242013
Paul White (@SQL_Kiwi) talks about two scenarios where the order of columns in your query can affect query optimization.
Continue Reading »Jul 182013
Paul White (@SQL_kiwi) talks about a regression in the optimizer's handling of aggregates against partitioned tables when moving from SQL Server 2005 to SQL Server 2008+.
Continue Reading »Jul 112013
Joe Sack (@josephsack) of SQLskills.com shows us that we might not always be able to make an accurate correlation between wait statistics and observer overhead, depending on the method being used to observe a system.
Continue Reading »Jul 082013
Paul White (@SQL_Kiwi) continues his discussion about optimization and how recognizing transformations can help you make better decisions about potential query re-writes.
Continue Reading »Jul 022013
Erin Stellato (@erinstellato) of SQLskills.com dives into what sp_updatestats is really doing, and why you should avoid relying on it for perpetual maintenance on your SQL Servers.
Continue Reading »