The Top 5 performance problems I see the most and my way to fix them.

I run into a lot of performance problems in day to day work.
For a number of these problems I have some proven solutions "on the shelf".

Do you use UDF's ?
Do you have a search page on your site with multiple non mandatory options ?

I'll demonstrate the top 5 things I keep running into and what I do to fix that.
This session will be about database design and coding issues, not about raid levels etc.
Presented by Andre Kamman at SQLBits VI
Tags (no tags)
  • Downloads
    Sorry, there are no downloads available for this session.
  • SpeakerBIO

    I’m a SQL Server consultant based in the Netherlands. I’m a SQL Server MVP and I’m the co-founder and current chairman of the Dutch PASS Chapter and a member of the volunteer team for the Dutch SQL Saturday’s. I’ve done a whole lot of pure DBA work managing 100′s of servers and learning something new every day.

    These days I spend a lot of time on just a few servers containing some large databases and the better part of the day is spent with SSIS. In both roles I’ve been using Powershell a lot. I joke sometimes that I replaced myself with a powershell script when leaving the DBA role, but these days I automate so much that I have to watch myself and not actually do just that
  • Video
    The video is not available to view online.