Ninja's_RGR'us (5/13/2011)

---

chandan_jha18 (5/13/2011)

---

Ninja's_RGR'us (5/12/2011)

---

Mike01 (5/12/2011)

---

That guy wrote a statement like

Update dbo.Transactions Set

TractorPPG = @price,

TractorCost = @TotalCost

Where Current OF OPIS_Cursor

do you think any index will help here as...

Ninja's_RGR'us (5/12/2011)

---

Mike01 (5/12/2011)

---

That guy wrote a statement like

Update dbo.Transactions Set

TractorPPG = @price,

TractorCost = @TotalCost

Where Current OF OPIS_Cursor

do you think any index will help here as this update...

Ninja's_RGR'us (5/12/2011)

---

chandan_jha18 (5/12/2011)

---

Ninja's_RGR'us (5/12/2011)

---

chandan_jha18 (5/12/2011)

---

Ninja's_RGR'us (5/12/2011)

---

There's no way in hell we can rewrite this for you from here. It would take us most likely up to 1 week to...

Mike01 (5/12/2011)

---

chandan_jha18 (5/12/2011)

---

Mike01 (5/12/2011)

---

Just a question. What is this code for? I will also echo what has already be said.

select distinct

t.TransactionDate , ...

Ninja's_RGR'us (5/12/2011)

---

chandan_jha18 (5/12/2011)

---

Ninja's_RGR'us (5/12/2011)

---

There's no way in hell we can rewrite this for you from here. It would take us most likely up to 1 week to completely rewrite...

Mike01 (5/12/2011)

---

Just a question. What is this code for? I will also echo what has already be said.

select distinct

t.TransactionDate ,

pd.productDescription...

Ninja's_RGR'us (5/12/2011)

---

There's no way in hell we can rewrite this for you from here. It would take us most likely up to 1 week to completely rewrite this and...

Lowell (5/12/2011)

---

HowardW (5/12/2011)

---

...rewrite the update as a set based operation rather than a cursor. The performance of cursors for this type of work is unnecessary and dog slow.

We can't tell...

skcadavre (5/12/2011)

---

Convert the cursor into a set-based solution.

With the current information from your post, that's the best answer I can give. If you want a better answer, I'd need you...

colin.Leversuch-Roberts (5/10/2011)

---

I'm not sure if we're very clear here - set statistics io on show io statistics not cpu. using this in SSMS is a good quick way...

Thanks but what if I want to know the total CPU time...

GilaMonster (5/6/2011)

---

That's well over what I'd put into a table variable due to the lack of statistics and its effect...

HowardW (5/6/2011)

---

SARGability is the first thing to look for when you think you have a suitable index that isn't used. Once you can see there are no functions etc. being...

Magic! Thank you very much. You identified the problem...

I am attaching the DDL schema for tables company and transactions. For indexes, which of the table here you...