DBA Diaries

Thoughts and experiences of a DBA working with SQL Server and MySQL

How to shrink tempdb

Posted on December 27, 2011 Written by Andy Hayes 15 Comments

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]

Filed Under: All Articles, SQL Server Administration Tagged With: sql server, tempdb

SQL Server TempDb – what’s it for?

Posted on December 13, 2011 Written by Andy Hayes 3 Comments

sql server tempdb

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]

Filed Under: All Articles, SQL Server Administration Tagged With: tempdb

The importance of the foreign key constraint

Posted on December 4, 2011 Written by Andy Hayes 8 Comments

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]

Filed Under: All Articles, MySQL Administration, SQL Server Administration Tagged With: performance, sql server

TempDB best practices

Posted on November 30, 2011 Written by Andy Hayes 9 Comments

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]

Filed Under: All Articles, SQL Server Administration Tagged With: performance, tempdb

  • « Previous Page
  • 1
  • …
  • 19
  • 20
  • 21
  • 22
  • Next Page »

Categories

  • All Articles (82)
  • Career Development (8)
  • MySQL Administration (18)
  • MySQL Performance (2)
  • SQL Server Administration (24)
  • SQL Server News (3)
  • SQL Server Performance (14)
  • SQL Server Security (3)
  • SQL Tips and Tricks (19)

Top 10 Popular Posts

  • Using sp_change_users_login to fix SQL Server orphaned users
  • How to shrink tempdb
  • MySQL SHOW USERS? – How to List All MySQL Users and Privileges
  • How to Transfer Logins to Another SQL Server or Instance
  • How to Delete Millions of Rows using T-SQL with Reduced Impact
  • T-SQL – How to Select Top N Rows for Each Group Using ROW_NUMBER()
  • New T-SQL features in SQL Server 2012 – OFFSET and FETCH
  • How to Kill All MySQL Processes For a Specific User
  • Using exec sp_who2 to help with SQL Server troubleshooting
  • How to move tempdb

Recent Posts

  • How to Setup MySQL Master Master Replication
  • How To Use SQL to Convert a STRING to an INT
  • How to set up MySQL Replication Tutorial
  • How to Use SQL CASE for Conditional Logic in Your SQL Queries
  • Using ISNULL in SQL Server to Replace NULL Values

Search

Connect

  • Twitter
  • Facebook
  • Google+
  • RSS

About

  • Cookie Policy
  • Disclaimer
  • About
Copyright © ‘2021’ DBA Diaries built on the Genesis Framework

This site uses cookies. We assume you are happy with cookies but click the link if you are not. Close