Thanks again.  Yes, I realize that.  I'm not trying to manipulate just one table/index,etc.  I want to balance out the entire database's data files.  You are correct that new data going...

Thank you for the prompt response!  I think you're talking about using filegroups, but I'm talking about using multiple data files, not groups at all.

Anyone have an idea on how...

Can any of you suggest how I can go about redistributing the existing data from one file evenly across multiple files?  We have a 30 gig plus file that we're...

Thanks!  I was asking for info regarding how do you get the size to stick after a reboot.  I found it here...

http://www.extremeexperts.com/SQL/Articles/AutoGrowth.aspx

The section "Tale of tempdb" give a perfect...

I see mention of setting the initial size of tempDB.  How do you tell SQL Server to set tempdb at a particular size on startup?  Is it by default created...

I searched for answers on this one to no avail, but I just figured it out.  In my case it was a lack of space.  Once there was enough space,...

I read the MS write up on that proc incorrectly...you were right! sp_revokedbaccess worked. Thanks a million.

Perfect...thank you.