I suppose you could always trick SQL Server by putting tempdb on a RAM drive?
*looks around*
In fact, that idea seems less far-fetched than I had thought:
http://www.google.com/search?q=ram+drive+tempdb — I skimmed over some of those hits and they all seem like worthwhile reads.
Quote:
Originally Posted by Banana
Thanks, BTW, for sharing your input with your external drive.
|
Well, my situation is somewhat similar. The main applications I use are Visual Studio and SQL Server Management Studio. The locally installed SQL Server is only for testing, so is only sample data on it, but I nonetheless easily run into I/O issues — it is clearly by far the greatest bottleneck.