Are the posted questions getting worse?

  • ChrisM@Work (10/1/2015)


    Eirikur Eiriksson (10/1/2015)


    ChrisM@Work (10/1/2015)


    Eirikur Eiriksson (10/1/2015)


    ChrisM@Work (10/1/2015)


    Eirikur Eiriksson (10/1/2015)


    ChrisM@Work (10/1/2015)


    Oh, and maple beer - yuck.

    This made me spill my ESB all over the Pub lunch

    😎

    Where have you found ESB on draught?

    The Ale&Pie on High Holborn, next to my office

    😎

    Live 5 minutes from Chiswick so there is no shortage in the locals either.

    The Melton Mowbray? Haven't been in there for a while. The nearest gig was a telecoms company in Red Lion Square, maybe 12 years ago. We used to have Friday afternoon meetings in the Dolphin πŸ˜‰

    Edit: High Holborn is a mile from where I currently work.

    Good catch Chris, yes that's the one.

    So working only 10 minutes away from each other, where and when are we going to meet?

    😎

    There are two pubs almost opposite each other on Tottenham Court Road about 150 yards up from TCR tube station. One of them's called the Jack Horner. The one on the west side does amazing pies, the one on the east side has exceptional ESB. You choose πŸ™‚

    The Rising Sun and Jack Horner, not "too" unfamiliar πŸ˜‰

    Lets make it Jack Horner, now the question is when?

    😎

  • Eirikur Eiriksson (10/1/2015)


    ChrisM@Work (10/1/2015)


    Eirikur Eiriksson (10/1/2015)


    ChrisM@Work (10/1/2015)


    Eirikur Eiriksson (10/1/2015)


    ChrisM@Work (10/1/2015)


    Eirikur Eiriksson (10/1/2015)


    ChrisM@Work (10/1/2015)


    Oh, and maple beer - yuck.

    This made me spill my ESB all over the Pub lunch

    😎

    Where have you found ESB on draught?

    The Ale&Pie on High Holborn, next to my office

    😎

    Live 5 minutes from Chiswick so there is no shortage in the locals either.

    The Melton Mowbray? Haven't been in there for a while. The nearest gig was a telecoms company in Red Lion Square, maybe 12 years ago. We used to have Friday afternoon meetings in the Dolphin πŸ˜‰

    Edit: High Holborn is a mile from where I currently work.

    Good catch Chris, yes that's the one.

    So working only 10 minutes away from each other, where and when are we going to meet?

    😎

    There are two pubs almost opposite each other on Tottenham Court Road about 150 yards up from TCR tube station. One of them's called the Jack Horner. The one on the west side does amazing pies, the one on the east side has exceptional ESB. You choose πŸ™‚

    The Rising Sun and Jack Horner, not "too" unfamiliar πŸ˜‰

    Lets make it Jack Horner, now the question is when?

    😎

    That's them! The Rising Sun has the pies πŸ™‚

    Late next week - lunchtime or a couple of pints after work?

    β€œ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

  • David Burrows (10/1/2015)


    ChrisM@Work (10/1/2015)


    Eirikur Eiriksson (10/1/2015)


    ChrisM@Work (10/1/2015)


    Oh, and maple beer - yuck.

    This made me spill my ESB all over the Pub lunch

    😎

    Where have you found ESB on draught?

    Many many moons ago when I frequented London pubs it was either RamRod and Special or 80/- Heavy

    Haven't seen RamRod on a tab for ages, in fact many ages:-P

    😎

  • ChrisM@Work (10/1/2015)


    Eirikur Eiriksson (10/1/2015)


    ChrisM@Work (10/1/2015)


    Eirikur Eiriksson (10/1/2015)


    ChrisM@Work (10/1/2015)


    Eirikur Eiriksson (10/1/2015)


    ChrisM@Work (10/1/2015)


    Eirikur Eiriksson (10/1/2015)


    ChrisM@Work (10/1/2015)


    Oh, and maple beer - yuck.

    This made me spill my ESB all over the Pub lunch

    😎

    Where have you found ESB on draught?

    The Ale&Pie on High Holborn, next to my office

    😎

    Live 5 minutes from Chiswick so there is no shortage in the locals either.

    The Melton Mowbray? Haven't been in there for a while. The nearest gig was a telecoms company in Red Lion Square, maybe 12 years ago. We used to have Friday afternoon meetings in the Dolphin πŸ˜‰

    Edit: High Holborn is a mile from where I currently work.

    Good catch Chris, yes that's the one.

    So working only 10 minutes away from each other, where and when are we going to meet?

    😎

    There are two pubs almost opposite each other on Tottenham Court Road about 150 yards up from TCR tube station. One of them's called the Jack Horner. The one on the west side does amazing pies, the one on the east side has exceptional ESB. You choose πŸ™‚

    The Rising Sun and Jack Horner, not "too" unfamiliar πŸ˜‰

    Lets make it Jack Horner, now the question is when?

    😎

    That's them! The Rising Sun has the pies πŸ™‚

    Late next week - lunchtime or a couple of pints after work?

    Thursday next week, Pie lunch in the Rising Sun, my treat

    😎

  • Eirikur Eiriksson (10/1/2015)


    ChrisM@Work (10/1/2015)


    Eirikur Eiriksson (10/1/2015)


    ChrisM@Work (10/1/2015)


    Eirikur Eiriksson (10/1/2015)


    ChrisM@Work (10/1/2015)


    Eirikur Eiriksson (10/1/2015)


    ChrisM@Work (10/1/2015)


    Eirikur Eiriksson (10/1/2015)


    ChrisM@Work (10/1/2015)


    Oh, and maple beer - yuck.

    This made me spill my ESB all over the Pub lunch

    😎

    Where have you found ESB on draught?

    The Ale&Pie on High Holborn, next to my office

    😎

    Live 5 minutes from Chiswick so there is no shortage in the locals either.

    The Melton Mowbray? Haven't been in there for a while. The nearest gig was a telecoms company in Red Lion Square, maybe 12 years ago. We used to have Friday afternoon meetings in the Dolphin πŸ˜‰

    Edit: High Holborn is a mile from where I currently work.

    Good catch Chris, yes that's the one.

    So working only 10 minutes away from each other, where and when are we going to meet?

    😎

    There are two pubs almost opposite each other on Tottenham Court Road about 150 yards up from TCR tube station. One of them's called the Jack Horner. The one on the west side does amazing pies, the one on the east side has exceptional ESB. You choose πŸ™‚

    The Rising Sun and Jack Horner, not "too" unfamiliar πŸ˜‰

    Lets make it Jack Horner, now the question is when?

    😎

    That's them! The Rising Sun has the pies πŸ™‚

    Late next week - lunchtime or a couple of pints after work?

    Thursday next week, Pie lunch in the Rising Sun, my treat

    😎

    Followed by a pint in the Jack Horner, my treat πŸ™‚

    β€œ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 (10/1/2015)


    Eirikur Eiriksson (10/1/2015)


    ChrisM@Work (10/1/2015)


    Eirikur Eiriksson (10/1/2015)


    ChrisM@Work (10/1/2015)


    Eirikur Eiriksson (10/1/2015)


    ChrisM@Work (10/1/2015)


    Eirikur Eiriksson (10/1/2015)


    ChrisM@Work (10/1/2015)


    Eirikur Eiriksson (10/1/2015)


    ChrisM@Work (10/1/2015)


    Oh, and maple beer - yuck.

    This made me spill my ESB all over the Pub lunch

    😎

    Where have you found ESB on draught?

    The Ale&Pie on High Holborn, next to my office

    😎

    Live 5 minutes from Chiswick so there is no shortage in the locals either.

    The Melton Mowbray? Haven't been in there for a while. The nearest gig was a telecoms company in Red Lion Square, maybe 12 years ago. We used to have Friday afternoon meetings in the Dolphin πŸ˜‰

    Edit: High Holborn is a mile from where I currently work.

    Good catch Chris, yes that's the one.

    So working only 10 minutes away from each other, where and when are we going to meet?

    😎

    There are two pubs almost opposite each other on Tottenham Court Road about 150 yards up from TCR tube station. One of them's called the Jack Horner. The one on the west side does amazing pies, the one on the east side has exceptional ESB. You choose πŸ™‚

    The Rising Sun and Jack Horner, not "too" unfamiliar πŸ˜‰

    Lets make it Jack Horner, now the question is when?

    😎

    That's them! The Rising Sun has the pies πŸ™‚

    Late next week - lunchtime or a couple of pints after work?

    Thursday next week, Pie lunch in the Rising Sun, my treat

    😎

    Followed by a pint in the Jack Horner, my treat πŸ™‚

    That's a "meal deal" then

    😎

  • Grant Fritchey (10/1/2015)


    Eirikur Eiriksson (10/1/2015)


    ChrisM@Work (10/1/2015)


    Oh, and maple beer - yuck.

    This made me spill my ESB all over the Pub lunch

    😎

    However, Maple Whiskey... YUM! Specifically though, when you use it in a hot drink like apple cider or a hot toddy.

    Hmm. Grant, talking about a hot toddy. What part of this just doesn't sit right in my mind?:-D

    Wayne
    Microsoft Certified Master: SQL Server 2008
    Author - SQL Server T-SQL Recipes


    If you can't explain to another person how the code that you're copying from the internet works, then DON'T USE IT on a production system! After all, you will be the one supporting it!
    Links:
    For better assistance in answering your questions
    Performance Problems
    Common date/time routines
    Understanding and Using APPLY Part 1 & Part 2

  • Eirikur Eiriksson (10/1/2015)


    ChrisM@Work (10/1/2015)


    Eirikur Eiriksson (10/1/2015)


    ChrisM@Work (10/1/2015)


    Eirikur Eiriksson (10/1/2015)


    ChrisM@Work (10/1/2015)


    Eirikur Eiriksson (10/1/2015)


    ChrisM@Work (10/1/2015)


    Eirikur Eiriksson (10/1/2015)


    ChrisM@Work (10/1/2015)


    Eirikur Eiriksson (10/1/2015)


    ChrisM@Work (10/1/2015)


    Oh, and maple beer - yuck.

    This made me spill my ESB all over the Pub lunch

    😎

    Where have you found ESB on draught?

    The Ale&Pie on High Holborn, next to my office

    😎

    Live 5 minutes from Chiswick so there is no shortage in the locals either.

    The Melton Mowbray? Haven't been in there for a while. The nearest gig was a telecoms company in Red Lion Square, maybe 12 years ago. We used to have Friday afternoon meetings in the Dolphin πŸ˜‰

    Edit: High Holborn is a mile from where I currently work.

    Good catch Chris, yes that's the one.

    So working only 10 minutes away from each other, where and when are we going to meet?

    😎

    There are two pubs almost opposite each other on Tottenham Court Road about 150 yards up from TCR tube station. One of them's called the Jack Horner. The one on the west side does amazing pies, the one on the east side has exceptional ESB. You choose πŸ™‚

    The Rising Sun and Jack Horner, not "too" unfamiliar πŸ˜‰

    Lets make it Jack Horner, now the question is when?

    😎

    That's them! The Rising Sun has the pies πŸ™‚

    Late next week - lunchtime or a couple of pints after work?

    Thursday next week, Pie lunch in the Rising Sun, my treat

    😎

    Followed by a pint in the Jack Horner, my treat πŸ™‚

    That's a "meal deal" then

    😎

    You can pick one up by the tube station if you really want!! :hehe:

    β€œ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

  • WayneS (10/1/2015)


    Grant Fritchey (10/1/2015)


    Eirikur Eiriksson (10/1/2015)


    ChrisM@Work (10/1/2015)


    Oh, and maple beer - yuck.

    This made me spill my ESB all over the Pub lunch

    😎

    However, Maple Whiskey... YUM! Specifically though, when you use it in a hot drink like apple cider or a hot toddy.

    Hmm. Grant, talking about a hot toddy. What part of this just doesn't sit right in my mind?:-D

    Flaming rum punch? Glogg?

    "The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
    - Theodore Roosevelt

    Author of:
    SQL Server Execution Plans
    SQL Server Query Performance Tuning

  • ChrisM@Work (10/1/2015)


    David Burrows (10/1/2015)


    ChrisM@Work (10/1/2015)


    Eirikur Eiriksson (10/1/2015)


    ChrisM@Work (10/1/2015)


    Oh, and maple beer - yuck.

    This made me spill my ESB all over the Pub lunch

    😎

    Where have you found ESB on draught?

    Many many moons ago when I frequented London pubs it was either RamRod and Special or 80/- Heavy

    Gosh David you must be an old git too!

    'fraid so, very old :w00t:

    These days I get bottled RamRod and Special as an occasional treat πŸ™‚

    Far away is close at hand in the images of elsewhere.
    Anon.

  • Eirikur Eiriksson (10/1/2015)


    ChrisM@Work (10/1/2015)


    Eirikur Eiriksson (10/1/2015)


    ChrisM@Work (10/1/2015)


    Eirikur Eiriksson (10/1/2015)


    ChrisM@Work (10/1/2015)


    Eirikur Eiriksson (10/1/2015)


    ChrisM@Work (10/1/2015)


    Eirikur Eiriksson (10/1/2015)


    ChrisM@Work (10/1/2015)


    Eirikur Eiriksson (10/1/2015)


    ChrisM@Work (10/1/2015)


    Oh, and maple beer - yuck.

    This made me spill my ESB all over the Pub lunch

    😎

    Where have you found ESB on draught?

    The Ale&Pie on High Holborn, next to my office

    😎

    Live 5 minutes from Chiswick so there is no shortage in the locals either.

    The Melton Mowbray? Haven't been in there for a while. The nearest gig was a telecoms company in Red Lion Square, maybe 12 years ago. We used to have Friday afternoon meetings in the Dolphin πŸ˜‰

    Edit: High Holborn is a mile from where I currently work.

    Good catch Chris, yes that's the one.

    So working only 10 minutes away from each other, where and when are we going to meet?

    😎

    There are two pubs almost opposite each other on Tottenham Court Road about 150 yards up from TCR tube station. One of them's called the Jack Horner. The one on the west side does amazing pies, the one on the east side has exceptional ESB. You choose πŸ™‚

    The Rising Sun and Jack Horner, not "too" unfamiliar πŸ˜‰

    Lets make it Jack Horner, now the question is when?

    😎

    That's them! The Rising Sun has the pies πŸ™‚

    Late next week - lunchtime or a couple of pints after work?

    Thursday next week, Pie lunch in the Rising Sun, my treat

    😎

    Followed by a pint in the Jack Horner, my treat πŸ™‚

    That's a "meal deal" then

    😎

    Please do at least one wrist curl for me as my spirit will be with you!


    My mantra: No loops! No CURSORs! No RBAR! Hoo-uh![/I]

    My thought question: Have you ever been told that your query runs too fast?

    My advice:
    INDEXing a poor-performing query is like putting sugar on cat food. Yeah, it probably tastes better but are you sure you want to eat it?
    The path of least resistance can be a slippery slope. Take care that fixing your fixes of fixes doesn't snowball and end up costing you more than fixing the root cause would have in the first place.

    Need to UNPIVOT? Why not CROSS APPLY VALUES instead?[/url]
    Since random numbers are too important to be left to chance, let's generate some![/url]
    Learn to understand recursive CTEs by example.[/url]
    [url url=http://www.sqlservercentral.com/articles/St

  • I'm headed to SQL Saturday Pittsburgh this weekend. I'll be my first visit to this location, but I've heard good things about it.

    If anyone lives in the area, the sessions are listed at http://www.sqlsaturday.com/440/.

  • Ed Wagner (10/1/2015)


    I'm headed to SQL Saturday Pittsburgh this weekend. I'll be my first visit to this location, but I've heard good things about it.

    If anyone lives in the area, the sessions are listed at http://www.sqlsaturday.com/440/.

    Grumble Grumble

    Wishing I could be there.

    Jason...AKA CirqueDeSQLeil
    _______________________________________________
    I have given a name to my pain...MCM SQL Server, MVP
    SQL RNNR
    Posting Performance Based Questions - Gail Shaw[/url]
    Learn Extended Events

  • In my Deadlock thread, was I wrong to admonish the former MVP over his first post? It just hit me wrong.

  • Lynn Pettis (10/1/2015)


    In my Deadlock thread, was I wrong to admonish the former MVP over his first post? It just hit me wrong.

    I thought it was a quick rise to harshness.

    Jason...AKA CirqueDeSQLeil
    _______________________________________________
    I have given a name to my pain...MCM SQL Server, MVP
    SQL RNNR
    Posting Performance Based Questions - Gail Shaw[/url]
    Learn Extended Events

Viewing 15 posts - 50,866 through 50,880 (of 66,549 total)

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