The Beer Cooler Thread

Question

The Beer Cooler Thread

Viewing 15 posts - 61 through 75 (of 170 total)

You must be logged in to reply to this topic. Login to reply

ChrisM@Work SSC Guru Points: 186127 More actions · Answer 1

L' Eomot Inversé (5/31/2012)
I drink some Dunkelweizen whenever I'm in Munich, ideally Schneider's Aventinus but it's not too much of a disaster if I accidentally go somewhere where they have Erdinger instead.
Here in Puerto del Carmen for beer I mostly drink Guinness.
And when in the UK I drink many different beers. One of the nicest is Fraoch.
Pictures attached.
I decide not to use the first guiness picture google turned up - it's http://4.bp.blogspot.com/-UWPtv2sE_x4/TlvXYDhieUI/AAAAAAAAAQU/LkCUC_2W_dQ/s1600/guiness.JPG for the curious.

Fraoch Heather Ale used to be available from Oddbins and the ale stall in Borough Market. From the bottle, it's very strange-tasting, like strong ale filtered through compost. Didn't like it at all, but I don't like Hobgoblin from the bottle either and it's very popular. On draught, it's gorgeous.

^{“Write the query the simplest way. If through testing it becomes clear that the performance is inadequate, consider alternative query forms.” - Gail Shaw}

For fast, accurate and documented assistance in answering your questions, please read this article.
Understanding and using APPLY, (I) and (II) Paul White
Hidden RBAR: Triangular Joins / The "Numbers" or "Tally" Table: What it is and how it replaces a loop Jeff Moden

ChrisM@Work SSC Guru Points: 186127 More actions · Answer 2

John Mitchell-245523 (6/1/2012)
I think frites have been adopted by Belgium as its own national delicacy. Indeed, there's a song in the Europop tradition (sung in English) called It's Great to be a Belgian, with the following lines:
As I walk along the streets with my mayonnaise and frites
You can tell I'm as happy as can be
With my Duvel in my hand then you must understand
I'm a Belgian so nothing worries me
John

On their own? No moules?

It amazes me how a country with such a limited coastline should adopt a marine animal as it's national dish. Assuming moules et frites is the national dish...

^{“Write the query the simplest way. If through testing it becomes clear that the performance is inadequate, consider alternative query forms.” - Gail Shaw}

For fast, accurate and documented assistance in answering your questions, please read this article.
Understanding and using APPLY, (I) and (II) Paul White
Hidden RBAR: Triangular Joins / The "Numbers" or "Tally" Table: What it is and how it replaces a loop Jeff Moden

Koen Verbeeck SSC Guru Points: 259197 More actions · Answer 3

ChrisM@Work (6/1/2012)
John Mitchell-245523 (6/1/2012)
I think frites have been adopted by Belgium as its own national delicacy. Indeed, there's a song in the Europop tradition (sung in English) called It's Great to be a Belgian, with the following lines:
As I walk along the streets with my mayonnaise and frites
You can tell I'm as happy as can be
With my Duvel in my hand then you must understand
I'm a Belgian so nothing worries me
John
On their own? No moules?
It amazes me how a country with such a limited coastline should adopt a marine animal as it's national dish. Assuming moules et frites is the national dish...

French fries (or fritten as we call them) are often eaten alone or with a variety of snacks (usually fried meat, if you can call it meat).

Moules and French fries are popular in Belgium, but to call it the national, I would'nt go that far.

Actually, the best moules - Zeeuwse moules - are imported from the Netherlands.

Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP

Sean Lange SSC Guru Points: 286609 More actions · Answer 4

I also heard it's been called the "wifebeater" in America because it makes the rednecks too drunk

ROFL!!! Now that is an urban myth over there. There are two major flaws with this concept. First, no self respecting redneck would drink "some fancy European beer". Secondly, the name is entirely too difficult to say. Why do you think "Bud" is popular in that crowd? Sadly even Bud and its ilk (there are tons of "beers" here in the states far worse than Bud if you can believe it) get the rednecks too drunk.

_______________________________________________________________

Need help? Help us help you.

Read the article at http://www.sqlservercentral.com/articles/Best+Practices/61537/ for best practices on asking questions.

Need to split a string? Try Jeff Modens splitter http://www.sqlservercentral.com/articles/Tally+Table/72993/.

Cross Tabs and Pivots, Part 1 – Converting Rows to Columns - http://www.sqlservercentral.com/articles/T-SQL/63681/
Cross Tabs and Pivots, Part 2 - Dynamic Cross Tabs - http://www.sqlservercentral.com/articles/Crosstab/65048/
Understanding and Using APPLY (Part 1) - http://www.sqlservercentral.com/articles/APPLY/69953/
Understanding and Using APPLY (Part 2) - http://www.sqlservercentral.com/articles/APPLY/69954/

Ant-Green SSC Guru Points: 113563 More actions · Answer 5

I shall say this now before I forget, happy 4 day weekend to all in the UK, time to drink copious amounts of alcohol.

ChrisM@Work SSC Guru Points: 186127 More actions · Answer 6

anthony.green (6/1/2012)
I shall say this now before I forget, happy 4 day weekend to all in the UK, time to drink copious amounts of alcohol.

Oh yes! You too Anthony.

Three days of beer and longbow.

^{“Write the query the simplest way. If through testing it becomes clear that the performance is inadequate, consider alternative query forms.” - Gail Shaw}

