Simpler if you change the datatype in the temp table ;-).

CREATE TABLE #dbs

(

DBNAME sysname

, DBID INT

, [Total Size in MB] DECIMAL(18,2)

, [Available Space in MB] DECIMAL(18,2)

, DriveLetter CHAR(1)

)

INSERT...

Even with all that crap you have nothing against the fk points (which is what the question is ALL about)?

So I guess that means it's a great...

1 of those numbers need to be a decimal.

int / int * int = int.

Try with 100.0 (yes 100 dot 0).

You're that short on space that a few KB matters??

That's a whole other problem ;-).

As previously mentionned use / 128.0. That way it auto-casts to decimal.

AFAIK, those can't really be tuned other than changing the cursor type & locations and "batch" size.

However the query itself that fills those datasets is where you can make a...

@Cadavre We stopped wasting our time proving wrong JC (not short for Jesus-Christ).

However this is a great proof that theory is not real life and that performance is still...

Quite possibly.

What's the definition of the columns on that index?

Are those columns getting lots of updates?

Try LEFT(middlename + '.', 1) instead.

That'll work depending on your concat_null_yields_null setting.

SELECT ID FROM dbo.Table

GROUP BY ID

HAVING COUNT(DISTINCT DepartmentId) > 1

SELECT ID FROM dbo.Table GROUP BY ID HAVING COUNT(*) > 1

The real purpuse of the script I gave you was to do forecasting and growth planning.

Maybe when you're ready ;-).

derekr 43208 (10/25/2011)

Ninja's_RGR'us (10/25/2011)

I can't see what's on your c drive. You need to upload it here.

If you want...

I can't see what's on your c drive. You need to upload it here.

If you want you can copy...

Excluding the last 2 columns that are used to link the backup sequence together, what's unclear??

Fine, what does this do??

SELECT

...