Thanksgiving 2014

Question

Thanksgiving 2014

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

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

Luis Cazares SSC Guru Points: 183706 More actions · Answer 1

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

antony-688446 Ten Centuries Points: 1221 More actions · Answer 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....

TomThomson SSC Guru Points: 104773 More actions · Answer 3

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

Luis Cazares SSC Guru Points: 183706 More actions · Answer 4

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

Koen Verbeeck SSC Guru Points: 259115 More actions · Answer 5

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

SQLRNNR SSC Guru Points: 281334 More actions · Answer 6

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

Luis Cazares SSC Guru Points: 183706 More actions · Answer 7

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

SQLRNNR SSC Guru Points: 281334 More actions · Answer 8

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

Eirikur Eiriksson SSC Guru Points: 182915 More actions · Answer 9

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:

😎

Steve Jones - SSC Editor SSC Guru Points: 736478 More actions · Answer 10

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.

Ed Wagner SSC Guru Points: 287026 More actions · Answer 11

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.

Tally Tables - Performance Personified
String Splitting with True Performance
Best practices on how to ask questions

crmitchell SSCarpal Tunnel Points: 4557 More actions · Answer 12

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

akljfhnlaflkj SSC Guru Points: 76202 More actions · Answer 13

akljfhnlaflkj

SSC Guru

Points: 76202

December 8, 2014 at 1:30 pm

#1763368

Thanks for this one.

manik_anu SSCrazy Points: 2377 More actions · Answer 14

Nice question thanks....

Now only i am getting to know Thanksgiving day 😛

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

psingla Hall of Fame Points: 3840 More actions · Answer 15

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/