SQLGuru - I couldn't agree with you more - this is the first time I have ever had responsibility for a system that I can't touch - something like trying...

SQLGuru,

The CPU usage is typically hovering around 13-18%....we do see spikes during our heavy load periods up to 50% but very rarely higher.....on Sat, the CPU is running at 1-2%...

Ganesh,

About 4 weeks ago, we started to experience the same type of slowdown - after rebooting the server, a complex test query takes 90 seconds......over the next 7 days, the...

Here's a simple SP to refresh all views - if anyone is interested, I have another to do the recompiles........

CREATE PROCEDURE dbo.p_RefreshAllViews

as

BEGIN

  SET NOCOUNT ON 

  DECLARE @viewName sysname

  DECLARE...

We also elected to go with one database per client - we use SQL Compare to ensure that the schemas remain in sync across clients.

Using one database per client adds some admininstrative...

Sergiv,

Thanks for the suggestion - but I'm afriad that I'm on to other projects.  Adding the clustered index on SalesDate wont help me though - since there are several dates...

Antares,

Without sales date, the query runs quite a long time and retunrs thousands of rows.....there are no indexes selected and full clustred index scans are done of all tables.......

Thanks for...

Antares,

I declared the variable and moved the date calc out of the select as requested.  The change had no impact on the query path selected - table scans are performed. ...

Antares,

Thanks for the thought - I agree that is can be useful - it was run on Sat as part of the normal maintenance and then again yesterday before the...

Thanks for everyone's input --

Sergiv - I'm afraid the result won't matter - there are serveral indexed date fields on the table and I need to be able to run similar views...

Jeff,

Displaying the estimated query plan using the convert shows 4150 rows - doing the same with a hardcoded date shows 1 row - the actual number of rows for today...

The clustered index is on SalesID which is a sequential ID that is the primary means of accessing the records......there are several other indexes on various fields including SalesDate, InsertDate,...

Antares,

The system has been around for many years - and the decision re the data type was apparently made at inception - the data is imported from another system in...

Sergiv,

TRD.SalesDate is a char(8).........

I just started using Performance Analysis by Quest 3 or 4 weeks ago - it provides a great deal of information on specific queries users are running.  I've been able...