There's a decent, but inexpensive, single malt scotch called Sheep Dip. Great stuff.

Chris Morris (3/20/2009)

---

Yes they can do! Check out Rogue Ales[/url], sometimes found in Oddbins, also found at the beer stall at Borough Market (perilously close to the fantastic Market Porter...

Luke L (3/20/2009)

---

There are an incredible range of names for beers here in the US from funny and silly, to bordering on offensive... I know of a few due...

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.