The Scary DBA
Archives: March 2011
SQL Saturday #67 Wrap-up
Just… Wow. What an event. What a great group of people. I’m just so lucky to be involved with fantastic individuals like these. Thanks for having me out to play everyone, I really appreciated it.
SQL Saturday #67 started for me with my second FreeCon (follow the link for… Read more
0 comments, 140 reads
Posted in The Scary DBA on 28 March 2011
Communication
It sure seems like there’s a lot of miscommunication between developers and database specialists. In fact, the communication can become so poor that outright hostility between the groups is common. At the end of the day we are all working towards a common goal, to add value to whatever organization… Read more
2 comments, 467 reads
Posted in The Scary DBA on 21 March 2011
Where does slow performance come from?
I have my opinions and experience, and I’ve no doubt you have yours. Paul Randal (blog|twitter) has put up another one of his interesting surveys to try to collect our opinions and our experience. You should run right over to here and vote immediately.
Now… Read more
1 comments, 132 reads
Posted in The Scary DBA on 17 March 2011
ANSI Connection Settings
It’s reasonably well known that you can get different execution plans if you change the ANSI connection settings. But the question comes up, fairly often, how do you know what the settings are. It’s actually surprisingly simple. They’re stored right inside the execution plan, but they’re in one of the… Read more
3 comments, 448 reads
Posted in The Scary DBA on 14 March 2011
Execution Plan Stability
I’ve talked before about one of the primary things that the Query Optimizer team at Microsoft tries to avoid, regressions. Basically, they want a plan that worked well in SQL Server 2005 to work well in SQL Server 2008 R2. What’s more, they want everything to work well between… Read more
2 comments, 152 reads
Posted in The Scary DBA on 7 March 2011



Subscribe to this blog