Interesting script.

2 things first:

1. If you have databases with different collation from your master database the script errors out on the name join. Amended as following:

...

Good script. Runs relatively fast.

Very useful for a single database index maintenance.

Missing index size analysis. Should skip low rowcount indexes. Should not attempt rebuild/reorganize indexes below 1000 pages as they...

Good script.

I had to change 3 things to make it work:

1. Insted of execute (@Query) corrected it to PRINT @Query, cause I wanted to check the script before running

2. Corrected...

Good Script.

Two things:

1. Why do you need to keep the script in the temp table, and not execute it right away?

2. A databases with a spaces in a...

two isues:

one: already metioned. spaces and dashes in the database names:

USE [' + '?'+ '];

OR just USE [?]; as stated.

two: temprary tables drop only if the script runs successfully. When...

Awesome script.

Runs on the 90-database server for only 14 seconds giving back wealth of info.

Two things:

1. USE [?]; - dealing with the SharePoint databases with "-" and " " in...

Great script.

2 things.

1. Proper version handling.

The version expresssion should be handled as this:

CAST((LEFT(CAST(Serverproperty('ProductVersion') AS VARCHAR(2)),

2)) AS INT)

Then it...

Hi, awesome script.

It does not take a schema name into a picture, and fails for all tables in a non-DBO schemas.

I had to corret it:

set nocount on

if exists(select name from...

Awesome script.

Had to correct database name and table name handling in multiple places. The were only 20 characters long made them all 128 characters. As well as the the database...