SQL Server Settings: MAXDOP
Did you know that not configuring the MAXDOP setting in SQL Server properly could cause performance problems for your queries?
Did you know that not configuring the MAXDOP setting in SQL Server properly could cause performance problems for your queries?
When we meet with clients for an initial SQL Server Health Check, we’re sometimes asked what a SQL Server recovery model is. Once explained, the natural follow up question often is: well, then which recovery model should we use? In this post, we will address both of these important questions. What is a SQL Server…
Read more
Deadlocks in SQL Server are more than just a nuisance, they can be problematic, and even lead to data loss and inconsistencies.
“Why is my SQL Server slow?” Have you ever asked that question? Have your users? Unfortunately, that’s a commonly asked question. Fortunately, though, something can usually be done about it. Here are fourteen reasons a SQL Server instance could be underperforming. I’ve divided them into four broad categories. Slowness due to resource constraints Often the…
Read more
SQL Server is good. You install it, give it some databases to manage, and let it do it’s thing. When queries come in, it figures out how to resolve them. If it needs some statistics, it creates them. If the database is running out of space, it’ll grow the data file for you. Automatically. And…
Read more
If you’ve worked with SQL Server for very long, you’re probably familiar with the concept of indexes. Indexes can help speed up queries by allowing SQL Server to quickly locate specific data values within a table. Indexes are typically much smaller than their underlying tables so they can be searched much more efficiently. (They aren’t…
Read more
I was on my morning walk recently when I noticed this laying on the walking path. Some call it a binky. Others a pacifier or fooler. Whatever you call it, it’s an essential piece of equipment for some infants. Without it, their world falls apart. And the calamity is contagious. They, and everyone around them,…
Read more
In today’s world, we are constantly bombarded with a never-ending stream of urgent tasks and deadlines. It’s easy to get caught up in the daily grind and lose sight of the big picture. This is where inertia comes into play. And inertia can put your SQL Servers at risk. How urgency creates inertia Inertia is…
Read more
Cumulative Updates, CUs, are the way bug fixes and other improvements are released for SQL Server. These updates can make your SQL Servers more secure, they can fix performance issues, and they can make your system more reliable. But, as with any new code, they can sometimes introduce new issues. It’s not often that this…
Read more
There’s a lot of hype surrounding the next version of SQL Server. And for good reason. SQL Server 2022 is packed with some long awaited niceties, improvements, and enhancements. Here are a few of the SQL Server 2022’s new features we are excited about. Contained Availability Groups Enhancements to Availability Groups and Distributed Availability Groups…
Read more
Recent Comments