It sounds like parallelism is slowing the query down. Try upping your cost threshold for parallelism setting with sp_configure and see if that doesn't cause the slow server to...

I would try reindexing the tables outside of the maintenance plan and see how that works. If it's taking 800+ hours I would also look at just dropping and...

I changed your query a little.

select t.name as tablename

, c.name as columnname

, isnull(p.name,'''') as ConstraintName,

case p.xtype

When 'PK' Then 'Primary Key'

When 'C' Then 'Check'

When 'UQ' Then 'Unique'

When 'F' Then 'Foreign...

I looked around and couldn't find anything other than them saying to drop and recreate. I even copied sysindexes and then tried to delete all of the rows and...

select @@version in query analyzer will give you the release your on.

I would check the licensing service to see how many Cal's you have.

Tom

In profiler, under events and warning, missing column statistics.

Tom

It really depends on your data as to whether recompiles are good or not.

For example: Say you have a table with a million rows in it and has...

Have you run a profiler to check for missing column statistics? I have seen query times jump up when column statistics go missing.

Tom

I agree, I usually write my own scripts to do backups and dbcc's, and have never run into a problem with backing up the database. I would profile the...

Does that mean it is good practice to script all views, udf's,diagrams,table_schema.

The whole point of database backup's is recovery of the database. That doesn't mean, the database less the...

In query analyzer start 2 sessions.

Session 1:

begin transaction

update some_table set some_column = some_value

Session 2

Select * from some_table.

Session 2 is blocked by session 1.

Rollback the transaction when...

I don't think so. Stored procs are stored on the physical mdf files of the database. If you are doing file backups, you are capturing the database schema...

I found the script out there. Search for "Kill all Connections".

That should do you.

Thanks Tom

This should do for you.

Microsoft Knowledge Base Article - 106122

sp_fixindex.

Let us know.

Thanks Tom.

I would try to bcp the table out into a new table. Not 100%, but I remember reading that sql doesn't reclaim space in file when columns are shortned or...