Slawek (5/21/2008)

---

What do you think - is it better to scan the entire table every DW load, or is it better to create non clustered index on timestamp column...

Max () OVER ()???? :blink:

< wanders off in...

In SQL 2005, only objects that a user has rights on can be seen from the system views. So, if your web site user has no access to the base...

You may be able to remove the inner cursor. The outer one, no.

WHILE @@FETCH_STATUS = 0

BEGIN

--Find the number of days before ESCALATION

...

Not at the moment, though we are considering it. Right now we only have a single...

A worthy investigation. I look forward to your results.

If you can post the query and the definitions of the tables involved, we may be able to help.

From the sound of things, the inner cursor may be removable. Can you post just that bit please?

Jack Corbett (5/21/2008)

---

The only reason I put things in a trigger instead of a proc is to protect me from me. Most triggers I use are "audit" or change...

Grab one of the 3rd party backup solutions that offer compression. Most of the time of the backup is writing the backup out to disk/tape. I use LiteSpeed. There are...

Just on account should be fine. The clustering key is always present in all nonclustered indexes as the rows 'address'. Queries that filter on both, or just on country can...

Steve Jones - Editor (5/21/2008)

---

The page split thing is an interesting one and it makes sense. You're allowing read of dirty data and page splits, and re indexing, would have...

knowlton (5/21/2008)

---

If I say, SELECT * FROM DATA WHERE COUNTRY = 'Mexico' and ACCOUNT = 1000, #1 would hit COUNTRY first (which could be hundreds), get everything for Mexico (which...

Could the server be in single user mode? Check the SQL error log.

I look forward to the explaination. :hehe: