You could also use the QUOTENAME function for your object names.

http://msdn.microsoft.com/en-us/library/ms176114.aspx

I have a stored procedure that you could use to dynamically rebuild or reorganize indexes. It uses the DMV sys.dm_db_index_physical_stats...

I have a maintenance solution that has been designed for database mirroring. The stored procedures only work with databases that are online. This means that you can have the jobs...

I think that you should have a look at the 'Blocked Process Report' events.

You can define that you would like to generate a 'Blocked Process Report' if a process is...

>Our log shipping standby sql server is slower and takes a long time to restore this backup, throwing log shipping out of sync.

I would like to fully understand what...

Could you describe some more about your high availability and disaster recovery strategy. Are you using only Log Shipping or is it combined with some other solution like Database Mirroring...

Just a few thoughts about this.

>1) stop log shipping - put database into simple- reindex - restart log shipping

This means performing a full backup and a restore to initialize log...

The background for the design decision to execute all commands through a CommandExecute stored procedure is that I would like to have a consistent error handling and logging. Information about...

I think that you should add a Maintenance Cleanup Task to the Maintenance Plan.

http://msdn2.microsoft.com/en-us/library/ms345177.aspx

Ola Hallengren

http://ola.hallengren.com

If you just need to delete backup files from inside T-SQL I would use a solution based on xp_delete_file.

Test the command below. It means that you are deleting all backup...

The Maintenance Plans are using the extended stored procedure xp_delete_file to delete files. That can also be used in T-SQL code.

EXECUTE xp_delete_file 0, 'C:\Backup', 'bak', '2008-04-18T00:00:00'

I have a backup stored...

This is just how my backup stored procedure works. You just use it like this.

EXECUTE dbo.DatabaseBackup @databases = 'USER_DATABASES', @Directory = 'C:\Backup', @BackupType = 'FULL', @verify...

If you would like to do the same with T-SQL I have a stored procedure that could help you.

http://ola.hallengren.com/sql-server-backup.html

Ola Hallengren

http://ola.hallengren.com

If you're on SQL Server 2005 you could check the index fragmentation levels with sys.dm_db_index_physical_stats. This way you only have to do something about the indexes with a high fragmentation...

About rebuilding and reorganizing indexes dynamically I have a store procedure that could help you with this. It is using sys.dm_db_index_physical_stats.

http://ola.hallengren.com/sql-server-index-and-statistics-maintenance.html

Ola Hallengren

http://ola.hallengren.com

Rebuilding a clustered index, does not implicitly rebuild the non clustered indexes. You have to rebuild them too.

You could also use the ALL option to rebuild all indexes on a...