Set temporal table retention, check history cleanup settings, and choose a history index that lets old versions leave safely.
SQL SERVER – Introduction to Log Space Usage DMV – sys.dm_db_log_space_usage
DBAs wanted to back up the log based on log space used, not on a schedule. Here is how the SQL Server 2017 DMV sys.dm_db_log_space_usage helps.
SQL SERVER- New DMF in SQL Server 2017 – sys.dm_os_file_exists. A Replacement of xp_fileexist
SQL Server 2017 adds a new DMF, sys.dm_os_file_exists, a replacement of xp_fileexist that suits both Windows and Linux. Here is how to use it.
SQL Authority News – SQL Server 2017 and Automatic Tuning
SQL Server 2017 becomes generally available on Oct 2. Here are my thoughts on rapid releases and on Automatic Tuning, the feature I most want to try.
SQL SERVER – New DMV in SQL Server 2017 – sys.dm_os_enumerate_fixed_drives. A Replacement of xp_fixeddrives
SQL Server 2017 adds sys.dm_os_enumerate_fixed_drives, a new DMV that shows free space on each drive and replaces xp_fixeddrives. Here is the query I use.
Modeling Friends and Followers With SQL Server Graph Tables
Build SQL Server graph tables for follows, mutual connections and friends of friends, then use shortest paths and compare a junction table.