Slightly off topic...

We had the planet argument in our house too. My daughter was just adamant that there were nine planets and Pluto was one of them. She was ripped...

Oh updates to XML... Well, you just update the whole thing. You don't try to modify subsets within the string. Rely on the app to do that heavy lifting here....

Oh believe me, we can nail Betty Jean's hide to the wall with the traces.

Coming to the discussion late...

I've worked both sides of the issue. From the consultant side, things just get gray very quickly. If I know more than anyone on your staff,...

deb (11/8/2007)

---

Suppose i have 250 records. If i tried by the above suggested queries i am getting 3 .All fine. But how to confirm those are the recoeds in 0th...

There are a number of scripts available on this site that will analyze the indexes and perform a defrag or a reindex depending on the level of fragementation. It shouldn't...

Sorry I haven't gotten back to you, I was out of town.

Yeah, that's approximately the format I was thinking of. It's just better when you have 'x' number of potential...

My well is over 700ft down. Can I just add a couple of pipes & use that?

All true.

The reason I'm chasing this down is because on another thread, someone was asking how to parse an XML file out into it's component parts for loading into...

We keep this up and I'll make it really, really scary... I'll take my shirt off

[SHRIEKS]

Thanks.

Much closer to 50/50 which was my initial assumption of worst case (boy was I shocked). I think I'll expand the tests a bit & start looking at actual memory...

Should I tape a full two-hours?

That'd be slightly more interesting than the yule log on TV.

Up in the Peoples Republic of Massachusetts we don't worry too much about cooling the house, but this GeoThermal heating sounds a heck of a lot better than the two...

I'll hazard a wild guess and suggest... compile time. That's one large plan. You can test this by going to a non-production server, run the view to get it to...

SELECT *

FROM Table1

JOIN Table2

ON Table1.Key = Table2.Key

JOIN Table3

ON Table1.Key = Table3.Key

This assumes that the PK on Table1 matches an FK on Table2 & Table3. Either way, you can then use...