Bill Graziano, a Microsoft SQL Server MVP, will be giving this presentation. Please come join us to hear Bill speak!
Topic: Understanding the Procedure Cache: Writing Efficient, Reusable Queries
Summary: This session is designed to answer the following questions:
· How much memory is SQL Server using for data and how much for query plans?
· Are stored procedures faster than dynamic SQL?
· What are the benefits of a compiled query plan?
· When should I turn on forced parameterization?
· What is the most efficient way to write SQL for reports that might have a completely different WHERE clause each time?
· Why is my stored procedure fast sometimes but not always?
· How are the various LINQ technologies (LINQ to SQL, LINQ to Entities) processed by SQL Server?
· How are other object-relational mapping tools processed by SQL Server?
About the Speaker:
Bill Graziano is a SQL Server consultant and is recognized by Microsoft as a SQL Server MVP. The MVP certification is earned through technically relevant community contributions. Bill started and still runs SQLTeam.com, one of the leading sites for SQL Server professionals. Bill has written over 100 articles on SQL Server for the site. Over 25,000 people subscribe to the site's newsletter. He served as the President of the Kansas City SQL Server Users group for two years. This led him to volunteer of the Professional Association for SQL Server (PASS). He served for two years as a volunteer developing the Summit educational program. He was elected to the Board of Directors at the 2006 Summit. He currently serves on the Executive Committtee as the Vice President of Marketing. Bill wrote and released the popular performance utility ClearTrace. This utility is used to aggregate performance data from trace files to make performance tuning more efficient. Bill is a regular presenter in Kansas City and internationally. He speaks each year at the Kansas City SQL Server Users Group. He presents at the North American PASS Summit and delivered the highest rated session in 2005. He has presented at SqlTeach in both Vancouver and Montreal. He has presented at the European PASS Summit. He has spoken to user groups in Wichita, Topeka and St. Louis. In his spare time, Bill is a SQL Server consultant. He focuses on performance tuning, database monitoring, database maintenance and scalability issues. Sponsors:
TEK Systems - Food & Drink
Securities America, Inc. - Facilities