From the course: SQL Server 2016: Administer a Database Infrastructure
Unlock the full course today
Join today to access over 22,600 courses taught by industry experts or purchase this course individually.
Find sessions that use tempdb resources - SQL Server Tutorial
From the course: SQL Server 2016: Administer a Database Infrastructure
Find sessions that use tempdb resources
- [Instructor] Tempdb is a system database that's used for a variety of SQL Server administrative tasks, and is available for every user of your databases. It's used for storing temporary objects such as temporary tables and store procedures, variables, and a place for SQL Server to store intermediate results for instance, while it's sorting tables of records. Every time the server is restarted, the tempdb database is recreated so it always starts out empty, however occasionally users can unexpectedly fill it up, and it's a good idea to be able find out who is using tempdb resources and why. So let's explore this. I'm first going to switch into the WideWorldImporters database, and I'm going to create a new temporary table called invoice details. We'll populate it with a bunch of records that are coming out of the WideWorldDatabase, and specifically we're going to pull from the Sales.Invoices table, Sales.InvoiceLines, Sales.Customers, Warehouse.StockItems, and Application.Cities…
Practice while you learn with exercise files
Download the files the instructor uses to teach the course. Follow along and learn by watching, listening and practicing.