Sweet! I tried that approach with the order by testdate ACS and of course the grouping was wrong. I will figure out the regrouping with dense_rank()!

thanks so much!

Do you have the old drivers by any chance as well? I will ask our sys admin to compare. thank...

ALZDBA (7/17/2008)

---

VD (7/16/2008)

---

to SQLGuru,

can you please provide more info about the iLO driver bug? We've recently had issues with an HP box restarting without ANY errors in any of...

to SQLGuru,

can you please provide more info about the iLO driver bug? We've recently had issues with an HP box restarting without ANY errors in any of the logs....

A few times when our SQL server hit 100% CPU it was because a proc lost a good execution plan.

for SQL 2005 run

DBCC TRACEON (1204, -1)

DBCC TRACEON (1222, -1)

-- to check the status

DBCC TRACESTATUS(-1)

for more information please check BOL.

ms-help://MS.SQLCC.v9/MS.SQLSVR.v9.en/udb9/html/2ed3e3e7-5080-4fa3-b79a-585470602bc2.htm

Something else to keep in mind when choosing Express over Workgroup is that express edition has limitations to the "horsepower" it can use.  Express can only use 1CPU, 1GB...

Have you checked locks and waits?  That might shed some light on where the bottleneck is. 

We generally try to load our data off hours when we can drop all...

Hi, have you tried dropping all indexes before the load and adding them after you are done? 

The wizard doesn't have the step to delete backup files.  I usually create a maint plan with the wizard and then open it and add Maintenance Cleanup Task.  It has...

We are bundling XOSoft up with our software for the customers that want HA or DR solutions.  I am pretty impressed with the software.   It syncs not only...

to make the story short...our customer doesn't allow us to use SMTP - no alerts.  We are also not allowed to connect remotely.  All we have is SNMP. 

that was it!  Restarting the SQL Server service solved all my problems.  Thank you all for your help!

it is a domain user.  Since both SQL server and SQL server agent run under the same account this user is also a memmber of a bunch of SQLServer groups...

that is what I had originally. It gives me the same "Access Denied".  I will try again tomorrow with a "fresh head".  I am probably missing something really stupid.