There may come a time when you might want to shrink tempdb because it has become too large. There are a few ways you can do this and I have listed them below but please read to the end of the post before making a decision on which way you want to … [Continue reading]
SQL Server TempDb – what’s it for?
SQL Server TempDB is a system database, automatically created when you install SQL Server. So what is it used for? Well a few things actually but first I have to tell you that Microsoft didn't name tempdb because they couldn't think of a … [Continue reading]
The importance of the foreign key constraint
The foreign key constraint is an important aspect of database design. This article explains why. Foreign key constraint advantages The purpose of the foreign key constraint is to enforce referential integrity but there are also performance benefits … [Continue reading]
TempDB best practices
Continuing on from my post describing what SQL Server TempDB is used for, I wanted to write about tempdb best practices and how on a busy system, modifications to the default setup of tempdb and its placement can boost performance. How to optimize … [Continue reading]