Thanks so much for the recommendations. I see the following indexes on WWW_CatalogRetail;

ALTER TABLE [dbo].[WWW_CatalogRetail] ADD CONSTRAINT [PK_WWW_CatalogRetail] PRIMARY KEY CLUSTERED
(
    [WCRType] ASC,

Thanks for the reply. Sorry - I didn't intend for the image to be very reviewable... It was just a section to show the general scope / size of the...

Heh... so I was not in query analyzer... I was just in SQL EM... when I select from the view in QA it shows up as expected... in EM it...

Aha... very cool - thanks Lutz.

One more question... I am looking at the result set from the view now, and numbers like 6,400.00 in the table show up as 6400...

Thanks for the reply Lutz...

Yeah - I am pretty green when it comes to SQL, so...

The last comma after field4 was a typo.

As for the data that is in...

Thanks for the reply!

I guess we have just always used the local tools on the SQL Server to create / edit DTS packages.

I am inheriting this system, so there...

It was the tempdb data file...

Thanks so much for your help!

Thanks for the response...

Should I be just looking at PIDs, agent jobs, etc. or is there someplace else that might be easier? (Sorry I know that is a total noob...

This is a pretty inspirational article. I am not a developer or a DBA... I am an admin (no flames please), and I absolutely believe that this content is true...