Just let me know which method worked for you ...have a great day.

If both PCs have network cards all you need is a 'cheap' little switch (<$40) and a couple of network cables to create your own LAN. If you are really daring,...

Here's a few general starting steps ...

• ping from client to server by name ( e.g. ping name )

  ping from client to server by FQDN ( e.g. ping fully.qualified.domain.name )

• ping from...

It may be slightly humorous, but I'd rather not see a Question of the Day if something as trite as someones wardrobe is the substitute for the 'real thing...

I agree with Colin. To see usage of all CPUs you might want to start dbcc checkdb in a loop for a database in one QA window (master), then repeat...

Taking into account you user education/situation I'd keep tempdb at 24 Gb if you have the space - forget the shrinking part as well (autogrow is a bad thing). It's...

I do not know ... if it were me though ... I'd uninstall the 9i upgrade and reinstall 8g (and what ever patches you need) ...

I've used 'native'/'free' compression utilities that aer separate from the SQL BACKUP at varying times ... I've seen the space savings vary between 30-70% ... quite a wide swing ......

Not to be sarcastic, but why did you drop all of the extended stored procedures ?

I'm guessing that by your statement "restored all the extended stored procedure" that you...

Could you post the output of sp_helpserver ? (the actual results set when you execute it from QA) ... I'm asking for a specific reason, to help you figure...

No matter what method you use for your nightly data 'reload/refresh' do not forget to execute sp_recompile tablename for the affected table(s). Without this your perfromance may still be abysmal...

Could you post the output of sp_helpserver ?

I believe Walmart has the largest SQL Server database coupled with Analysis Services ...

Try to think in a different light ... these activities can all be executed out of SQL Server SPs. But a more natural/logical choice would be another scripting language (VB,...

Here's a few questions that I would ask before trying the memory guess:

• How are you going to configure the cluster ? (active/passive or active/active)
• Are you installing one instance only ?...