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.

Autogrow files

The Pesky Windows Power Plan Oh My

The below script will build a csv file for import of the servers Power Plan Setting.

Solving the Target Principal Name is Incorrect

One small point to note when we receive the below error while connecting SQL server: The target principal name is incorrect. Cannot generate sspi context

How to Programmatically Identify When Your SQL Server Was Last Started

Greg Larsen shows you a quick trick to programmatically script a way to identify when SQL Server was last started.

SQL Server Services