I believe that the reason you're not getting any bites on this problem is that most people don't want to work so hard trying to test your data. Please...

Gosh... there's a thousand reasons. Here's some of the biggest reasons for me...

Server Audits

Database Audits

Performance Data Collection

Resource Governor Improvements

SQL Server Change Tracking (above and beyond Database Audits)

PARTITION TABLE Parallelism

Data...

RBarryYoung (1/24/2009)

---

Just to clarify my earlier response to Hemin's question: I was assuming that he was asking about using SELECT pseudocursors to do this. There are of course lots...

There are no guarantees that what you're doing will stay small and there are no guarantees that someone won't look at that RBAR code and decide it's ok for them...

george sibbald (1/24/2009)

---

so go to the interviews and tell them the above but be prepared to back it up. But be careful about going in there saying you are as...

bjesmith2 (1/23/2009)

---

Hi,

I'm new to t-sql and I do not know much regarding how to write efficient queries.

I read an article which referred to RBAR and set based programming (I...

Heh... understood and thanks. I was picking on you a bit I don't...

RBarryYoung (1/24/2009)

---

Heh. You know, I always have to follow these links to make sure that you aren't talking about me. Thank goodness too, I prefer my pork chops...

Brian, that's absolutely awesome. I couldn't have said it better myself. Thank you. And thanks for putting up with me on that post "a while back". ...

Michael Earl (1/24/2009)

---

I am a big believer in "Le mieux est l'ennemi du bien" - for many one-time, small-record count operations I often use RBAR solutions just to get things...

seekwell_fan (1/24/2009)

---

Hi, guys!

Thank you all for your advises. I appreciated all of them

I can't answer to each of you, so I would like to answer only for some common ideas.

First,...

200 MB is too small for a TempDB, anyway. Shoot... I START my servers with a 9GB TempDB.

There are several things that can cause TempDB to get so large......

You're not listening.... several...

Don't use any type of "INT" if you want decimal answers.

There's a thousand things that can cause that to happen. Find...