SQL Server 2017 introduces a new column in the sys.dm_db_file_space_usage system table. The column is modified_extent_page_count, which tells how many pages have been modified in your data file since the last full backup. What is really interesting about this is that with a little math you can calculate the percentage of your data file that has been modified.  This would be useful …

Determining how much of your data file has been modified Read more »

The Optimize for Ad Hoc Workloads server configuration can improve performance, and is extremely unlikely to negatively impact performance. This was a new feature that was introduced in SQL Server 2008, and as with many new features in SQL Server, it is not turned on by default. What Optimize for Ad Hoc Workloads Changes. Without the Optimize for Ad Hoc …

Optimize for Ad Hoc Workloads Read more »