Changing Storage in an Always On Environment

Changing Storage in an Always On Environment

I was recently given a task to move a few multi-terabyte databases inside of an availability group from SAN A to SAN B within a 10-minute window. The good news was there was plenty of time to plan and prepare. For the purpose of this example, I will be using a very...
SQL Server Statistics and Trace Flag 2371

SQL Server Statistics and Trace Flag 2371

SQL Server Statistics are small, lightweight objects that describe the distribution of data in a SQL Server table or column. The SQL Server query optimizer uses statistics to estimate how many rows will be returned by parts of your query. This heavily influences the...