For a many-to-many relationship... No. Not for a true one. Any relationship between two tables including referential integrity, can't allow for X number of relationships between the two.

Chad Crawford (3/20/2009)

---

I have a dirty diaper, will that work? Rolled up it has some good heft, left open it can subdue a crowd... and my supply seems limitless.

(RE:...

That covers the bare bones basics. You might pick up a copy of TSQL-Querying by Itzik Ben Gan for more. Also SQL Server Internals by Kalen Delaney is a must.

It sure sounds like a classic case of parameter sniffing. You can do a search for that phrase and see all kinds of different solutions. I'd suggest using a variable...

I wouldn't support this approach because you're likely to get non-unique data. Better to use the whole guid and be sure you have a real PK. However, using GUID's has...

It really depends on your system, but you could look at the cache to determine if updates have been run. It will only work if the queries are still in...

I'm really not aware of "excercises" that you can do with any of the sample databases.

If it helps at all, and I doubt it does, both my books use AdventureWorks...

A many-to-many relationship consists of three tables. Parent TableA, parent TableB, and the table that connects the two. This is not code, but describes the three tables:

TableA

TableAId int (PK)

Desc nvarchar(50)

UpdateDate......

Going after the tweeterers for the answer?

Now I'm curious too.

I left out a few things:

Cricket bat, hockey stick, bludgeoning devices of all kinds, light sabre's, blasters, fiber optic laser beam assemblers, fiber optic laser beam disassemblers, death stars, a...

Chad Crawford (3/19/2009)

---

You are more than welcome to The Thread. We all started with little knowledge and we all still have people who know more than we do.

I have...

Oh yeah. We did a lot of tests to see if we could put GUID to work. It made developers lives easier, but it really seriously impacted the database. I...

I have several issues with GUID's as clustered indexes. First, they're very wide. This means fewer per page and more pages per index, making them somewhat less efficient. That's a...

I don't think Gail and I are in disagreement here. You need a clustered index on these tables, however, a primary key of GUID is not the best choice, and...

nabajyoti.b (3/19/2009)

---

i have table table1 with two columns col1,col2

my statement is insert table1 values('dummy',xyz)

where xyz is a variable and i want to put some values in a loop for...