In partnership with Microsoft we are bringing a series of advanced SQL Server training to Ireland. These are individually planned seminars aimed at level 300-400. Classes will be either led by our local SQL Server Microsoft Certified Master/Architect and MVP (Bob Duffy) or well-known industry experts and MVP speakers such as Chris Webb. This is … Continue reading SQL Masterclass Programme for 2010/2011
Tag: SQL Server
I’ve always been a big fan of analysing the SQL workload to find expensive and long duration queries, the best tool by far that I regularly use is RML utilities http://www.microsoft.com/downloads/en/details.aspx?FamilyId=7EDFA95A-A32F-440F-A3A8-5160C8DBE926&displaylang=en The toolset is just plain amazing in the wealth of details that it can give. i have yet to be on a performance tuning gig … Continue reading Using xPath and XML to Interrogate Query Plans