Script Download: CheckIncorrectEventSpecification.zip http://gallery.technet.microsoft.com/How-to-detect-system-40857284 This T-SQL script will demo how to detect system health extended event session incorrect event specification in SQL Server 2012. Every instance of SQL Server has a default extended...

Script Download: CheckStaleStatics.zip http://gallery.technet.microsoft.com/How-to-check-SQL-Server-4fefea34 This T-SQL script will check SQL Server stale statistics that may cause performance issues. Some people asked how to find stale statistics for these statistics may cause performance issues...

Script Download: 26816.zip http://gallery.technet.microsoft.com/How-to-change-the-time-83ea0f17 This VBScript sample shows how to change the Internet Time Synchronization interval. Windows includes internet time synchronization scheduler to synchronize your clock automatically. But the default...

Script Download: 26699.zip http://gallery.technet.microsoft.com/How-to-delete-user-d86ffd3c This PowerShell script sample shows how to delete user profiles older than a specified number of days. The computer usually used by more than one person, this often produces a large number of unique user...

Script Download: SalesPercentage.zip http://gallery.technet.microsoft.com/How-to-calculate-the-de16efde This T-SQL script will demo how to calculate the increasing percentage of sales each month in a year. As some people asked how to calculate the increasing percentage of sales each month in a...