one of the [font="system"]ex.cal_date[/font] column values in the database that fails has probably been set to zero or possibly NULL.

Lynn (4/30/2008)

---

Creating a new database would involve going back and making changes to 100+ servers which cannot be done at this time. This particular db exists on all servers which...

Some of the record sequences look very suspicious to me. In particular, I would check out the records with IDs: 7622 and 9012. Especially the second one (9012)...

Frankly, this looks like someone is running manual tests on your table and then rolling-back or deleting the records.

Look for DELETES or ROLLBACKS in the log file. Also, if...

ygulas (4/30/2008)

---

easiest way is to define the DEV server as a linked server. And using the four name convention

insert into PROD.DB.dbo.tablex

select * from DEV.DB.dbo.tablex

( DEV is the name of...

Also, you need to give us some configuration information. The significance of these numbers is heavily affected by how many processors*cores and how many volumes/spindles.

How long does the spike last and are you sure that it is coming from the SQL Server process and not something else running on the same machine?

You could jury-rig something up through Service Broker or even a SQL Agent Job.

The same way the I did it in FORTRAN over 35 years ago:

Float3 = Floor(10000 * (Float2 / Float1)) / 10000

This may be my oldest user-defined function that I have...

Paul Campbell (4/30/2008)

---

Thanks for the reply.

I am not an SQL expert, so dont really understand what you mean caches not loaded?

Are the caches stored per database? All I was aware...

Something that I used to use that is just a tabular implementation of Grant's suggestion:

create table Months (MonthNo int, Month4Period int, Month6Period int)

insert into Months

Select 1, 1, 1

Union...

matt6749 (4/30/2008)

---

thanks Barry - I'm having trouble with all this stuff - i would think there has to be a generally best way to code custom paging in asp.net, but...

Yeah, insuring that your restores can...

Mind you, it would not necessarily perform very well.

And, the tables might be stored in different filegroups or files on different disks that have different performance characteristics or usage profiles.