Tag : indexes - SentryOne Team Blog

Tag: indexes

Glenn Berry : Three Easy SQL Server Performance Wins

Glenn Berry : Three Easy SQL Server Performance Wins

Glenn Berry goes over three different tactics you can use to squeeze some extra performance out of SQL Server without a lot of heavy lifting.

T-SQL Tuesday # 101 – The BEST Index Analysis Solution

T-SQL Tuesday # 101 – The BEST Index Analysis Solution

Devon Leann Wilson highlights how the Index Analysis tab in SentryOne Plan Explorer helps with index creation for T-SQL Tuesday #101.

Erin Stellato : Automatic Index Management in Azure SQL Database

Erin Stellato : Automatic Index Management in Azure SQL Database

Following up on her post about automatic plan correction, Erin Stellato talks about a new feature in Azure SQL Database: Automatic Index Management.

T-SQL Tuesday #99: Missing Indexes and Index Key Order

T-SQL Tuesday #99: Missing Indexes and Index Key Order

Don't take SQL Server Missing Index recommendations at face value. They have numerous limitations. In this blog post, Andy Yun explores one of these: Index Key Order.

Finding Low Use Indexes via SentryOne

Finding Low Use Indexes via SentryOne

Andy Yun writes about one of his upcoming sessions for SQLBits and encourages everyone to take the time to find and clean up their low use indexes. For SentryOne users, Andy offers up sp_FindLowUseIndexesS1 to help you identify nonclustered indexes that are under used or not used at all.

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.