Decreasing data file
i have 3 databse files on my sql server 2000 - (ecc6 is installed).
one of the files has the following size - 300GB ,30GB of it are free space.
i have 2 questions - first, can i decrease/shrink the 300GB file in about 20GB on account of the 30GB free space?
second what is the recommended structure for optimized performance - in which size of the datafile - should i add another new datafile ?