It is just sys.master_files.size * 8 / 1024.

I've never heard about it and couldn't find any information about this. Can...

The only matter is Clustering with to different networks!!!!! Clustering is a solution that needs no admin operations to fail-over, what you say about DNS are useful for mirroring, logshiping,...

DNS.

You can look in wiki to get a very brief overview on it.

http://en.wikipedia.org/wiki/CNAME_record

No, but I don't see any problems here. If we used clusters we would probably use aliases as well.

I would run DBCC UPDATEUSAGE first.

Then I would look at results of sys.dm_db_index_physical_stats for this table and it's indexes.

I would also check default fill factor property, but you've done this...

I would choose DNS aliases too.

We use them without any problems for our production environment to have an opportunity to migrate databases between servers without the need of client's...

Sure, no problem.

It will be something like this (I use another script, because I track objects size changes, not db's):

declare @space_used table (database_name nvarchar(128),...

Lexa (10/4/2011)

I can change the database context but I don't like the fact that I need to have the procedure in every database. In case there is a change,...

I changed a copy of sp_spaceused and placed it in each DB. But I do not like that solution, I like that sp_spaceused can be called with any DB...

Maybe this template will be...