[Script Of Oct. 28] How to get index usage information in SQL Server

Oct. 28 Script Download:   The script is available for download from https://gallery.technet.microsoft.com//How-to-get-index-usage-3b7e71cf.  You can also use  Microsoft Script Browser for Windows PowerShell ISE to download the sample with one button click from within your scripting environment.  This script will output three parts, one to get the result of server level logins and related roles, one to get the…

1

[Script Of July 9] How to get index usage information in SQL Server databases

July 9 Script Download:  The script is available for download from http://gallery.technet.microsoft.com/How-to-get-index-usage-0c34ba21.  You can also use Microsoft Script Browser for Windows PowerShell ISE to download the sample with one button click from within your scripting environment.  This PowerShell script will demo how to find all the user_seek, user_scans, user_lookups, user_updates information in the user tables from the last time SQL…

2