It was introduced in 2008. There just is no equivalent in 2005.

I haven't sat down to a hand-drawn real ale since 1993... so... I hate you all. I hope they have nothing left but Coors.

Luckily brew pubs are all over the...

Absolutely. Plus, I'm lazy. If I can pick something up for trying stuff out, that's what I'm going to do. I know there are lots of complaints about AdventureWorks... it's...

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