Menu
SQL Server
T-SQL
DBA
Azure
BI
Tutorials
Scripts
Uncategorized
Flush plan cache for single database
9. 3. 2018
DECLARE @DbId INT SET @DbId = DB_ID('DBNAME') DBCC FLUSHPROCINDB(@DbId)
28
Share:
Previous
Drop all tables in database
Next
Rebuild all indexes on table
Most popular
SQL Server
Foreign keys and differences between CHECK, NOCHECK and WITH CHECK options
24. 5. 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
SQL Server
IDENTITY_CACHE and gaps in identity values chain
12. 1. 2019
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