You could use the following query that gives most of the information you are looking for. One option would be to store the query in a sql file and...

There is something missing. Could you send us the complete table structures?

Thanks to both for your thoughts. I was planning on gradually reducing the maxdop to see if there is any performance improvement. Regarding the memory and CPU, I...

Thanks for your insight Grant. Yes, regarding CXPacket waits, I am looking into Parallelism. Right now, the queries (INSERTS) span as 16 threads and some of the threads are...

Guys-

Try this out

BEGIN

 SET NOCOUNT ON

 IF EXISTS (SELECT 1 FROM Tempdb..Sysobjects WHERE [Id] = OBJECT_ID('Tempdb..#DataFileStats'))

 BEGIN

  DROP TABLE #DataFileStats

 END

 IF EXISTS (SELECT 1 FROM Tempdb..Sysobjects WHERE [Id] = OBJECT_ID('Tempdb..#LogSizeStats'))

 BEGIN

  DROP TABLE #LogSizeStats

 END

 CREATE TABLE #DataFileStats

  (DBName  VARCHAR(255),...

PhillCart-  As mentioned in my post, I cannot use Linked Server or Staging tables... Long story, why I can't use them.

You were talking about data driven query.  Could you me...

Thanks guys

Olavho-

I greatly appreciate your time.  There is a little bit more to the problem.  Let me explain.

ValueColumnName in the @subtable gives the name of the column in the @fulltable with...

David-

Thanks for your reply.  To answer your questions,

We need to keep the datatypes as we do a lot of comparisons and math on these values.  So conversion may be...

Steve-

I applied SP3a on my machine and then checked the @@verion. It still shows 8.00.384 I looked at the help in QA and it shows 8.00.760.

I checked sp_server_info and...

Thanks a lot for your responses. I ran the profiler and saw that there is a SP that is being called today (not ever before) because the client started...

Steve-

But I cannot see the users from the other server or domain from my EM as they are not trusted domains. I could create the user on the local,...

There is no change in the code. It is exactly the same as it was yesterday. It is possible that there could some queries that are executed today....

Allen-

You are right. I was not running SP3a. The Server checklist that was given to me said the server is patched up to 3a and I did not...

Allen-

I dont see any errors regarding TCP/IP in the error log.

This is how my log file looks.

2003-12-16 21:09:11.64 server Attempting to initialize Distributed Transaction Coordinator.

2003-12-16...