Tag : indexes - SentryOne Team Blog

Tag: indexes

Monica Rathbun : I/O Troubleshooting

Monica Rathbun : I/O Troubleshooting

Monica Rathburn (@SQLEspresso) talks about a few of the more common elements she always checks for when troubleshooting I/O problems.

Performance Myths : Clustered vs. Non-Clustered Indexes

Performance Myths : Clustered vs. Non-Clustered Indexes

Aaron Bertrand (@AaronBertrand) kicks off his "Performance Myths" series, showing a "redundant" non-clustered index outperforming the clustered index with the same key.

Statistics – What, why and how (Part 4)

Lori Edwards (@loriedwards) continues her series on SQL Server statistics, discussing some of the finer details around keeping stats up-to-date.

Paul Randal : Mitigating Index Fragmentation

Paul Randal (@PaulRandal) of SQLskills provides some thorough and helpful tips on reducing or eliminating the impact of index fragmentation in SQL Server.

Paul Randal : Unexpected Clustered Index Fragmentation

Paul Randal (@PaulRandal) of SQLskills describes several ways clustered index fragmentation can sneak up on us, and how it can impact your workload.

Paul White : Allocation Order Scans

Paul White (@SQL_Kiwi) explains various ways SQL Server makes runtime decisions about whether to use the b-tree structure or perform allocation order scans.

Table Variables in SQL Server 2014

Jason Hall (@SQLSaurus) shows us how table variables have changed in SQL Server 2014, and reminds us that it can be a great learning resource to follow up on questions where we might not immediately have the answer.

Erin Stellato : Considerations Around Column Order in Indexes and Sorts

Erin Stellato (@erinstellato) of SQLskills shows how sort operations can have a dramatic impact on plans, and what you can do about it.

Erin Stellato : Should new index columns be in the key, or included?

Erin Stellato of SQLskills compares the impact of adding additional index columns, by choosing the key or the INCLUDE list – with interesting results.