Garadin (1/25/2009)

---

OK, I'll bite. What the heck is goin on there? I've looked at it a few times, and it's not making any more sense than the first...

GilaMonster (1/25/2009)

---

🙂 I'm busy witting a correction to one of his posts now. "Correlated subquery, inner query is...

So here's my code using the SELECT pseudocursor hot-wired to act like an UPDATE pseudocursor, plus every trick I could think of to remedy the problem of SQL string aggregation:

Set...

OK, I decided that I wanted to test this with a substantial sized dataset. Here is the script to generate apprx 1 million rows:

Drop Table TestPCursors

go

CREATE TABLE TestPCursors

...

Goldie Graber (1/24/2009)

---

GilaMonster (1/24/2009)

---

I guess that's because Gail is used...

Jeff Moden (1/24/2009)

---

hemin.shah85 (1/24/2009)

---

Jeff you are right. With(index(0)) works really fast...as I have a dataset of 6 million records..Thanks for your help..But I was thinking, can we do this without...

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 a...

Another option is to purchase bandwidth on the trans-pacific cable. This should cut your developers' perceived response latency about in half which may be enough to placate them. ...

I have lots of suggestions, but they will not meet your requirements.

The thing that comes the closest is merge replication, but it is going to have difficulty keeping 20GB of...

hemin.shah85 (1/24/2009)

---

Jeff you are right. With(index(0)) works really fast...as I have a dataset of 6 million records..Thanks for your help..But I was thinking, can we do this without updating that...

Hmmm, I never thought of that....

Good to know, thanks.

Jeff Moden (1/23/2009)

---

Goldie Graber (1/23/2009)

---

Nope, it's Goldie. 🙂 I think I'm going to change my user name.

And, thanks... that's one of the...

Why SP2? I thought that Login Triggers have...

barbararyan (1/23/2009)

---

The supertype table Persons has several "child" tables containing information (e.g., contact information) that applies to all "persons" -- both employees and non-employees.

However, subtype table Employees has...