Viewing 7 posts - 1 through 7 (of 7 total)
There's a lot of stuff out there recommending multiple tempdb files. Her are just a few:
http://www.microsoft.com/technet/prodtechnol/sql/2005/workingwithtempdb.mspx
http://sqlblogcasts.com/blogs/tonyrogerson/archive/2006/08/17/948.aspx
http://searchsqlserver.techtarget.com/tip/0,289483,sid87_gci1276989,00.html
http://www.sqlservercentral.com/Forums/Topic515052-146-1.aspx
http://msdn.microsoft.com/en-us/library/ms175527.aspx
An alternative view is...
August 9, 2008 at 10:49 am
I am a professional Classical musician now working as a DBA for a large multi-national. My predecessor was a Fine Art graduate - not sure how that ties in....
May 15, 2008 at 4:18 pm
It is best practice to set up all the SQL Server services to run under dedicated domain or local accounts. These should not be Local Admins in Windows but...
April 9, 2008 at 9:52 am
Oracle objects can be given Mixed Case names by using quotes when creating them e.g. "MyTableName". This seems to be frowned upon in the Oracle community - there are...
January 6, 2008 at 2:31 pm
Jeff, you have made some good points, but pardon me for thinking it comes across as just a teensy bit anti Oracle!
It is worth noting that the default...
January 6, 2008 at 2:51 am
I think I'd be tempted to turn Auto_Shrink off and then manage file size a different way. You could set the initial size and file growth with an ALTER TABLE...
October 13, 2006 at 2:05 am
Try the sp_helpdb, sp_helpfile and sp_spaceused system SPs.
May 9, 2006 at 1:17 am
Viewing 7 posts - 1 through 7 (of 7 total)