SQLPASS London UG on 24th Nov with Christian Bolton and Simon Sabin
Simon Sabin and I will be presenting at the next London UG tomorrow night at:
NYSE Euronext
Cannon Bridge House
1 Cousin Lane
London
EC4R 3XX
(nearest tube is Cannon Street)
We’ve got some great content to cover so if you’re around it will definitely be worth a visit. The meeting runs from 18:00-21:00. Here is the agenda:
Optimising tempdb and Temporary Object Re-use
Presented by Christian Bolton, Technical Director, Coeo, Ltd.
Microsoft Certified Architect (MCA), Master (MCM), and MVP for SQL Server
This session will cover how and why you should configure tempdb, how to troubleshoot tempdb issues, and how to detect resolve, and mitigate allocation contention issues by creating multiple data files, optimizing temporary object reuse, and using trace flag 1118.
Strategies for Generating and Optimizing SQL Server Query Plan for Maximum Performance
Presented by Simon Sabin, SQL Server Consultant
Microsoft MVP for SQL Server
This session will explore useful techniques for improving queries in Microsoft SQL Server. There are always a large number of tips and techniques applicable in narrow classes of programming tasks, each one offering a small improvement in performance. Knowing as many of these tuning tricks and techniques as possible expands your options when tuning for performance. In addition, knowing an effective process for analyzing query performance and behaviour is an essential skill for any SQL Server professional.
You can register here: http://www.sqlpass.org.uk/
Regards,
Christian Bolton - MCA: SQL Server 2005, MCM: SQL Server 2005, MVP
Technical Director
http://coeo.com - SQL Server Consulting & Managed Services