Steve,

Agreed.  That's what I was attempting to explain to this person, but I don't think they quite understand how databases work regarding consistency of log files, etc.

Thanks again and have...

Steve,

Thanks for your reply.  It is more a case of someone wanting to swtich an active database to standby mode so that a differential backup may be applied.  The only...

I agree that this is a stupid question because the explanation mentions nothing about the word MIDDLE acting as a table alias.  Instead, the explanation treats MIDDLE JOIN as some...

If you are referring to the question: 

 Tab_A      Tab_B

Id_A  Ds_A   Id_B Ds_B

----  -----  ---- ----    

  1   A1     2    B1

  2   A2     3    B2

  3   A3    ...

Jnelson,

There is a much easier way that does not require variables or temp tables. Just use a derived table as follows:

select sum1/colc

from sometable s1

inner join (select (cola + colb)...

Kraks,

Here are some of the most common sql-related perfmon monitors:

Memory: Pages/Sec

Memory: Available Bytes

Physical Disk: % Disk Time

Physical Disk: Avg. Disk Queue Length

Processor: % Processor Time

System: Processor Queue Length

SQL Server Buffer:...

Kraks,

Okay, that helps. Are you using the same version of SQL on both boxes? ie., both boxes are running SQL Server 2000 Standard Edition.

Have tried running perfmon on...

Hameed,

Keep in mind that the /3GB and PAE switches apply to other Microsoft applications in addition to SQL Server EE. For example, Microsoft Exchange 2000. That is probably...

kraks,

Do the two servers in question have identical hardware?

What kind of traffic/load is present on each server?

Have you recently rebuilt indexes or restored the database in question on one of...

Thanks Deejay!

Indeed, these two tools have saved my skin on more than one occaision. They are definitely worth having!

Best of luck!

wavie davie

tkc,

I had a similar problem about two months ago. I solved it by downloading two free utilities from http://www.sysinternals.com

You want to get Regmon and Filemon. ...