Dev (11/17/2011)

---

Sean Lange (11/17/2011)

---

Dev (11/17/2011)

---

Ninja's_RGR'us (11/17/2011)

---

Tom Brown (11/17/2011)

---

It has to be oversized, have you seen his list of qualifications - not sure I understand most...

One of the reasons I like this forum because its generally good-natured and troll free. Of course this could be because we're not discussing politics or religion.

From my extensive...

Ah ha

No offence intended GS 😉

But I see you have deleted yours quals list Ninja (if you ever joined that game) - I'm sure you would be perfectly within your...

It has to be oversized, have you seen his list of qualifications - not sure I understand most of them but I'd like to be a qualified ROFL too 😀

Try this

select SUM(CASE WHEN T4.Name LIKE '%D%' THEN T4.U_SYS_TOTN/1.16 ELSE 0 END) AS 'DEV',

SUM(CASE WHEN T4.NAME LIKE '%N%' THEN T4.U_SYS_TOTN/1.16 ELSE 0 END) AS 'NC', T5.Code

from [@SYS_PDEVOLUCIONES] T4

LEFT OUTER JOIN...

I need to read up on SNAPSHOT stuff, as it could be a great benefit to some of the stuff we do.

As I understand it - correct me if I'm...

And I'm not going to try to get the actual execution plan of a while loop process again!! - big mistake.

Thanks for the offer.

My timings are for a developer machine - it generally takes around 50/60 seconds in production

And I know why its slow.

There is an update to a...

I've tested and Its definitely quicker with some of the @table variables converted to #tmp tables (the ones that are reused in joins) - I then added indexes on the...

I can't post the code - aside from the security issues, its 630 lines and contains selects and joins on 10 or 12 other tables.

How do I get...

OK I've read and inwardly digested the link. :blush:

Seems like SNAPSHOT Read committed is one way to go. However if I investigate this and find is what we want,...

OK GSquared. Now you have me worried.

I use WITH (NOLOCK) extensively - not as a go-faster thing, but to avoid having to wait for locks to clear before getting...

Ninja's_RGR'us (11/14/2011)

---

Aside from identity, why does the order by of the insert matters?

If you want order in the subsequent selects, you HAVE TO specify ORDER BY in the...

I thought as much. Many thanks.

In England its 'my twopenneth' - usually meaning you've had a rant at someone and given them much more opinion than they really wanted.

'My twopennth' is given freely...