Warning Signs That You Have a SQL Server Backup Problem
Your backups seem fine. They weren’t failing, the last time you checked. But trouble may be lurking.
Here’s the top 5 warning signs I’ve seen that backups haven’t been thought through.
Why ROWLOCK Hints Can Make Queries Slower and Blocking Worse in SQL Server
Sometimes when SQL Server gets slow, developers and DBAs find that the problem is blocking. After lots of work to identify the query or queries which are the blockers, frequently one idea is to add ROWLOCK hints to the queries to solve the problem or to disable PAGE locks on the table. This often backfires - here’s why.
Sliding Window Table Partitioning: What to Decide Before You Automate
Before you do all the work to map out a complex sliding window table partitioning scheme for your SQL Server tables, here’s the top five questions I’d think through carefully: 1) Do You Need Table Partitioning? Some folks think they need partitioning for performance– but it really shines as a data management feature. Just because you’ve got tables with millions of rows in them doesn’t necessarily mean that partitioning will make queries faster.
How to Check if an Index Exists on a Table in SQL Server
It seems like this should be easy. But it’s not.
How to Fix Lopsided Partitioned Tables
Over the years I’ve gotten lots of emails and questions from students that start like this:
Help! My partitioned table has the wrong data in a partition! It’s lopsided. I started trying to fix it, but…
Does Query Store Regressed Queries View Catch Nasty Parameter Sniffing?
SQL Server 2016’s new Query Store feature has an option that looks for “regressed” query plans.
But does it catch “bad” parameter sniffing?
How to Find Missing Index Requests in Query Store
SQL Server 2016’s new Query Store feature makes it easier than ever for DBAs and developers to identify the most important queries to tune– and perhaps apply a quick fix by pinning an execution plan.
3 Things I Wish I Learned Earlier as a SQL Server DBA
Hindsight is everything. I was lucky to be trained by a great team of DBAs back when I first started with SQL Server. But it’s hard to know exactly what you really need to know, particularly as new tools are becoming available.
Useful Whitepapers for Planning SQL Server Migrations
Planning to move to new hardware for your SQL Server? Techniques like log shipping and database mirroring can be incredibly useful to make the change fast and painless– but you’ve got to pick the right techniques for your environment ahead of time, and know how to do a few things that aren’t in the GUI.
Here are some of my favorite whitepapers and resources to get you going.
New Class! SQL Server Index Formulas: Problems and Solutions for $99 in Huntington Beach, California
My new one day training session, “SQL Server Index Formulas: Problems and Solutions”, is now available for just $99!