Thanks Wanderer, after some adds I'll use it

Well, these 2300 indexes exists on a server, not on one db I've overdone a little; this server holds one real DB and its...

One question: How to drop all USER defined indexes from database at once? There are about 2300 of them

Thanks in advance

Yes, quite simple way. I'll use it next time. Now I've allready fixed that

Thanks

Not sure did I correctly understand, but there are some procs:

sp_help

sp_depends

Yes Chris, you are. The lazywriter starts to do his job (clean inactive pages) when the SQL server takes the maximum possible memory and...

Ups, sorry. Not DBCC MEMUSAGE but DBCC MEMORYSTATUS. 99% comes from one monitoring tool called Spotlight. It shows many general SQL Server parameters and couple of them are SQL...

Yes Chris, you are absolutelly right about what do I mean. I think that RAID there isn't that factor to which we should pay attention.

After running some tools like...

Standart. But does it have any relations with the buffer cache?

The disks are mirrored... Have you any idea?

Well it becomes better because when our buffer cache becomes full, the server uses physical disk I/O instead of logical I/O. It reads data from disk not from cache.

But...

Thanks Chris. I know this DBCC statment, but as you said, it flushes all pages even those which are not aged.

On one of the our production servers the buffer...

There you can find an answer and even more..

http://www.microsoft.com/sql/downloads/2000/sp4.asp

Cheers

What did you had on your mind: "We tried rebuilding the databases for the required collations.."? If you want to change db collation you don't need to restore it. You can simply run...