No, we were already using AWE. Production has 6GB RAM Test 10GB RAM. Test box was brand spanking new machine with two brand new Raid 10 arrays. ...

Started a new thread on Windows 2003 performance.

I saw some inprovements moving from NT4 to W2K with SQL 2000, can't remember the details though. We have a lot of large DB's here and have been testing...

I've had this happen after cancelling a restore. To resolve it, I detach the offending database and then reattach it. I only do this after issuing a sp_who2....

Have you checked to make sure SQL Server has been set to use more than one processor? In Enterprise Manager, right click the Server and choose Properties. Then...

I've used this technique with success on various large databases. It has helped with the performance on lookups and the physical size of tables. However, on the downside...

Carl,

Upon installation SQL gets its default collation from the Operating System. Locale settings on the OS can be changed in 'Regional Settings' which is found in Control Panel. ...

All the connections have the same set options.

The number of executable plans is never consistent either.

After numerouse SQL profile traces and queries against the syscacheobjects table I have given up....

well I investigated a bit more and added an new clustered index to a table. Everything runs quicker now, but I still have 100% CPU across 4 hyperthreading processors...

Can you please post the query you are trying to run and the error you get?

Angela

We are using Business Objects and their web component, Web Intelligence for ad hoc reporting, Board Reports and government reporting. It allows the smarter users to create their own...

We use SQL Litespeed for all our SQL servers, then we back these backups to disk. It's cheap and heaps faster than native SQL backups. It shrunk our 30...

We are using Business Objects and their web component, Web Intelligence here for reporting from our data warehouse.

Cheers,

Angela

Hi Steve,

Eventually solved this problem. The original Developer changed the 'visible' setting to false on the cube properties and forgot he'd done so. Took a while to suss...

In reponse to Slange's post. I must be classed as a DBA/DBO/Developer as I'm doing all the responsibilities you mentioned! I think it actually works quite well, being...