Managing Statistics in SQL Server for DBAs (videos)
Category:
query-performance
, database-administration
Want to learn more about managing statistics updates in SQL Server? Watch my 27 minute presentation on managing statistics.
Updating Statistics in SQL Server: Maintenance Questions & Answers
Category:
query-performance
I’ve been asked a lot of questions about updating statistics in SQL Server over the years. And I’ve asked a lot of questions myself! Here’s a rundown of all the practical questions that I tend to get about how to maintain these in SQL Server.
Free Webcast! Updating Statistics in SQL Server: Questions and Answers
Category:
query-performance
About This Webcast
What are statistics? How often should you update them? Do you need a trace flag to make this easier? What are duplicate statistics, and do you need to drop them?
Join me for a live Hangout on Monday, April 18 at 8:30 AM Pacific / 11:30 AM Eastern to up your maintenance game!
Change Management Template for SQL Server DBAs and Developers
Category:
database-administration
, sql-server
I learned to do Change Management from some really smart people. When I first became a DBA, I worked at a small software company where changes were released with increasing frequency over the years. Our team was really great at planning and deploying changes, because we constantly worked at improving.
New SSMS Features: Click + Drag and Click + Mouse Scroll
Category:
query-performance
The best features are the ones that you use all the time. SQL Server 2016 Management Studio’s bringing improvements in navigating around execution plans.
Links and Notes from SQL Server Index Formulas, Huntington Beach
Category:
indexing
I gave a day long session, “SQL Server Index Formulas, Problems and Solutions” in Huntington Beach, CA on April 1. The class was a great group of students, and we had a lively discussion and lots of questions.
Here’s a topic we diagrammed in class, as well as links to extra resources.
Can I Force A Hinted Plan with Query Store in SQL Server 2016?
Category:
query-performance
SQL Server 2016’s Query Store feature promises to be better than Plan Guides ever were. The Query Store lets you track query performance, collect execution plans, and force a specific plan if you notice that a query is sometimes fast, and sometimes slow.