Skip to main content

Posts

Showing posts from October, 2011

SQLBits Friday and Saturday

By David PostlethwaiteThe last two days of SQL Bits provide opportunities to hear short 50 minutes presentations from experts
on a diverse range of SQL related subjects.Friday I stuck to a DBA theme.
I’ve heard Simon Sabin talk on performance tuning at the last SQL bits but there’s no harm hearing it
again there’s always something you missed last time. He certainly hates scalar functions.
David Morrison went through query plan operators which again although you’ve heard them all before,
you pick up something new.
Both covered similar ground and the overall view is that there are many ways to write a query to
achieve the same output, exactly what code you finally use will depend on many factors like the amount
of data, the cardinality of the data ,the available indexes, new indexes . You’ve just got to keep looking
at the query plan, understand it and change the query until you get acceptable results.
And finally Klaus Aschenbrenner on SQL 2008 troubleshooting looking at all those DMVs and how t…