Kinda neat idea and simple approach.

However, it seems pointless to include columns that aren't able to be null in the first place. Here's a quick updated version.

DECLARE @TableName VARCHAR(200)

SET...

I work on a data warehouse that uses a technique like this for dates only (not the time portion). This was in the design from back when SQL Server didn't...

Here's a link to a similar query I published in June.

http://www.sqlservercentral.com/scripts/99716/[/url]

For contrast, that one was attempting to stay as close to the original sp_spaceused results as possible, whereas this new...

I like the organization you put into this.

I'm glad you like it, mauriciorpp, and thanks for the publicity. Please note that while I mentioned the "Server-level" script in the description, SSC isn't publishing that one until tomorrow.

That is a nice little query. Here's my quick re-write to show all databases and track percent growth since the first backup on record.

SELECT

'database_name' = mdbus.database_name

,'backup_start' ...

I really like the multi-column copy/paste trick you came up with in the results. Also, the tempdb integration is very simple.

I have a similar script that I have begun modifying...

This is a nice script. I have a similar one I have been using and I made some improvements based on what you did. Thanks for sharing.

One thing to note:...

Good one Cadavre! Your derived tables got me thinking about it some more. I took out that big constant scan with all the...

I'm not sure why I got carried away with this, but I modified your script as shown below. It should provide the same results. The main changes were to take...

Thanks for catching that opc.three! I didn't realize that I copied in the wrong version. That one didn't multiply the variable by -1 so it required that a negative number...

I have had this problem before when I attempted to use a maintenance plan cleanup task to delete perfmon files as they got old. When it didn't work I scripted...