Some things you might consider:

* Did you run a

- dbcc updateusage on the migrated database?

- sp_updatestats on the database

* Do you have statistics? ("auto...

update statistics by:

use {databasename}

exec sp_updatestats

- Have you checked (several) logfiles? (Windows log, SQL log, SAN log)

- What configuration changes did happen before these problems arised?

- What is a SAN?

- What is RAID?

- Which RAID type is best for data, which for log?

- What is the advantage of a SAN?

- What is a NAS? is...

I think you're mixing some concepts. Clustering is actually multiple servers around a database, where one server is active and the other is passive (waiting for the active server to...

Create a Job.

Not getting personal, but if you don't know what you're doing or you don't know how to do this, as your boss for a course. MSSQL is not...

Technically, you can't see if a database is OLTP or OLAP. Both contain tables, indexes etc.

But because a OLTP is used different compared to an OLAP database, there should be...

Interesting situation: The whole world is blown up, and you're concerned about restoring a database 😀 (Probably a 1TB Axapta database?)

I recommend this script from Lara Rubbelke, which does a smart index reorg/rebuild:

http://blogs.digineer.com/blogs/larar/archive/2006/08/16/smart-index-defrag-reindex-for-a-consolidated-sql-server-2005-environment.aspx

By truncated, you mean "shrinked"?

It's a misunderstandind that a transaction log will stay small; the size of the transaction log depends on your transaction. If you update a large table...

aaaargh! .ldf is not a databasefile extension, but a logfile extension. :crazy:

So i disagree with the suggested "correct" answer

I can't test your script, but what is exactly the problem? Assuming this script works well, you just want the output to a file?

If you're running this script in a...

I don't think that just removing a datafile entry in master will fix this problem. If your data is spreaded over the 5 datafiles, you're missing 20% of your data...

We use XMLA to backup the cubes

try this script. Combine it with sp_msforeachtable to disable or enable indexes, depending on @switch

Note: this stored procedure will only disable nonclustered indexes or indexes which are added for performance...