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.

Cool Features of SQL Server 2014: Improved Cardinality Estimates

COOL FEATURES OF SQL SERVER 2014: IMPROVED CARDINALITY ESTIMATES With all the cheerleading and the steady drumbeat of new features being released to Azure, it's easy to lose track of the many cool and valuable new features released in the on-premises version of SQL Server. One of the crown jewels of SQL Server, the cardinality

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.