I tend to agree with Rudy on this.  If you are not sure of the 'normalization' rules and how to do it, you should have an external party look at...

I'm guessing you trying to determine when you pass back an error?

Most of it is personal preference.  I prefer to send back a 0 if all is good and the...

If you profile, you might be able to see high reads on certain calls.  (or minimumly higher duration).  Once you know which things are the problem, you can make the...

For benchmarking,

I recommend Batch Req/Sec

Also, look at compilations/sec and batch compilations/sec

Keep an eye on Avg Disk Queue Length, but not as a sole measure.  In conjunction with other things it...

Functions are normally slower than other methods.

However, to ensure it is not an indexing issue, run profiler against the call to see what type of output you are seeing.  Sometimes...

I agree with Rudy.  The 'why' is very important?

I've created some stpred procedures that automatically generate history tables, (based on the schemas of the original table) and also automatically built...

Is there any messages in the event log/ or SQL logs?  Did you try to issue a select from QA?  What happens if you connect to the DB from a...

It's actually a maintenance plan that is doing the work.  So, its a reindex.  I figure this might be a 'disk' fragementation issue or at least be tied to that.

When...

Rudy,

Thanks for the reply!  I have inherited quite a mess here, but we do index EVERY NIGHT (thats a completely separate issue at this point).  The restore was directly from...

I ran the updateusage='true' option and it did correct the negative values. 

However, it is still much larger than it should be.  I see the data and indexes on one...

According to this link, you also need the Enterprise edition.

http://www.microsoft.com/sql/evaluation/overview/default.asp

Because Stanard only support 2GB RAM. 

I would also put the value for DATEADD(dd, -14, GETDATE()) into a variable. 

SELECT @MyCompareDate =  DATEADD(dd, -14, GETDATE())

In relation, you are trying to store a tree.  The question is what size tree is it?  Fixed length?

There are 3 main ways I know of to store a tree,...

You should be able to reference the inserted table for the new value and the deleted table for the 'old' values.

Excellent job and I agree well written.  I, too, thought I would be careful not to get 'got'.

Great job Steve.