WayneS (6/10/2009)

---

Hey gang,

A reader of my article today asked a very good question that I'm not sure what the answer would be. I'm hoping that someone along the likes of...

t_king (6/11/2009)

---

So if I have 3 tables with the following number of rows 7949, 837, 1848 and their respective logical reads in the query are 52, 58, and 144. So...

Based on the research and testing I've done with it, it's unlikely to cause much negative impact. It's also unlikely to cause much positive impact except in special circumstances. I'm...

YSLGuru (6/10/2009)

---

Thanks for the input but after spending a couple of hours (yet again) on Powershell, persuing the Microsoft PS specific sites & Googleing on PowerShell for sample code on...

RBarryYoung (6/10/2009)

---

Oh my, no. At StackOverflow the correct answer is to psychically determine what the OP meant and what their actual situation is and what their goals are. ...

How you can not be sure? Microsoft may be a large,...

A dump is just a backup. They're EXACTLY the same thing. Dump is just old terminology. I wouldn't do it for them. I get really, really, pissy when people demand...

When you're testing, take a look at the estimated rows for the actual values and the variables. I suspect you'll see substantial differences. For the variables you'll see an average...

Grant Fritchey (6/10/2009)

---

Lynn Pettis (6/10/2009)

---

MarkusB (6/10/2009)

---

Grant Fritchey (6/10/2009)

---

I can't read minds, but I can see the future...

I see... I see... a dba-wanna-be...

Lynn Pettis (6/10/2009)

---

MarkusB (6/10/2009)

---

Grant Fritchey (6/10/2009)

---

I can't read minds, but I can see the future...

I see... I see... a dba-wanna-be on the...

WayneS (6/10/2009)

---

I wrote the article in Word, and I had asked Steve to include it...

Grumpy DBA (6/10/2009)

---

I use one of the names people call me, some of the others are not printable under the current decency laws.

Developer 1: "Hey, it's almost quitting...

Actually, based on what you describe, I'm not sure I'd use SSIS to do the job. I think I'd drop out to PowerShell to manage this. If you do it...

Yes, getting that many updates into a single statement is the best mechanism. You should experiment between using XQuery directly on the XML and loading the data into a temporary...

Percentage costs are based on the estimated costs and as Christopher pointed out, estimated costs are just that, estimated. They're based on the statistics available to the optimizer and are...