Are the posted questions getting worse?

Question

Are the posted questions getting worse?

Viewing 15 posts - 39,136 through 39,150 (of 66,712 total)

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

SQLRNNR SSC Guru Points: 281334 More actions · Answer 1

L' Eomot Inversé (3/14/2013)
Stefan Krzywicki (3/14/2013)
SQLRNNR (3/14/2013)
Happy Pi day.
I'm looking forward to Pi minute in 1 hour, 17 minutes.
Well, you were five hours late then. And even if you had been using dbcctimewarp to lose 5 hours you should still have been waiting for another 3.1415927 seconds anyway, just to get the pi day, pi minute, and pi sec all at once (and that only works because datetime2 doesn't provide any more decimal places).

I still have 3hrs 5min to pi minute.

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

Sioban Krzywicki One Orange Chip Points: 27770 More actions · Answer 2

L' Eomot Inversé (3/14/2013)
Stefan Krzywicki (3/14/2013)
SQLRNNR (3/14/2013)
Happy Pi day.
I'm looking forward to Pi minute in 1 hour, 17 minutes.
Well, you will be 5 hours late then. And even if you had been using dbcc timewarp to correct for the timezone and lose 5 hours you should still have been waiting for another 3.1415927 seconds anyway, just to get the pi day, pi minute, and pi sec all at once (and that only works because datetime2 doesn't provide any more decimal places).

Heck, if I wanted to really get crazy I could check for the pi-co-second.

3.14159265358979323846

Or 3/14 16:33:35.358979323846 once you've fixed minutes and seconds for base 60.

--------------------------------------
When you encounter a problem, if the solution isn't readily evident go back to the start and check your assumptions.
--------------------------------------
It’s unpleasantly like being drunk.
What’s so unpleasant about being drunk?
You ask a glass of water. -- Douglas Adams

TomThomson SSC Guru Points: 104773 More actions · Answer 3

SQLRNNR (3/14/2013)
I still have 3hrs 5min to pi minute.

Ah, a UTC-7 time zone. 2 hours further from real civilisation than Stefan :hehe:, and of course you are already on DST/Summer Time despite much of the country still having snow, freezing cold, blizzards, and all the rest of winter weather :w00t:.

Tom

Sioban Krzywicki One Orange Chip Points: 27770 More actions · Answer 4

L' Eomot Inversé (3/14/2013)
SQLRNNR (3/14/2013)
I still have 3hrs 5min to pi minute.
Ah, a UTC-7 time zone. 2 hours further from real civilisation than Stefan :hehe:, and of course you are already on DST/Summer Time despite much of the country still having snow, freezing cold, blizzards, and all the rest of winter weather :w00t:.

I'd be happy if DST was year-round again.

I've been to England & various bits of continental Europe. I'm not convinced we have "real civilisation" anywhere yet, though some places are striving for it more than others.

--------------------------------------
When you encounter a problem, if the solution isn't readily evident go back to the start and check your assumptions.
--------------------------------------
It’s unpleasantly like being drunk.
What’s so unpleasant about being drunk?
You ask a glass of water. -- Douglas Adams

TomThomson SSC Guru Points: 104773 More actions · Answer 5

Stefan Krzywicki (3/14/2013)
L' Eomot Inversé (3/14/2013)
Stefan Krzywicki (3/14/2013)
SQLRNNR (3/14/2013)
Happy Pi day.
I'm looking forward to Pi minute in 1 hour, 17 minutes.
Well, you will be 5 hours late then. And even if you had been using dbcc timewarp to correct for the timezone and lose 5 hours you should still have been waiting for another 3.1415927 seconds anyway, just to get the pi day, pi minute, and pi sec all at once (and that only works because datetime2 doesn't provide any more decimal places).
Heck, if I wanted to really get crazy I could check for the pi-co-second.
3.14159265358979323846
Or 3/14 16:33:35.358979323846 once you've fixed minutes and seconds for base 60.

Ah, but SQL Server DBAs can only work to a resolution of 100 nansec or less. Until there's a new release with better resolution :-D.

And if you are adjusting for base(s), with all parts after the year counting, 3/14 doesn't really work; I guess that a march date should use base 31 for days, so it has to be 3/04 not 3/14 (assuming two didit decimal notation for the base 31 bit), which changes the other digits (fix hour for base 24, minute and second for base 60, and the rest for base 10). That's pretty horrible. 😛

Tom

Sioban Krzywicki One Orange Chip Points: 27770 More actions · Answer 6

L' Eomot Inversé (3/14/2013)
Stefan Krzywicki (3/14/2013)
L' Eomot Inversé (3/14/2013)
Stefan Krzywicki (3/14/2013)
SQLRNNR (3/14/2013)
Happy Pi day.
I'm looking forward to Pi minute in 1 hour, 17 minutes.
Well, you will be 5 hours late then. And even if you had been using dbcc timewarp to correct for the timezone and lose 5 hours you should still have been waiting for another 3.1415927 seconds anyway, just to get the pi day, pi minute, and pi sec all at once (and that only works because datetime2 doesn't provide any more decimal places).
Heck, if I wanted to really get crazy I could check for the pi-co-second.
3.14159265358979323846
Or 3/14 16:33:35.358979323846 once you've fixed minutes and seconds for base 60.
Ah, but SQL Server DBAs can only work to a resolution of 100 nansec or less. Until there's a new release with better resolution :-D.
And if you are adjusting for base(s), with all parts after the year counting, 3/14 doesn't really work; I guess that a march date should use base 31 for days, so it has to be 3/04 not 3/14 (assuming two didit decimal notation for the base 31 bit), which changes the other digits (fix hour for base 24, minute and second for base 60, and the rest for base 10). That's pretty horrible. 😛

We can pretend that the 3 is in base 12 and the 14 is in base 31. I'm only adjusting where it is clear the number falls outside the acceptable parameters of the conventional notation.

--------------------------------------
When you encounter a problem, if the solution isn't readily evident go back to the start and check your assumptions.
--------------------------------------
It’s unpleasantly like being drunk.
What’s so unpleasant about being drunk?
You ask a glass of water. -- Douglas Adams

TomThomson SSC Guru Points: 104773 More actions · Answer 7

Stefan Krzywicki (3/14/2013)
I'd be happy if DST was year-round again.

That would be alright here, but I'd hate that if I were in England in wintertime.

I've been to England & various bits of continental Europe. I'm not convinced we have "real civilisation" anywhere yet, though some places are striving for it more than others.

You certainly won't find it in England. Some parts of Scotland are a bit better. Some parts of mainland Europe are not bad, but mostly too stateist/syndicalist to count as civilised. But I think it's pretty close here, well away from the European mainland and the British Isles, in this nice little island - not fully civilised, perhaps, but closer than most places

edit: fix quote tags

Tom

Sioban Krzywicki One Orange Chip Points: 27770 More actions · Answer 8

L' Eomot Inversé (3/14/2013)

Stefan Krzywicki (3/14/2013)
I'd be happy if DST was year-round again.

That would be alright here, but I'd hate that if I were in England in wintertime.

I've been to England & various bits of continental Europe. I'm not convinced we have "real civilisation" anywhere yet, though some places are striving for it more than others.[/quote
You certainly won't find it in England. Some parts of Scotland are a bit better. Some parts of mainland Europe are not bad, but mostly too stateist/syndicalist to count as civilised. But I think it's pretty close here, well away from the European mainland and the British Isles, in this nice little island - not fully civilised, perhaps, but closer than most places.

Meh, I'm fine with year-round DST just being for America. Or the East Coast. Or New England. Or Eastern MA, really...

--------------------------------------
When you encounter a problem, if the solution isn't readily evident go back to the start and check your assumptions.
--------------------------------------
It’s unpleasantly like being drunk.
What’s so unpleasant about being drunk?
You ask a glass of water. -- Douglas Adams

SQLRNNR SSC Guru Points: 281334 More actions · Answer 9

L' Eomot Inversé (3/14/2013)
SQLRNNR (3/14/2013)
I still have 3hrs 5min to pi minute.
Ah, a UTC-7 time zone. 2 hours further from real civilisation than Stefan :hehe:, and of course you are already on DST/Summer Time despite much of the country still having snow, freezing cold, blizzards, and all the rest of winter weather :w00t:.

Yeah - the time change is silly. We warmed up enough to melt the snow in the valleys (4500 ft is a valley here). And then two days later we are back to winter weather.

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

Chad Crawford SSChampion Points: 11610 More actions · Answer 10

We had pie at 1:59 today (3.14.1.59). Kind of a pot-luck sort of thing done every year to celebrate.

Chad

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

L' Eomot Inversé (3/14/2013)
Stefan Krzywicki (3/14/2013)
I'd be happy if DST was year-round again.
That would be alright here, but I'd hate that if I were in England in wintertime.
I've been to England & various bits of continental Europe. I'm not convinced we have "real civilisation" anywhere yet, though some places are striving for it more than others.
You certainly won't find it in ~~England~~Scotland. Some parts of ~~Scotland~~England are a bit better. Some parts of mainland Europe are not bad, but mostly too stateist/syndicalist to count as civilised. But I think it's pretty close here, well away from the European mainland and the British Isles, in this nice little island - not fully civilised, perhaps, but closer than most places
edit: fix quote tags

😉

^{“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

Steve Jones - SSC Editor SSC Guru Points: 736270 More actions · Answer 12

Steve Jones - SSC Editor

SSC Guru

Points: 736270

March 15, 2013 at 9:07 am

#1597535

SQLRNNR SSC Guru Points: 281334 More actions · Answer 13

Steve Jones - SSC Editor (3/15/2013)

hahaha

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

Grant Fritchey SSC Guru Points: 398890 More actions · Answer 14

SQLRNNR (3/15/2013)
Steve Jones - SSC Editor (3/15/2013)
hahaha

Should we show him how to work the site?

"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

Sioban Krzywicki One Orange Chip Points: 27770 More actions · Answer 15

Hey Grant,

Good panel last night. Should be more of those.

--------------------------------------
When you encounter a problem, if the solution isn't readily evident go back to the start and check your assumptions.
--------------------------------------
It’s unpleasantly like being drunk.
What’s so unpleasant about being drunk?
You ask a glass of water. -- Douglas Adams