SQLSaturday #337 Portland–Randy Knight, Ben Miller, Mike Tutor
Randy Knight and Ben Miller, SSG Principal Consultants and Microsoft Certified Masters, and Mike Tutor, Senior Consultant, presented at the Portland SQLSaturday Event on Nov. 1.
Randy’s topic: Locks, Blocks, and Deadlocks Oh My!
Managing concurrency is one of the most challenging aspects of working with any enterprise DBMS. There is much confusion out there about locking, blocking, and deadlocks. In this demo heavy session we will clear up the confusion.
Ben’s topic: TSQL Best Practices for SQL Engine Kindness
This session will take a look at things that you should regularly know and use when coding TSQL. How can you be really friendly to SQL? The items covered will show you things that will help ensure that your code is readable, efficient and maintainable. We will look at query semantics, datatypes, things to avoid as well as how to be super friendly to the SQL Engine and allow things to work well.
Mike’s topic: Simple things you can do to make the Query Optimizer more efficient!
On occasion as DBAs we have need to disable the foreign keys and constraints on one or more tables. Guess what, SQL Server no longer trusts those constraints when you re-enable them. What does that mean? In this discussion, we’ll talk about what the impact is to your queries when you have non-trusted constraints, how to find the non-trusted constraints, and how to soothe SQL Servers mistrusting heart so that it will trust your constraints again! How about your foreign keys? Are you using implicit conversions? Are your stats ‘stale’? All of these things effect how the query optimizer works and can negatively affect you query performance.
Get full event details on the Portland SQLSaturday event page.
Date(s) - 11/01/2014
8:30 AM - 5:30 PM
Portland Jewish Academy
Categories No Categories