Andy DBA (6/2/2015)

---

fundpc (6/2/2015)

---

...and yes I am old enough to have been there when our IBM RD281 disk pack, read heads driven with hydraulic rams, blew a packing and...

Hugo Kornelis (6/2/2015)

---

Alan.B (6/1/2015)

---

Until someone, anyone, can post an example where a cursor or other iterative method was faster than a well-written set-based solution I will remain convinced that the...

Sean Lange (6/2/2015)

---

Alan.B (6/1/2015)

---

You don't.

When you create a primary key you have...

fliteskates (6/1/2015)

---

Eric M Russell (6/1/2015)

---

fliteskates (5/29/2015)

---

Hey all,

I am trying to learn how to use SQL and I have downloaded MSSQL Server 2014 Express. I am a complete beginner with little...

Brian J. Parker (6/1/2015)

---

Alan.B (6/1/2015)

---

So here's what's the takeaway here? It's better for an update to run for several extra seconds to prevent a several hundred ms blip for a...

Brian J. Parker (6/1/2015)

---

Alan.B (6/1/2015)

---

Until someone, anyone, can post an example where a cursor or other iterative method was...

You don't.

When you create a primary key you have the ability to...

ericksrm (6/1/2015)

---

Alan, totally agree with you that "it always comes down to performance". I threw together a quick and dirty example to...

Brian J. Parker (6/1/2015)

---

Alan.B (6/1/2015)

---

Until someone, anyone, can post an example where a cursor or other iterative method was...

Emph. mine.

Sioban Krzywicki (6/1/2015)

---

Is maintaining a complex SQL query more difficult than maintaining a cursor? Sometimes, but in the end, performance is king. The code isn't there to make...

Relative to what? Do you have any examples of a specific problem where a cursor, loop or recursive CTE generates less...

I fall into the "avoid row-by-row operations" camp. Around here that's commonly referred to as RBAR. Itzek Ben-Gan, an well respected author an authority on T-SQL warns against iterative approaches...

fliteskates (5/29/2015)

---

Hey all,

I am trying to learn how to use SQL and I have downloaded MSSQL Server 2014 Express. I am a complete beginner with little experience.

I just downloaded and...

No certs, happy with salary. I don't think not having them has hurt me in any way. If you are new and trying to get your foot in the door...

Haha. Would be even funnier if it weren't so true....