Tag: Indexing

Webcam

Webcast Follow-Up: 5 SQL Server Indexing Myths

Similar to yesterday’s post, I have a follow-up for another Pragmatic Works Training on the T’s session that I delivered last month.  This was is titled 5 SQL Server Indexing Myths.  In the session, I discussed discussed five common indexing myths that I’ve come across over the years. The abstract for the sessions is: There are…

Webcam

Webcast Follow-Up: Introduction to Columnstore Indexes

Similar to yesterday’s post, I have a follow-up for another Pragmatic Works Training on the T’s session that I delivered last month.  This was is titled Introduction to Columnstore Indexes.  In the session, I discussed columnstore indexes and the value that they provide in SQL Server, both in 2012 and 2014. The abstract for the sessions…

Webcam

Webcast Follow-Up: Introduction to Clustered Indexes and Heaps

Last month, I presented a session for Pragmatic Works Training on the T’s titled Introduction to Clustered Indexes and Heaps.  I’d meant to get the Q&A and session materials posted earlier, but somehow getting this post out got a bit “corrupted”, but at least it is finally coming out.  In the session, I discussed the differences between…

Webcam

Webcast Follow-Up: The Flavors of Non-Clustered Indexes

Earlier today, I presented a session for Pragmatic Works Training on the T’s titled The Flavors of Non-Clustered Indexes.  In the session, I discussed non-clustered indexes and some of the options available for building them.  It’s a topic I talk about often but is always an important one. The abstract for the sessions is: A non-clustered…

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…

Q&A From “5 Ways to Improve Performance through Indexing”

A few weeks back spoke at a Pragmatic Works Training on the T’s on indexing that was titled 5 Ways to Improve Performance through Indexing. The abstract for the sessions is: Sometimes the hardest performance issues in your environment have simple solutions. One of these simple solutions is through properly indexing the database. In this session, we’ll look…

Webcam

Webcast Presentation Materials: 5 Ways to Improve Performance through Indexing

This past Tuesday, I delivered a presentation for Pragmatic Works Training on the T’s. The session I delivered was 5 Ways to Improve Performance through Indexing. The abstract for the sessions is: Sometimes the hardest performance issues in your environment have simple solutions. One of these simple solutions is through properly indexing the database. In this…

Unicorn Create Index

My TechEd Presentation: Indexing Fundamentals for Microsoft SQL Server

This past Monday, I presented at TechEd North America for the first time.  The session presented was Indexing Fundamentals for Microsoft SQL Server.  Indexing is such a huge topic, that it was hard to boil down the fundamentals to a 75-minute presentation, but based on responses I think the resulting session was pretty good. If…