Wanted to give a heads-up about some of the sessions we're presenting at PASS Summit, some great pre-conference seminars, and a contest you'll really want to consider entering in June and July.
Jonathan Kehayias (@SQLPoolBoy) of SQLskills.com takes a look at snapshot performance, with some surprising observations about what happens if you have more than one concurrent snapshot.
Aaron Bertrand (@AaronBertrand) talks about a subtle way that ad hoc queries can interfere with SQL Server performance by taking up more space in the plan cache than they really need.
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.
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!
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.
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.
Erin Stellato (@erinstellato) of SQLskills.com tells us about statistics, sample size and the impact different choices can have on duration and subsequent queries.
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.
Microsoft announced today that their next two major releases, each of which contains a major performance-related feature, will follow a naming strategy similar to the 2008 -> 2008 R2 story. Read on for more…