SQL Swiss Army Knife Series is indexed


Hello all,

By popular demand, I’m creating this post to serve as the central location for all past and future posts of the “SQL Swiss Army Knife” series, which should also make it easier to find and new updates.

Tag Script Initial Release Latest Update
Securables    #1 - Scripting Securables 26 Apr 2010 18 Nov 2016
Logins    #2.1 - Scripting Logins 21 Jun 2010 18 Mar 2013
I/O    #3 - View I/O per file 21 Oct 2010 8 Mar 2012
Filestream    #4 - Making sense of FILESTREAM containers 02 Nov 2010 -
Autogrow    #5 - Checking Autogrow times 16 Nov 2010 28 Feb 2013
DB Compression    #6 - Evaluating compression gains 03 Jan 2011 03 Dec 2013
Indexing    #7 - Adaptive Index Defrag 10 Mar 2010 Check here
Maintenance    #8 - Find a Maintenance Window 22 Mar 2011 -
VLF    #9 - Fixing VLFs 24 May 2011 20 Sep 2012
VLF    #10 - VLFs again. What’s your current status? 21 Jul 2011 19 Nov 2012
Workload    #11.1 - Locking, blocking and active transactions 03 Oct 2011 2 Dec 2016
Indexing    #12 - Index information galore! 7 Apr 2012 3 Nov 2016
Plan Cache    #13 - Exploring the plan cache – Part 1 01 Aug 2013 16 Mar 2014
Plan Cache    #13 - Exploring the plan cache – Part 2 16 Mar 2014 15 Apr 2014
Waits / Latches    #14 - Troubleshooting with Waits and Latches 13 Apr 2014 12 Apr 2017
Indexes    #15 - Handling duplicate indexes 12 Nov 2014 -
Plan Cache    #16 - Too many single use plans, now what? 30 Jul 2014 -

Hope you find it useful!

Disclaimer: I hope that the information on these pages is valuable to you. Your use of the information contained in these pages, however, is at your sole risk. All information on these pages is provided "as -is", without any warranty, whether express or implied, of its accuracy, completeness, fitness for a particular purpose, title or non-infringement, and none of the third-party products or information mentioned in the work are authored, recommended, supported or guaranteed by Ezequiel. Further, Ezequiel shall not be liable for any damages you may sustain by using this information, whether direct, indirect, special, incidental or consequential, even if it has been advised of the possibility of such damages.

Comments (4)

  1. Kin says:

    Excellent posts. Keep it up.

  2. Tara says:

    This is really useful and really kind of you to take the time out to do.

  3. Neeraj Mittal says:

    Thanks Pedro for useful collection of scripts

Skip to main content