For fast, accurate and documented assistance in answering your questions, please read this article.
Understanding and using APPLY, (I) and (II) Paul White
Hidden RBAR: Triangular Joins / The "Numbers" or "Tally" Table: What it is and how it replaces a loop Jeff Moden

Andy Hyslop SSCrazy Eights Points: 9198 More actions · Answer 7

I shall say this now before I forget, happy 4 day weekend to all in the UK, time to drink copious amounts of alcohol

Have a good one 🙂

Think I'll give some of the beers on this thread a go!

😀 😀 😀 😀 :sick:

==========================================================================================================================
A computer lets you make more mistakes faster than any invention in human history - with the possible exceptions of handguns and tequila. Mitch Ratcliffe

Ant-Green SSC Guru Points: 113563 More actions · Answer 8

Andy Hyslop (6/1/2012)
I shall say this now before I forget, happy 4 day weekend to all in the UK, time to drink copious amounts of alcohol
Have a good one 🙂
Think I'll give some of the beers on this thread a go!
😀 😀 😀 😀 :sick:

1 tequila, 2 tequila, 3 tequila, floor

SQLBill SSC Guru Points: 51440 More actions · Answer 9

Not fair Anthony...tequila is my favorite drink. At four, I'm ususally just getting started.

BTW - check out Tom T. Hall's song I Like Beer:

http://www.cowboylyrics.com/lyrics/hall-tom-t/i-like-beer-12416.html

There's also a few YouTube videos of him singing it.

-SQLBill

Revenant SSC-Forever Points: 42467 More actions · Answer 10

SQLBill (6/1/2012)
Not fair Anthony...tequila is my favorite drink. At four, I'm ususally just getting started. . . .

Just continue the count, and it will get you floored in due order. 😀

TomThomson SSC Guru Points: 104768 More actions · Answer 11

SQLBill (6/1/2012)
Not fair Anthony...tequila is my favorite drink. At four, I'm ususally just getting started.

After floor, the next bits are "5 tequila, 6 tequila, 7 tequila, more"

Then it starts again from the beginning.

Many people fall down the second time "floor" is reached.

edit: after fouloor coul~~n't~~dn't spell "65"

Tom

Jeff Moden SSC Guru Points: 1004638 More actions · Answer 12

Sean Lange (6/1/2012)
I also heard it's been called the "wifebeater" in America because it makes the rednecks too drunk
ROFL!!! Now that is an urban myth over there. There are two major flaws with this concept. First, no self respecting redneck would drink "some fancy European beer". Secondly, the name is entirely too difficult to say. Why do you think "Bud" is popular in that crowd? Sadly even Bud and its ilk (there are tons of "beers" here in the states far worse than Bud if you can believe it) get the rednecks too drunk.

I have an incredibly sophisticated palate when it comes to beer. My tongue knows how to throw a party for my mouth. If someone hands me an open beer, I'll drink it. If it doesn't taste good, I'll spit it out and then look for someone at the party who hasn't just spit theirs out and ask them what they're drinking. 😉

Heh... everyone picks on BUD. Is it the best beer in the world? Not even close but I'll have you know that I've never spit out a BUD even if it's too warm. 😀

--Jeff Moden

RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
First step towards the paradigm shift of writing Set Based code:
________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.

Change is inevitable... Change for the better is not.

Helpful Links:
How to post code problems
How to Post Performance Problems
Create a Tally Function (fnTally)

Koen Verbeeck SSC Guru Points: 259197 More actions · Answer 13

So I had this lovely beer this weekend:

It's Grimbergen aka "the beer of the feniks" in it's blonde version.

It's an abbey beer and brewed by Alken Maes (not really my favorite brewery and it seems they were bought by Heineken.)

http://en.wikipedia.org/wiki/Grimbergen_(beer)

For the ones up to it, the Dutch wiki version has a better description 😀

Not the one I usually drink, but there was a sale of them at the supermarket, so I grabbed a whole bunch of them 😀

Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP

Jeff Moden SSC Guru Points: 1004638 More actions · Answer 14

Koen Verbeeck (6/4/2012)
So I had this lovely beer this weekend:
It's Grimbergen aka "the beer of the feniks" in it's blonde version.
It's an abbey beer and brewed by Alken Maes (not really my favorite brewery and it seems they were bought by Heineken.)
http://en.wikipedia.org/wiki/Grimbergen_(beer)
For the ones up to it, the Dutch wiki version has a better description 😀
Not the one I usually drink, but there was a sale of them at the supermarket, so I grabbed a whole bunch of them 😀

Looks like a Budweiser in a really cool glass. You didn't spit it out did you? 😛

--Jeff Moden

RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
First step towards the paradigm shift of writing Set Based code:
________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.

Change is inevitable... Change for the better is not.

Helpful Links:
How to post code problems
How to Post Performance Problems
Create a Tally Function (fnTally)

ACinAZ SSCommitted Points: 1849 More actions · Answer 15

How 'bout Sammy (Samuel) Smith's Oatmeal Stout? Around here (Kansas City), Freestate Brewing (Lawrence, KS) has an Oatmeal Stout that is really good, too (and a nice restaurant right on Mass Street to enjoy it in!).

A friend I used to work with created a sorghum-based beer called Bard's Beer that's good, especially if you're a celiac and can't drink other grain-based beers. I like it because it doesn't inflame my metabolic arthritis (AKA gout) the way most non-amber, non-stout types (like the swill that comes from St. Louis and Milwaukee) do.