ICYMI - Troubleshooting SQL Performance Issues, Missing Indexes, and DROP and TRUNCATE TABLE
Troubleshooting SQL Server CPU Performance Issues
Don’t just blindly create those "missing" indexes!
Our own Aaron Bertrand ( b | t ) discusses ways to get better and more balanced information used in decisions about creating new indexes than offered as suggestions by native SQL Server tools.
The Myth that DROP and TRUNCATE TABLE are Non-Logged
Paul Randal ( b | t ) of SQLskills.com refutes the age-old myth that TRUNCATE TABLE and DROP are not logged operations. I love the full T-SQL reproduction of the issue so that you can see the internals in action.Troubleshooting SQL Server CPU Performance Issues
Read more SQL Sentry happenings in our monthly eNews at: https://sentryone.com/community
Kevin (@kekline) serves as Principal Program Manager at SentryOne. He is a founder and former president of PASS and the author of popular IT books like SQL in a Nutshell. Kevin is a renowned database expert, software industry veteran, Microsoft SQL Server MVP, and long-time blogger at SentryOne. As a noted leader in the SQL Server community, Kevin blogs about Microsoft Data Platform features and best practices, SQL Server trends, and professional development for data professionals.