Maybe a bit extreme but one DBA monitoring team I worked with had a job on every server to log an error every hour. Had a bit of an...

Yes, I always go up the apples for a meryl.

Could it be index fragmentation? Or could it be some other process(es) using the table at the same time your query is running?

Great article, and good advice in there.

I'm off to get some new glasses.

Is moving the database to it's own server an option?

Sometimes it is quicker and easier to copy out the data you want to keep, empty the table using truncate, and then put the data you want to keep back...

You will probably get some more suggestions on how to do this later today, but here is how I would approach it.

SELECT

RRT1.[Employee Number]

, RRT1.[Timestamp]

, RRT1.[RAG Rating]

, RRT3.[Timestamp] [Previous...

When you do the insert into the previous table you are not inserting the previous value but the earliest value for the employee as you are using the MIN function....

I was still using DBCC DBREINDEX to carry out the index maintenance where we had issues with statistics being updated. IIRC it was SQL 2000. So the index stats...

Show us your query.

13.0.2100.1

Thank you for the question.

You are probably going to have to refresh the environments from Production from time to time so it will be worth automating this process as much as you can. ...

John Hanrahan (4/19/2016)

---

Steve- I have not used it as I am too cheap and frankly don't surf much. I've done the research though. John Dvorak wrote an article...

I've done this recently. Got burned with letting the...