that's not a twist, that's a "by design feature" 😀

told you, I was going to spice it a little 😀

Awesome, nice discussion.

Still amazes me how discussions go from point A to point Z, how this one went from the original "GUID or Int is the best for primary key...

I'm in agreement with Paul W that

but... only one way would be elegant and efficient at the same time 😉 ...

Rule #33 says DBA...

Shall we understand "1000K users simultaneously" as in one million concurrent requests to the database?

If yes... call Microsoft and...

Mark (9/12/2009)

---

The problem I'm having is the reciprocity back to the sister/brothers. How can I design a database where there are connections between sister and brothers without it...

Mazharuddin Ehsan (9/11/2009)

---

Let us say I have a flat file containg rows of data and I want to uplaod the file to a database table with an additional column comprising...

I'm giving up :doze:

Question is... why? what's preventing you from moving the files?

Mazharuddin Ehsan (9/9/2009)

---

It is for the OP to tell us what he intends to do with...

Mazharuddin Ehsan (9/9/2009)

---

Here is one way to make it happen in...

Michael Valentine Jones (9/8/2009)

---

You should have suggested simplifying the design further by storing all the data in a single row and column of a single table. Obviously, XML would...

jimk (9/9/2009)

---

Kinda like when you get a flat tire and the shop doesn't have a tire that fits. You can either wait around for a week while they order a...

Error message says the "cursor" is getting invalidated, not any of the underlying objects.

Try...