Why Table Partitioning Does Not Speed Up Query Performance (video)
Category:
query-performance
Learn why SQL Server’s table partitioning feature doesn’t make your queries faster– and may even make them slower.
Required Testing for Installing SQL Server Cumulative Updates and Service Packs
Category:
database-administration
Microsoft recently updated their policies and recommendations for installing cumulative updates.
What is the Difference between a Junior and Senior DBA?
I got a great question from a student recently:
In your opinion, where is the distinction between Junior DBA and Senior DBA? I’ve always worked on small teams, so sometimes it’s hard to tell where I fit.
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.