my code stock.com

tei219

printcmd_database_alltable_dbcc_indexdefrag
by tei219

Snippet options

Download: Download snippet as printcmd_database_alltable_dbcc_indexdefrag.sql.
Copy snippet: For this you need a free my code stock.com account.
Embed code : You will find the embed code for this snippet at the end of the page, if you want to embed it into a website or a blog!

create table ##database_check_indexes (
	tabname sysname,
	index_name sysname,
	index_description varchar(210),
	index_keys nvarchar(2078)
)

exec sp_MSforeachtable @command1 = '
declare @@tabname table (
	name nvarchar(128) null
)

create table ##indexname (
	index_name sysname,
	index_description varchar(210),
	index_keys nvarchar(2078)
)
insert into @@tabname (name) values (''?'')
insert ##indexname exec sp_helpindex [?]
insert ##database_check_indexes select * from @@tabname, ##indexname
drop table ##indexname
'

select 'dbcc indexdefrag('+db_name()+', '''+tabname+''', '''+index_name+''')',* from ##database_check_indexes

drop table ##database_check_indexes

Create a free my code stock.com account now.

my code stok.com is a free service, which allows you to save and manage code snippes of any kind and programming language. We provide many advantages for your daily work with code-snippets, also for your teamwork. Give it a try!

Find out more and register now

You can customize the height of iFrame-Codes as needed! You can find more infos in our API Reference for iframe Embeds.