Skip to main content

VLDB

VLDB Very Large Database. Typically considered a database with a total size ranging from hundreds of gigabytes (GB) to terabytes (TB), contining millions or billions or rows. Designed with scalability in mind, they use different performance optimisation techniques to smaller sized databases.

Moving Tempdb

So somebody setup sql server and you now want to move tempdb to another drive? Easy. Fire up Query Analyser and run the commands: ALTER DATABASE tempdb MODIFY FILE (name = ‘tempdev’, filename = ‘new-file-path‘) ALTER DATABASE tempdb MODIFY FILE (name = ‘templog’, filename = ‘new-file-path‘) Replace the new-file-path with the full path and filename […]