Mulitple Data File Needed?

Question

Viewing 6 posts - 1 through 5 (of 5 total)

You must be logged in to reply to this topic. Login to reply

c00ler01 Ten Centuries Points: 1180 More actions · Answer 1

If the data is static (won't be modified) than why not?

If you don't query that data a lot, then move it to a cheaper storage and use current storage for something more important.

You can alter the backup process and take backup of static data once a week and backup more recent data more often.

GRE (Gethyn Ellis) SSCrazy Eights Points: 9602 More actions · Answer 2

Have a read of Tony Robinson's blog post here, it may help you answer your question:

Gethyn Elliswww.gethynellis.com

Preston-836195 Old Hand Points: 346 More actions · Answer 3

If the data is static and I add a secondary data file, won't SQL try to automatically balance the two data files? Thanks.

george sibbald SSC Guru Points: 104210 More actions · Answer 4

not if it is added as a file in a new filegroup

---------------------------------------------------------------------

Jeffrey Williams SSC Guru Points: 90303 More actions · Answer 5

Before you go off and start creating multiple files - read this:

Jeffrey Williams
“We are all faced with a series of great opportunities brilliantly disguised as impossible situations.”

― Charles R. Swindoll