SQL Server Report Tuning

• Kyle Schlapkohl

  SSCrazy

  Points: 2463

  More actions

  November 27, 2007 at 10:20 am

  #177007

  I've gotten a request to tune some sql for a report. The actual SQL is pretty long so I won't bother posting it, but I was hoping that someone had a good website or ebook on advanced techniques for tuning sql in SQL Server.

  -Kyle

• SQL_ABD

  SSCertifiable

  Points: 5832

  More actions

  November 27, 2007 at 10:38 am

  #754658

  Hi Kyle,

  MSDN Virtual Lab: SQL Server 2005 SQL Query Tuning

  http://msevents.microsoft.com/CUI/WebCastEventDetails.aspx?EventID=1032286853&EventCategory=3&culture=en-US&CountryCode=US

  MSDN Webcast: Application Performance Tuning Using SQL Server Profiler 2005 (Level 200)

  http://msevents.microsoft.com/cui/webcasteventdetails.aspx?eventid=1032266508&eventcategory=5&culture=en-us&countrycode=us

  TechNet Webcast: Troubleshooting Performance Problems in Microsoft SQL Server 2005 (Level 200)

  http://msevents.microsoft.com/cui/webcasteventdetails.aspx?eventid=1032275647&eventcategory=5&culture=en-us&countrycode=us

  Check also http://msdn2.microsoft.com/en-us/sql/aa336355.aspx there are a lot of webcasts

  Regards,

  Ahmed

• Kyle Schlapkohl

  SSCrazy

  Points: 2463

  More actions

  November 27, 2007 at 10:42 am

  #754659

  Thank you much.

  -Kyle