Posts Tagged: Indexing

Webcam

Webcast Follow-Up: Introduction to Columnstore Indexes

Posted by & filed under , , , .

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

Posted by & filed under , , , .

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

Posted by & filed under , , , .

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?

Posted by & filed under , , , .

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 […]

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

Posted by & filed under , .

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

Posted by & filed under , , , .

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 […]