Tag Archive for Performance Tuning

pass plan cache whisperer

PASS Summit Session Follow-up: The Plan Cache Whisperer

I’ve wrapped up my session at my first session at this year’s PASS Summit.  My session this Thursday was The Plan Cache Whisperer: Performance Tuning SQL Server [DBA-313]. The session appears to have gone really well and the content has been uploaded to the PASS Summit for download.  To provide access to the materials now, the slide deck…

Webcam

Webcast Follow-Up: Necessary Evils, Building Optimized CRUD Procedures

Earlier today, I presented a session for Pragmatic Works Training on the T’s titled Necessary Evils, Building Optimized CRUD Procedures.  In the session, I discussed some of the issues surrounding the use of CRUD-based stored procedures and the applications that use them.  Providing a number of tips for identifying performance issues and resolving them. The abstract…

Webcam

Webcast Follow-Up: How Do Non-Clustered Indexes Improve Performance?

Earlier this month, I presented a session for Pragmatic Works Training on the T’s on the selecting the clustered index for a table in a SQL Server database.  In the session, titled How Do Non-Clustered Indexes Improve Performance?, in this session I discussed the patterns around non-clustered indexes and why you might choose which patterns for…

Webcam

Webcast Follow-Up: Choosing Your Clustered Index

Earlier this month, I presented a session for Pragmatic Works Training on the T’s on the selecting the clustered index for a table in a SQL Server database.  In the session, titled Choosing Your Clustered Index, in this session I discussed the patterns around choosing clustered indexes and why you might choose one pattern over another.…

nose picking

Can You Dig It? – Find All Plans for a Database

With today’s SQL Server instances, there easily be anywhere from a dozen to a hundred databases on a single SQL Server instance.  In fact, on my laptop, I currently have almost two dozen databases and these are just from working on projects. Setup a SharePoint server and add a few sites and you’ll easily see…

FargoSign

Presentation Materials “Discovering the Plan Cache” #SQLSat175

I’m a little late getting the information from my Fargo SQL Saturday session posted, titled “Discovering the Plan Cache“.  But it’s better a little late that never. Even though it was the end of the day, the session had great turnout and lots of good questions.  Reviewing my session evals, I saw quite a few high…

portillos hot dog

Presentation Materials “Discovering the Plan Cache” #SQLSat211

Just got done with my morning session, titled “Discovering the Plan Cache“, for SQL Saturday Chicago #211 and wanted to get out my session deck and scripts for people.  The session got pretty high marks from the attendees and people seemed to get a lot of good information and humor out of it.  Probably the best…

cheese block

Presentation Materials “Discovering the Plan Cache” #SQLSat206

This past weekend, I took a quick trek into the land of beer and cheese for the second annual Madison SQL Saturday event.  The event was a great success, but  can you expect less when one of the organizers is wielding a light saber.  For a change this time, instead of bringing Sarah Strate (Blog |…