Posts Tagged: Performance Tuning

Webcam

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

Posted by & filed under , , , .

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?

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

Unicorn Create Index

Index Analysis March Update

Posted by & filed under , , .

In yesterdays duplicate index blog post, I mentioned that there would be an update to the index analysis stored procedure today.  Without further ado, you can jump to the bottom and download it.  There are a few things I’ve fixed from comments from people using the script and then major change is the addition of […]