You may want to consider creating an indexed view that materializes and pre-aggregates the data.

chrisph (5/5/2010)

---

Yes the log file is set to autogrow by 10% (which was 100MB), I have set this to 50MB now.

The database is in FULL recovery mode.

There are no log...

Here is my solution to your problem. I have to upload as a text file as I seem to be having issues with posting the code.

Compared to what you wrote, I have to agree with myself, I was short. 😛

Could just be the way I...

By the way, I have an answer to your question, I'm just waiting to see what you have done to solve the problem first.

Just a little short I may have been.

Try asking the sys admins responsible for the servers.

Now for a really important question, can you show us what you have done to try and solve this problem?

chrisph (5/5/2010)

---

Hello,

On a large database which is being written to extensively, received errors "Autogrow of the "dbname_log" in database dbname was cancelled by user or timed out after ___ milliseconds....

When I have seen this is usually indicates a possible issue with your I/O subsystem. How is you server configured, is it using a SAN, NAS, or DASD?

How are...

lsuersoy (5/5/2010)

---

Mr. Lynn Pettis, I understand what you said. You have a question. Reduced to the MDF file, your site may I upload? How? Does changing the file extension according...

Here is something that would really help; provide the DDL (CREATE TABLE statement(s)) for the table9s) involved, sample data (as a series of INSERT INTO tablename statements) for the table(s)...

Field Trip - Going to the Denver Museum, seeing the Body works Exhibit with my youngest and her class.

stark 41816 (5/3/2010)

---

Hi Lynn,

thank you for your fast reply.

Looking at your code, you use async sql operations to update and re-read:

update ....

select ....

Without locking, what happens...