Thanksgiving 2014

  • Koen Verbeeck (11/27/2014)


    kaspencer (11/27/2014)


    When you have an Americo-centric question like this, you should provide an alternative, such as one based on St. Georges Day or similar. (OK, so then you'd need St Andrew's, St David's, and I suppose for Yorkshire, St Geoffrey Boycott).

    Whilst clicking on "Post" I realised that I don't even know when Thanksgiving Day is (apart from everyday) so I don't think I can do this one.

    A question for Steve: what is the ratio of US-based registrants to non-US-based registrants for SQL Server Central?

    If there only was a site where you could type in a question and it would search the web for you... 😉

    That would be a million dollar idea or more like a 382.47 billion dollar idea. Imagine that they included that functionality on any browser without needing to enter the site. :w00t:

    Luis C.
    General Disclaimer:
    Are you seriously taking the advice and code from someone from the internet without testing it? Do you at least understand it? Or can it easily kill your server?

    How to post data/code on a forum to get the best help: Option 1 / Option 2
  • Well, I learnt something today. When Thanksgiving is 🙂

    Seeing as the question needed two answers, and only two queries gave the same result, the answer was obvious. So no need for Google after all.

    And I think SQL Server Central has more non-USA subscribers than USA. Asia is quite a big place....

  • antony-688446 (11/27/2014)


    Well, I learnt something today. When Thanksgiving is 🙂

    I thought everyone knew it was teh day when 2 turkeys got preseidential pardons.

    Tom

  • antony-688446 (11/27/2014)


    And I think SQL Server Central has more non-USA subscribers than USA. Asia is quite a big place....

    I'm not sure about that. Forum posts get tend to decrease significantly on US holidays.

    Or maybe Asia has more subscribers and USA has more active users?

    Luis C.
    General Disclaimer:
    Are you seriously taking the advice and code from someone from the internet without testing it? Do you at least understand it? Or can it easily kill your server?

    How to post data/code on a forum to get the best help: Option 1 / Option 2
  • Luis Cazares (11/27/2014)


    Koen Verbeeck (11/27/2014)


    kaspencer (11/27/2014)


    When you have an Americo-centric question like this, you should provide an alternative, such as one based on St. Georges Day or similar. (OK, so then you'd need St Andrew's, St David's, and I suppose for Yorkshire, St Geoffrey Boycott).

    Whilst clicking on "Post" I realised that I don't even know when Thanksgiving Day is (apart from everyday) so I don't think I can do this one.

    A question for Steve: what is the ratio of US-based registrants to non-US-based registrants for SQL Server Central?

    If there only was a site where you could type in a question and it would search the web for you... 😉

    That would be a million dollar idea or more like a 382.47 billion dollar idea. Imagine that they included that functionality on any browser without needing to enter the site. :w00t:

    I just need funding for my start-up.

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

  • Koen Verbeeck (11/28/2014)


    Luis Cazares (11/27/2014)


    Koen Verbeeck (11/27/2014)


    kaspencer (11/27/2014)


    When you have an Americo-centric question like this, you should provide an alternative, such as one based on St. Georges Day or similar. (OK, so then you'd need St Andrew's, St David's, and I suppose for Yorkshire, St Geoffrey Boycott).

    Whilst clicking on "Post" I realised that I don't even know when Thanksgiving Day is (apart from everyday) so I don't think I can do this one.

    A question for Steve: what is the ratio of US-based registrants to non-US-based registrants for SQL Server Central?

    If there only was a site where you could type in a question and it would search the web for you... 😉

    That would be a million dollar idea or more like a 382.47 billion dollar idea. Imagine that they included that functionality on any browser without needing to enter the site. :w00t:

    I just need funding for my start-up.

    Are you gonna call it Koenoogle?

    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

  • SQLRNNR (11/28/2014)


    Koen Verbeeck (11/28/2014)


    Luis Cazares (11/27/2014)


    Koen Verbeeck (11/27/2014)


    kaspencer (11/27/2014)


    When you have an Americo-centric question like this, you should provide an alternative, such as one based on St. Georges Day or similar. (OK, so then you'd need St Andrew's, St David's, and I suppose for Yorkshire, St Geoffrey Boycott).

    Whilst clicking on "Post" I realised that I don't even know when Thanksgiving Day is (apart from everyday) so I don't think I can do this one.

    A question for Steve: what is the ratio of US-based registrants to non-US-based registrants for SQL Server Central?

    If there only was a site where you could type in a question and it would search the web for you... 😉

    That would be a million dollar idea or more like a 382.47 billion dollar idea. Imagine that they included that functionality on any browser without needing to enter the site. :w00t:

    I just need funding for my start-up.

    Are you gonna call it Koenoogle?

    Maybe KVing.

    Luis C.
    General Disclaimer:
    Are you seriously taking the advice and code from someone from the internet without testing it? Do you at least understand it? Or can it easily kill your server?

    How to post data/code on a forum to get the best help: Option 1 / Option 2
  • Luis Cazares (11/28/2014)


    SQLRNNR (11/28/2014)


    Koen Verbeeck (11/28/2014)


    Luis Cazares (11/27/2014)


    Koen Verbeeck (11/27/2014)


    kaspencer (11/27/2014)


    When you have an Americo-centric question like this, you should provide an alternative, such as one based on St. Georges Day or similar. (OK, so then you'd need St Andrew's, St David's, and I suppose for Yorkshire, St Geoffrey Boycott).

    Whilst clicking on "Post" I realised that I don't even know when Thanksgiving Day is (apart from everyday) so I don't think I can do this one.

    A question for Steve: what is the ratio of US-based registrants to non-US-based registrants for SQL Server Central?

    If there only was a site where you could type in a question and it would search the web for you... 😉

    That would be a million dollar idea or more like a 382.47 billion dollar idea. Imagine that they included that functionality on any browser without needing to enter the site. :w00t:

    I just need funding for my start-up.

    Are you gonna call it Koenoogle?

    Maybe KVing.

    Or Verhoo

    Maybe

    Koevista (altavista)

    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

  • SQLRNNR (11/29/2014)


    Luis Cazares (11/28/2014)


    SQLRNNR (11/28/2014)


    Koen Verbeeck (11/28/2014)


    Luis Cazares (11/27/2014)


    Koen Verbeeck (11/27/2014)


    kaspencer (11/27/2014)


    When you have an Americo-centric question like this, you should provide an alternative, such as one based on St. Georges Day or similar. (OK, so then you'd need St Andrew's, St David's, and I suppose for Yorkshire, St Geoffrey Boycott).

    Whilst clicking on "Post" I realised that I don't even know when Thanksgiving Day is (apart from everyday) so I don't think I can do this one.

    A question for Steve: what is the ratio of US-based registrants to non-US-based registrants for SQL Server Central?

    If there only was a site where you could type in a question and it would search the web for you... 😉

    That would be a million dollar idea or more like a 382.47 billion dollar idea. Imagine that they included that functionality on any browser without needing to enter the site. :w00t:

    I just need funding for my start-up.

    Are you gonna call it Koenoogle?

    Maybe KVing.

    Or Verhoo

    Maybe

    Koevista (altavista)

    Just KoBing with the idea, sounds brilliant:w00t:

    😎

  • kaspencer (11/27/2014)


    A question for Steve: what is the ratio of US-based registrants to non-US-based registrants for SQL Server Central?

    70+% US.

  • Steve Jones - SSC Editor (11/29/2014)


    kaspencer (11/27/2014)


    A question for Steve: what is the ratio of US-based registrants to non-US-based registrants for SQL Server Central?

    70+% US.

    Thanks for the interesting statistic. One thing is certain - while Thanksgiving is an American holiday, I genuinely hope that everyone in the world has a reason to gather with family and friends, eat a fantastic meal together and appreciate one another.

    As for the day after, Black Friday, I don't participate myself. It starts ridiculously early (4:00 AM or Thanksgiving evening) and gets pretty ugly. I guard the days I get to sleep in for an hour and enjoy the day with my family, so it isn't worth getting up and fighting the crowds just to have a chance on saving $50 on stuff. Of course, the stores are already out of most stuff they put on sale, so it becomes even less worth it.

  • or the day when Bernard Matthews died. Hows that for irony.

  • Thanks for this one.

  • Nice question thanks....

    Now only i am getting to know Thanksgiving day 😛

    Manik
    You cannot get to the top by sitting on your bottom.

  • Thanks Steve.

    Just extended your query to identify current years thanksgiving day:

    declare @date datetime

    set @date=dateadd(yy,0,getdate())

    SELECT DATEADD( DAY, 5-datepart(dw,DATEADD( WEEK, -1, DATEADD( MONTH, 11, DATEADD(yy, datediff(yy, 0, @date), 0)))), DATEADD( WEEK, -1, DATEADD( MONTH, 11, DATEADD(yy, datediff(yy, 0, @date), 0))));

    Pramod
    SQL Server DBA | MCSE SQL Server 2012/2014

    in.linkedin.com/in/pramodsingla/
    http://pramodsingla.wordpress.com/

Viewing 15 posts - 16 through 29 (of 29 total)

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