I’ve been involved in helping some customers move databases (user and system) from the C: drive on a few projects now. This is particular an issue when the C: is the default or when Vendors are left to install databases on a server by themselves – quite a few don’t realize where the data and … Continue reading Moving User Databases from the C: drive en mass
Tag: SQL Server
Here’s some common questions I am asked on TempDB Question 1) How Big should my TempDB Be ? On an existing system this is quite a simple question to answer. by default the TempDB starts at 8MB and grows by 10%, so we just look at the size it has grown to and now we … Continue reading Quick Notes on TempDB Sizing