Skip to content

Igor Micev

My blog about SQL Server

Menu

Primary menu

  • Blog
  • About Me

Tag Archives: tempdb

The TempDB in SQL Server

Posted on March 24, 2016 by Igor Micev — No Comments ↓

Every SQL Server instance has a shared database named TempDB. It is a database where temporary objects are stored and used by other databases. Because it’s only one database for the instance, it often proves to be a bottleneck. Hence, Continue reading The TempDB in SQL Server→

Posted in Configuration | Tagged configuration, temp tables, tempdb | Leave a reply

Primary Sidebar Widget Area

Recent Posts

  • Useful T-SQL queries and scripts to work in SQL Server
  • How to Write a Better T-SQL Code
  • Some New Cool Features in SSMS

Categories

  • .NET (3)
  • Configuration (6)
  • Database design (5)
  • Features (4)
  • Installation (4)
  • Maintenance (7)
  • Optimization (5)
  • Programming (5)
  • Scripts (4)
  • SQL Server (2)
  • SSMS (6)
  • T-SQL (13)
  • Technology (2)
  • Uncategorized (6)

Tags

C# clone CLR code-refactoring compression configuration constraints cpu CXPACKET dates EOMONTH extents foreign keys fragmentation functions hints and tips indexes JASON jobs jokes licensing master rebuild maxdop MCT mixed_page_allocation MVP powershell primary key query Regex reports report server sample databases script snapshot SQL Azure sql server ports stored procedures system databases tempdb temp tables

Subscribe via Email

Subscribe via Email

  • Twitter
  • Google Plus
  • Linkedin
  • RSS Feed
Copyright © 2023 Igor Micev. All Rights Reserved.
Theme: Catch Box by Catch Themes
Scroll Up