Ralf Eisenreich

USE [master]
GO
ALTER DATABASE tempdb
MODIFY FILE(NAME='tempdev', FILENAME='E:\Microsoft SQL Server\MSSQL.1\MSSQL\Data\tempdb.mdf')
GO
ALTER DATABASE tempdb
MODIFY FILE(NAME='templog', FILENAME='F:\Microsoft SQL Server\MSSQL.1\MSSQL\Log\templog.ldf')
GO

After this: Restart SQL Server.

Effect: Moving the TempDB to a more powerful storage will increase performance, especially for OLTP systems.

At http://mb-configurator.net you can find an Accessories Configurator for current and older MB models.

Genuine accessories from Mercedes-Benz offer individuality, design, functionality and variety.
Cutting-edge telematics solutions, secure carrier systems, distinctive light-alloy wheels – further details are just a couple of mouse clicks away.
Find the perfect accessories for your car.

[Quelle: http://mb-configurator.net]