Impressive information ... I have never pushed SQL Server to that etent.

If you have not added a lot of data the size should not increase since your key/index is varchar. Only the exact amount of data needed (plus a nullability and length...

First thing you need to do is download the setspn utility (link below):

http://www.microsoft.com/downloads/details.aspx?familyid=5fd831fd-ab77-46a3-9cfe-ff01d29e5c46&displaylang=en

Install it on your computer (or server). Next you'll need a Domain Admin account to use (unless...

Happy Birthday Steve !

This post is a day late due to production issues on the job all day Friday (not my doing) that did not allow me my normal continuing...

Well thanks for the proper reference Dave ... I still love it !

Oh, by the way, about 'that feeling'

... been there and...

I love you closing signiture Dave !!!

I understand your plight Steve. I have encountered this in many meetings and presen tations. I have even encountered this when taking training courses. I truly hope that MS and...

First I would look at the time it took for a backup of that database to occur. Based on your database size, 70 Gb, I would add 10% to the...

FYI ...

If you are using trace options for capturing information (usually deadlocks) you will want add startup flags -T1204 & -T3605. These capture deadlock information and send it to the...

Add to the list for things to do to the tables needed for this process:

• UPDATE STATISTICS
• sp_recompile
• sp_refreshview

All of the assistance/suggestions/etc. listed in this posting will not help unless you have...

On one side of the coin I am flabbergasted but on the other side of the coin it makes sense in todays business climate. Maybe MS can take a lesson from Sun and...

James, I have to go buy a hat now just so I can take it off to you.

You have stated the most salient points of this service specific niche so...

Charles, your answer is correct

However your reasoning is a bit off

To recap the correct Question/Answer/Reason scenario:

       ...

How many MS programmers does it take to change a light bulb ?

I do not think anything is corrupt ... my guess is that you need more RAM

Memory

------

MemoryLoad = 98%          TotalPhys = 255 MB        AvailPhys = 2 MB          

TotalPageFile = 1002 MB  ...