What GSquared is alluding to with his sample code is that it would help if you would show us your code. It would be much easier to help you...

Jack Corbett (9/28/2009)

---

I think in the case being pointed out by Sliverfox, that the answer was a little brief, but not necessarily inappropriate. I would have probably would have...

Michael Valentine Jones (9/24/2009)

---

Lynn Pettis (9/24/2009)

---

Taking Michael Valentine Jones version and making it a bit more the way I'd write it, it would look like this:

select

...

Sergey Vavinskiy (9/24/2009)

---

The UPDATE/DELETE/INSERT may not even be able to complete the respective action because it can't get the required locks due to the locks put on the rows/pages/extents/table as...

Sergey Vavinskiy (9/24/2009)

---

I also think you missed the point, as Steve pointed out, only changes are logged. A simple, or complex, select statement for a report is only reading the...

Sergey Vavinskiy (9/24/2009)

---

Lynn,

If it is only one process running against this DB,...

Also, could you repost the DDL? I had them for a while yesterday, but I opened them directly and did not save it on my system.

Could you post the execution plan of the query without the index hints? That would probably be much more helpful in solving the problem. What appears to be...

Curious, how does a SELECT statement fill a transaction log? I can understand UPDATE, DELETE, and INSERT; but SELECT?

If your database is using the full recovery model, you really need to setup transaction log backups. This will keep your transaction logs from filling up your log drive....

Taking Michael Valentine Jones version and making it a bit more the way I'd write it, it would look like this:

select

a.DT,

...

Actually, Michael Valentine Jones looks simplier than mine, so I'd go with his. I wouldn't have posted mine had I read his first, but I got sidetracked a bit...

How about trying this:

declare @Date datetime;

set @Date = '2009-09-15';

select

dateadd(mm, -3, dateadd(yy, datediff(yy, 0, dateadd(mm, 3, @Date)), 0)) as BeginFiscalYear,

dateadd(dd, -1, dateadd(yy, 1,...

doofledorfer (9/23/2009)

---

As to the size of the table, you'll presumably write it to be large enough for the purpose to which you are applying it at the time. Validating its...

Sounds like a case statement being used in the update. How many differnet values of id_promotionSub are there? How many rows of data in the fact table?