Ah, TempDB. Like a strip club in a strip mall, you hope you can get through the day without ending up there. But if you’re anything like me, you’re not that lucky. In this video, you’ll learn how to configure TempDB to make things as pleasant as possible, and which trace flags can help you....
To access this incredible, amazing content, you gotta get Fundamentals of Database Administration, Recorded Class Season Pass, The Team Membership, Level 3 Bundle (Live Classes, Lab VM Included), Level 2 Bundle (Live Classes, No VM Included) or Level 1 Bundle, or log in if you already shelled out the cash.
- Anti-Virus on SQL Servers (5m)
- Backing Up SQL Server with VSS Snapshots (10M)
- Backup Step #1: Choosing RPO and RTO (21m)
- Configuring CPU Settings: MAXDOP, Cost Threshold, and More (22m)
- DBCC CHECKDB for Full Time DBAs (25M)
- DBCC CHECKDB for VLDBs (30m)
- DBCC CHECKDB When You Don’t Have a Full Time DBA (19m)
- IFI (7m)
- Lock Pages in Memory: LPIM (6m)
- Oops Deletes (17m)
- Patches (18m)
- Remote DAC (7m)
- Restore with Standby (10m)
- RPO RTO Recovery Models (12m)
- Sending Emails with Database Mail (10m)
- Shrinking Files (8m)