patrickmcginnis59 (2/24/2012)

---

TheSQLGuru (2/24/2012)

---

GilaMonster (2/23/2012)

---

I have seen a case where the hardware was upgraded and the performance went through the floor. Terribly written code, poor design, useless indexes. On the older...

removed redundant post

removed redundant post

TheSQLGuru (2/25/2012)

---

The scenarios I was speaking of is cases where massive IO stalls let to queries doing things like PAGEIOLATCH_xx waits - and thus not actually doing useful work. ...

Brandie Tarvin (2/24/2012)

---

patrickmcginnis59 (2/24/2012)

---

When thinking this through, slowness of the system in my mind brings things closer together instead of keeping things spread apart, as queries lasting longer by inference...

ericb1 (2/24/2012)

---

I get the same error unfortunately. Also, I'm running this as a script in a query window in SQL Server Management Studio. Do I need to execute...

stephen99999 (2/24/2012)

---

Martin Schoombee (2/24/2012)

---

It's a little difficult to say, because we don't know exactly what that second proc is doing...but my somewhat generic advice would be the following:

I would re-write...

ericb1 (2/24/2012)

---

This looks like what I've been trying to show on my SQL server, but I'm getting an error:

Msg 102, Level 15, State 1, Line 17

Incorrect syntax near '?'.

Msg 137,...

TheSQLGuru (2/24/2012)

---

GilaMonster (2/23/2012)

---

I have seen a case where the hardware was upgraded and the performance went through the floor. Terribly written code, poor design, useless indexes. On the older hardware...

SQL Kiwi (2/20/2012)

---

For what it's worth, I didn't really see what Joe was driving at with his example either. It's pretty easy to do what the OP was asking...

SQLKnowItAll (2/20/2012)

---

The OP had this:

select

A,

B,

...

SQLKnowItAll (2/20/2012)

---

patrickmcginnis59 (2/20/2012)

---

SQLKnowItAll (2/20/2012)

---

patrickmcginnis59 (2/20/2012)

---

SQLKnowItAll (2/20/2012)

---

patrickmcginnis59 (2/20/2012)

---

I'm realise I'm posting in an old thread, but I'm genuinely curious about this and maybe someone can point out what I'm missing.

Now try...

SQLKnowItAll (2/20/2012)

---

patrickmcginnis59 (2/20/2012)

---

SQLKnowItAll (2/20/2012)

---

patrickmcginnis59 (2/20/2012)

---

I'm realise I'm posting in an old thread, but I'm genuinely curious about this and maybe someone can point out what I'm missing.

Now try to figure...

SQLKnowItAll (2/20/2012)

---

patrickmcginnis59 (2/20/2012)

---

I'm realise I'm posting in an old thread, but I'm genuinely curious about this and maybe someone can point out what I'm missing.

Now try to figure out the...

I'm realise I'm posting in an old thread, but I'm genuinely curious about this and maybe someone can point out what I'm missing.

Now try to figure out the meaning of...