Menu

SQL Server
T-SQL
DBA
Azure
Tutorials
Scripts
T-SQLpowered
Metamodel

Flush plan cache for single database

9. 3. 2018

DECLARE @DbId INT
SET @DbId = DB_ID('DBNAME') 
DBCC FLUSHPROCINDB(@DbId)

60

Share:

Drop all tables in database

Rebuild all indexes on table

Most popular
- SQL Server
  
  Scalar Functions and Parallel Execution Plans
  27. 1. 2021
- BI
  
  Extracting Metadata from the Power BI Report File
  19. 12. 2020
- T-SQL
  
  Using Binary Hash as an Alternate Record Key
  17. 12. 2020
- Azure
  
  Run your first U-SQL script in Azure Data Lake (step-by-step tutorial)
  21. 10. 2019
Tags

administation C# constraints databases data types date & time DDL development DML errors Excel functions hierarchy indexes internals JSON MDS MERGE performance Power BI procedures replications security SELECT sequences sessions SSRS tables tools triggers TRY&CATCH U-SQL views XE XML

SQL Server
T-SQL
DBA
Azure
Tutorials
Scripts
T-SQLpowered
Metamodel

@ SQLpowered.com 2020