All of the above is good, but there are a few things you're going to want to know from a technical lead standpoint:

- Your web programmer and database developer have...

Hey Rocky,

If you can put your data into a consumable format like you'll find in the first link of my signature, there's a pretty easy solution using Tally Tables that...

LOL, I should have looked up what re-entrant meant before answering. Oops. 🙂 That'll learn me.

I wasn't thinking in terms of multiple connections, but the same connection re-entering...

Pretty much with Ninja on this one. Light up 'actual execution plans' and take a look at the difference in them.

This parameter: SaveSetIntID='SS20047560'

My guess is when you get to...

raymurphy (5/19/2011)

---

Hope I've explained this clearly enough for someone to come up with a solution. I'm sure I'm

missing an obvious way to go about this, but I'm still nowhere near...

BWAHAHAHAHAHAAHAHAHAHA... sorry, but holy newbie! That really needed to be a...

Grant Fritchey (5/19/2011)

---

No,...

Tried my humble best.

abygaikwad17 (5/19/2011)

---

Hi,

Few things I would like to know (assuming table is not partitioned):

1. Can I access extent or page information related to any particular table?

If so,...

Interesting discussion.

There are really only three reasons to work. To get paid, to volunteer to those less fortunate or educated, or to try to better yourself or your surrounds....

Yeah, that was my first thought Gus, and I found they have the exact same execution plans. I tried it from the other direction, a straight cross join then...

BobA 66314 (5/18/2011)

---

B) Also, you recommend Service Broker for using heavy user traffic. What do you recommend for 5 users initiating database actions that take 10 to 90 seconds...

Fire up a new thread on the...

Brandie Tarvin (5/18/2011)

---

Boys, you should be ashamed of yourselves. Jeff Moden gave us a better way.

DECLARE @MaxTally int;

SELECT @MaxTally = Max(ID) FROM dbo.Combinations;

SELECT c.ID, t.N AS TallyID

FROM dbo.Combinations c

CROSS JOIN...

All I've got is an equivalent method that uses joins/ons instead of leaving it all in the WHERE clause, but it's the same execution plan. Subquery had the same...