Menu

SQL Server
T-SQL
DBA
Azure
BI
Tutorials
Scripts

Flush plan cache for single database

9. 3. 2018

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

30

Share:

Drop all tables in database

Rebuild all indexes on table

Most popular
- SQL Server
  
  Foreign keys and differences between CHECK, NOCHECK and WITH CHECK options
  24. 5. 2019
- Azure
  
  Run your first U-SQL script in Azure Data Lake (step-by-step tutorial)
  21. 10. 2019
- Azure
  
  Backup and restore database in Azure Storage Account
  25. 5. 2019
- T-SQL
  
  TRY & CATCH pattern
  8. 12. 2017
- SQL Server
  
  How to Solve Invalid Database Reference in an SQL Server Project (VS2015)
  28. 4. 2016
Tags

administation C# constraints databases data types date & time DDL development DML errors Excel functions indexes internals 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
BI
Tutorials
Scripts

@ SQLpowered.com 2020