Jeff Moden (4/1/2014)

---

If you're going to tell people that, then you need to tell them...

Sean Lange (4/2/2014)

---

Ditto 😎

Using stored procedures is a good practice, a) how it retrieves the...

First thing that comes to mind is a disk space or (EDIT) VM max size config kind of problem.

MY_TWO_CENTS

Naming conventions are primarily to enforce consistency, readability and prevent ambiguity. A good solid naming convention is worth hundreds of pages of documentation on a large system.

😎

This should work on 2K5

DECLARE @XML XML = N'<DetailRows>

<DetailRow>

<MonthNumber>1</MonthNumber>

<Amount>1000</Amount>

</DetailRow>

<DetailRow>

<MonthNumber>11</MonthNumber>

...

Correct 😛 found everything about it on BOL under AFD....

Luis Cazares (4/1/2014)

---

I'm not sure that I agree with Eirikur about saying "it depends". I'm sure that cursors are always hard on servers, but some methods can be worse (e.g....

0x42657474657220746F2072656D61696E2073696C656E7420616E642062652074686F75676874206120666F6F6C207468616E20746F20737065616B206F757420616E642072656D6F766520616C6C20646F7562742E

😎

Most of the time cursors can be avoided but it's not a religion, there are tasks which do justify the use of cursors. Obviously if an operation can be achieved...

No worries, but do you have any sample data and table structure? Makes it easier to...

Please post proper DDL and enough data, the problem is straight forward from there.

Hard to tell what is wrong without inspecting the code, can you share it?

Do you have any event handlers configured in the package, sometimes those are overlooked?

Luis Cazares (3/31/2014)

---

Eirikur Eiriksson (3/31/2014)

---

Luis Cazares (3/31/2014)

---

Here are 2 other options.

WITH Contacts AS(

SELECT INS.INSPNO, CNT.FIRSTNAME, CNT.LASTNAME, CNT.CAPACITY,

ROW_NUMBER() OVER( PARTITION BY INS.INSPNO ORDER BY CASE WHEN Capacity = 'Contractor' THEN -1...

dmbaker (3/31/2014)

---

I'm not saying that you should debug the code, I'm saying that you should *insist* that the developers give you the queries being executed when a timeout occurs. Is...