SQL Sentry's Aaron Bertrand (@AaronBertrand) goes into a little more detail about what happens to metadata when you use schema transfers behind the scenes.
Continue Reading »Apr 302013
Apr 252013
Aaron Bertrand (@AaronBertrand) discusses some obstacles he recently encountered when configuring an Availability Groups lab environment and how some assistance from the community helped him isolate and solve the issues.
Continue Reading »Apr 242013
Aaron Bertrand (@AaronBertrand) of SQL Sentry discusses a couple of advantages and a hefty list of limitations with filtered indexes in SQL Server 2008 and above, with links to no less than 36 Connect items!
Continue Reading »Apr 192013
SQLskills' Joe Sack (@josephsack) walks us through an interesting scenario where we might blame a query performance issue on parameter sniffing or bad statistics, when it actually turns out that a check constraint is the best solution to keep the optimizer honest.
Continue Reading »Apr 152013
Jonathan Kehayias (@SQLPoolBoy) demonstrates column-side implicit conversions and the impact they can have on a workload. He concludes that you can only throw hardware at this problem for so long; a design or code change will be necessary to solve the performance issue long-term.
Continue Reading »Apr 102013
Erin Stellato (@erinstellato) of SQLskills.com tells us about statistics, sample size and the impact different choices can have on duration and subsequent queries.
Continue Reading »Apr 042013
Paul White (@SQL_Kiwi) makes some great points about limitations in SQL Server's optimizer, and things you need to watch out for, when it comes to filtered indexes.
Continue Reading »
1
2