Hello Mohit,

thank you.

I'm not quite sure what you mean (I'm probably too new to the topic): I was looking for an option to use V.2000 of the SQL server...

I understand. Thanks a lot, Gail!

Hi, just got an update: It's 14 filegroups with one file each. They are all on the same SAN/LUN based on several physical drives. By the way: Does it make...

Its about 25 Files separating a few big fact tables from smaller dimension tables + separating data from indexes.

I understand, thank you. Then asking the other way round: If there is an existing system (having e.g. tables and indexes in different filegroups and dimension tables separated from fact-tables)...

Hi,

this database is for a Data Warehouse system typically involving a lot of "bulk io" and queries of that type. Idea is that more then one file per filegroup could...

Thank you, Gail!

To clarify: Does "have no more that 1/2 the number of files as you have CPUs total" refer to "per FILEGROUP" or to "no more then 1/2 the...

Thank you - but this is supposted to work as an automated script as this job should run on it's own as part of an archiving job (to which I...

Thanks a lot Markus!

JM