It is a good series of articles and the comment wasn't intended to be negative, I was just pointing out the possibility of settin up a VM cluster without creating...

Do you actually need the NAS element? I know you can create the shared storage on VM Server just by tweaking the properties of the storage so it can be...

The technology will improve but the appetite to store, retrieve and report on information will always stay a step ahead as the appetite cannot be fulfilled, it is limitless. Also...

Clustered index leaf level is the data.

Transportable filegroups would be nice.

🙂 it is almost Christmas. 🙂

This has always seemed like a glaring omission to me, since the sort of environments that need Enterprise Edition and partitioning, are very likely to also have a very minimal...

Yes Enterprise Editon and it has to be ONLINE, apologies for omitting that.

Thanks for the reply but my initial statement stands. There is no benefit in partitioning SQL Server 2005 indexes when it comes to maintaining these indexes as you cannot rebuild...

whats hardware is it running on?

If I create a database in full recovery mode in SQL Server 2008, then add 1000 records, then 500 more, and then do a log backup, can I recover to...

you can call

wmic volume get caption,capacity,freespace

to get the freespace on all drives including mount points.

Make this call from xp_cmdshell and place the results into a table if you want...

Interesting article.

Just a note - xp_fixeddrives doesn't return any space info on mount points in the filesystem below the drive letters. If you have database file in such locations thats...

As well as the degree of fragmentation you should consider the sort of queries run against the tables. If these result in mostly index seeks with no or almost no...

The thing that caught me on this is that SQL Server does not require any secondary data files and so it could be considered that .ndf is not a "default"...

Whats your views on the cost?