What Are You Going to Do About SQL Server 2008?

With support ending soon, Brent Ozar wonders what all the companies still running SQL Server 2008 are planning to do with those instances.

Scripting Out a SQL Server instance (Agent jobs, XEvents, Triggers and the like)

In order for a database system to work, you often need to provide programmable server objects. I’ve written very few databases that didn’t include agent jobs and triggers, or that didn’t require XEvents for diagnostics. 

Oracle RAC vs. SQL Server AG

As I have seen the benefit for having a post on Oracle database vs. SQL Server architecture, let’s move onto the next frontier- High Availability…or what people think is high availability architecture in the two platforms.

Cleaning up tempdb

The Extra Table

What is the Best Value for Fill Factor in SQL Server

Learn about how selecting a SQL Server index fill factor can impact storage and performance. Check out the included scripts to help give you better insight.

Parallel DBCC CheckDB

Cost threshold for parallelism

Max Degree of Parallelism

Your SQL Servers Are Misconfigured...

It's probably not your fault, but relying on the defaults of a SQL Server installation might be impacting the performance of your instance.