Proportional Fill

Check FileSize and LogUsage for all DBs

This script provide informations about SQL DBs files size and Log usage.
This little script use os_performance_counters

RE: PRIMARY KEY/NOCHECK

Michael,just out of curiosity, can you post the text from BOL. All I have found in the explanations for ALTER TABLE is:When a new PRIMARY KEY or UNIQUE constraint is added to an existing column, the data in the column(s) must be unique. If duplicate values are found, the ALTER TABLE statement fails. The WITH […]

RE: Without dynamic SQL, Top X Query

That's good news, Calvin.I'll try it in the next build of the product.