MS SQL Tips & Tricks

How to reindex all tables in database

To reindex all tables in database You just need to execute script bellow:

EXEC [sp_MSforeachtable] @command1 = 
	"RAISERROR('DBCC DBREINDEX(''?'') ...',10,1) 
	WITH NOWAIT DBCC DBREINDEX('?')"

Learn more tricks

Add Comment

Comments

15th July 2021

lasix with no rx fast shipping

zivacle

28th August 2021

generic tadalafil usa medicine cialis tablets cialis dapoxetine europe cipla tadalafil review buy cialis pills cialis medication cost

DennisGax

2nd September 2021

zithromax ndc cephalexin warnings cefixime erythromycin dosages keflex breastfeeding ciprofloxacin bactericidal

Scottunrek

10th September 2021

flagyl eriacta detrol lozol caverta glucophage

Harveybot

16th September 2021

Vente Kamagra Europe

Plaquenil