---Clean SQL Cache
DBCC DROPCLEANBUFFERS
go
DBCC FREEPROCCACHE
go
DBCC FREESYSTEMCACHE('ALL')
top of page
bottom of page
---Clean SQL Cache
DBCC DROPCLEANBUFFERS
go
DBCC FREEPROCCACHE
go
DBCC FREESYSTEMCACHE('ALL')
--Import multiple trace file in sql Table. --All the rollover files will be automatically imported --provide number tracefile to capture...
--SQL Server Database log full due to replication, you can run the following command to mark all ---the replication transaction is done,...
--disable cdc master --Table Contains list of all the tables where cdc needs to be disabled - [dba].dbo.replication_cdc_table --execute...
댓글