Back Home

SQL Server database administration in sunny Cleveland, OH

SQL Server database administration in sunny Cleveland, OH

Home » 2011 » October » 27

Daily Archives: October 27, 2011


SQL Server A to Z – Tempdb

This entry was posted in General and tagged a to z tempdb on October 27, 2011 by Colleen M. Morrow

I may be on vacation, but the alphabet goes on. We’re up to the letter T and that stands for tapas, toreadors, and tempdb! Tempdb is a system database with one very special characteristic: it gets recreated every time SQL Server starts up. What is tempdb used for? The first use for tempdb is user […]


Categories

  • BI (19)
  • Events (17)
  • Features (47)
  • General (32)
  • Internals (3)
  • Maintenance (21)
  • Non-SQL Stuff (7)
  • Powershell (9)
  • Professional Development (46)
  • Security (3)
  • SQL Tuning (7)
  • T-SQL (26)
  • Troubleshooting (16)
  • Uncategorized (4)

Recent Posts

  • SQL Server Service Broker – Security
  • Joining Fortified Data
  • SQL Server Service Broker – Networking
  • SQL Server Service Broker – Internal Activation
  • SQL Server Service Broker – Error Handling

Tags

#TSQL2sDay 70-463 a to z Auditing backup compression backups blogging certificates database maintenance data compression differential backup DMVs Event Notifications exam prep general dba goals high-availability index maintenance inventory linked servers memory mirroring Oracle page compression PASS performance powershell presenting professional development recovery Resource Governor scripts Service Broker slacking off snapshots SQL 2008 SQL Audit SQL Saturday SQL Server SSIS troubleshooting tsql update statistics WIT Women in Technology

· © 2023 ColleenMorrow.com · Designed by Themes & Co ·

Back to top