April 3, 2015 at 9:34 pm
Sioban Krzywicki (4/3/2015)
And thanks to my Medieval History classes in college I know that Easter is the first Sunday after the first full moon after the Vernal Equinox and Lent starts 40 days before that.
Actually that's only sort of true. From first day of lent to last day of lent inclusive is always 46 days (except in the East, where there are more than 46), so lent starts 46 days before Easter.
But only 40 of those 46 days are lent - the other 6 days are Sundays, and Cristians (at least of denominations which recognise this sort of stuff) are not allowed to fast on Sunday, because every Sunday is a feast day celebrating the resurrection. That of course is the fast called Lent.
In the Roman church (and several more Western churches), there is also the liturgical season of lent (not to be confused with lent itself) which begins on the same day as lent and ends perhaps at a different time (RC church and maybe some others: sunset on Holy Thursday; some churches: Sunset on the Saturday before Easter; some other churches: the end of that Saturday (which might be midnight local time or midnight bureaucratic time); and maybe more variants. Anyway that means that the RC lent liturgical season is 44 days long.
In the East (Greek Orthodox and so on) Saturday is also a day which is not to be included in the lent fast, so they have to add more than another week to get the count up to 40: the count of fast days always has to be 40, ever since somwhere around 1200 years ago (and in theory before that: I think it was St Gregory who pointed out about 1400 years ago that western lent then had only 36 fast days, so it didn't have the required 40, and it then took a couple of hundred years for anything to be done church-wide about it).
(I tend to know a bit of this stuff despite it not being my thing because I'm married to a qualified theology teacher)
Tom
April 3, 2015 at 10:06 pm
Eirikur Eiriksson (4/3/2015)
djj (4/3/2015)
Worked with a guy who would talk to his dog about a code problem.Now this can easily be mis-understood:hehe:
😎
It's when you start taking notice of the dog's answers that people begin to misunderstand. :w00t:
Tom
April 4, 2015 at 6:36 am
SqlSanctum (4/3/2015)
Sounds like you need to invest in a duck
Did know someone whose workplace had a life size cardboard cut out of a person called Maud (name not acronym) which stood in a corner and when you had a problem you stood Maud next to you, explained the problem and in the process solved it.
Far away is close at hand in the images of elsewhere.
Anon.
April 4, 2015 at 6:40 am
David Burrows (4/4/2015)
SqlSanctum (4/3/2015)
Sounds like you need to invest in a duckDid know someone whose workplace had a life size cardboard cut out of a person called Maud (name not acronym) which stood in a corner and when you had a problem you stood Maud next to you, explained the problem and in the process solved it.
Don't forget to mention that one of Maud's tasks was to water and feed the dust bunnies:-D
😎
By the way, one doesn't need a dedicated Maud, just grab the next C# programmer....
April 4, 2015 at 10:44 am
Eirikur Eiriksson (4/4/2015)
David Burrows (4/4/2015)
SqlSanctum (4/3/2015)
Sounds like you need to invest in a duckDid know someone whose workplace had a life size cardboard cut out of a person called Maud (name not acronym) which stood in a corner and when you had a problem you stood Maud next to you, explained the problem and in the process solved it.
Don't forget to mention that one of Maud's tasks was to water and feed the dust bunnies:-D
😎
By the way, one doesn't need a dedicated Maud, just grab the next C# programmer....
In the good old days, we programmers in real declarative languages used to reckon we didn't need a C# programmer (just as well, as we didn't have any time machines) we could just use the nearest SQL programer (after all, C++ programers weren't adequate, their understanding was too much poorer that the average rubber duck - SQL programmers weren't quite that dumb, although dumb enough to claim SQL was declarative - almost as bright as rubber ducks, in fact).
After all, no rubber duck was ever so anti-declarative as to ask me why seeing ones own updates in current transaction was a problem, or why we couldn't just use a NOLOCK hint for it, or so blind to both self checking and reasonable efficiency as to ask why seeing that stuff might need to happen in the first place - and yes, OK, on that last point (reasonable efficiency) I'm indicating that I do understand why people take the attitude they do on optimizer idiocy, although I will claim we never dreamt of taking it so insanely far as either ANSI SQL or Microsoft T-SQL (but not QUEL or Postgres SQL, oddly enough) have because we had a sane definition of reasonable.
Tom
April 4, 2015 at 1:37 pm
Interesting new site bug. The author and date information for QotD seems to be pretty random - no connection with reality unless you are lucky. What is shown seems to depend on the route you got there, and refreshing the page doesn't correct it.
Tom
April 4, 2015 at 2:10 pm
TomThomson (4/4/2015)
Interesting new site bug. The author and date information for QotD seems to be pretty random - no connection with reality unless you are lucky. What is shown seems to depend on the route you got there, and refreshing the page doesn't correct it.
Looks like a dirty read:blink:
😎
April 6, 2015 at 4:42 am
Eirikur Eiriksson (4/4/2015)
TomThomson (4/4/2015)
Interesting new site bug. The author and date information for QotD seems to be pretty random - no connection with reality unless you are lucky. What is shown seems to depend on the route you got there, and refreshing the page doesn't correct it.Looks like a dirty read:blink:
😎
DAMN THAT NOLOCK()!!!!
Someone, quick, put a target on its back.
April 6, 2015 at 5:52 am
There are internet cookies for anyone willing to help me with custom SSIS component building, please and thank you.
Corporate restrictions and my own need for simplicity make this a necessity.
April 6, 2015 at 5:58 pm
SQLRNNR (4/1/2015)
Who remembered to do an April Fools post today?
Does An Easter SQL[/url] posted on or around April Fools day count?
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
April 6, 2015 at 6:03 pm
Brandie Tarvin (4/3/2015)
djj (4/3/2015)
Sioban Krzywicki (4/3/2015)
Koen Verbeeck (4/3/2015)
Sioban Krzywicki (4/3/2015)
Koen Verbeeck (4/3/2015)
Eirikur Eiriksson (4/3/2015)
Koen Verbeeck (4/3/2015)
It's Friday and I'm grumpy...http://www.sqlservercentral.com/Forums/Topic1674050-3412-1.aspx
Are you grumpy because you are working on the Good Friday or was it the last night "preparation" for it that make you grumpy?
😎
The last one 😀
There's preparation for Good Friday?
Last Supper?
I'm sorry, I'm not Christian and never have been. When you say "Last Supper" I think, well sure, but that was 2000 years ago. Do people have big meals Thursday night to honor that? I don't remember the Christian side of my family doing that when I was a kid and I don't remember people talking about it when I was a kid either. Is it something only some sects do?
Actually there is "Holy Thursday" which is about the "Last Supper". Then "Good Friday" is the day of the crucifixion.
Here's a couple of things to help you out. During Lent (which ends the day before Easter), Catholics aren't allowed to eat meat on Fridays and tend to give up something important to them. You may hear lots of stories about people giving up Coke or chocolate or sweets. Good Friday is also a fast day (the last fast day of Lent and the last day people have to eat fish instead of meat).
"The Catholic Church treats Good Friday as a fast day, which in the Latin Church is understood as having only one full meal (but smaller than a regular meal) and two collations (a smaller repast, two of which together do not equal one full meal) and on which the faithful abstain from eating meat."
So Holy Thursday is a good ramp up to fasting on Friday and then having Easter Fun over the rest of the weekend.
And here I thought Easter was about putting your eggs in one basket.
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
April 6, 2015 at 6:05 pm
Sioban Krzywicki (4/3/2015)
Brandie Tarvin (4/3/2015)
djj (4/3/2015)
Sioban Krzywicki (4/3/2015)
Koen Verbeeck (4/3/2015)
Sioban Krzywicki (4/3/2015)
Koen Verbeeck (4/3/2015)
Eirikur Eiriksson (4/3/2015)
Koen Verbeeck (4/3/2015)
It's Friday and I'm grumpy...http://www.sqlservercentral.com/Forums/Topic1674050-3412-1.aspx
Are you grumpy because you are working on the Good Friday or was it the last night "preparation" for it that make you grumpy?
😎
The last one 😀
There's preparation for Good Friday?
Last Supper?
I'm sorry, I'm not Christian and never have been. When you say "Last Supper" I think, well sure, but that was 2000 years ago. Do people have big meals Thursday night to honor that? I don't remember the Christian side of my family doing that when I was a kid and I don't remember people talking about it when I was a kid either. Is it something only some sects do?
Actually there is "Holy Thursday" which is about the "Last Supper". Then "Good Friday" is the day of the crucifixion.
Here's a couple of things to help you out. During Lent (which ends the day before Easter), Catholics aren't allowed to eat meat on Fridays and tend to give up something important to them. You may hear lots of stories about people giving up Coke or chocolate or sweets. Good Friday is also a fast day (the last fast day of Lent and the last day people have to eat fish instead of meat).
"The Catholic Church treats Good Friday as a fast day, which in the Latin Church is understood as having only one full meal (but smaller than a regular meal) and two collations (a smaller repast, two of which together do not equal one full meal) and on which the faithful abstain from eating meat."
So Holy Thursday is a good ramp up to fasting on Friday and then having Easter Fun over the rest of the weekend.
Thanks! I know about the lent stuff, that's something people tend to talk about (and complain about) a lot.
And thanks to my Medieval History classes in college I know that Easter is the first Sunday after the first full moon after the Vernal Equinox and Lent starts 40 days before that.
Lent starts 46 days before Easter. Check my Easter SQL post for all of the (really) gory details.
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
April 6, 2015 at 10:17 pm
dwain.c (4/6/2015)
SQLRNNR (4/1/2015)
Who remembered to do an April Fools post today?Does An Easter SQL[/url] posted on or around April Fools day count?
Counts for Easter - but not so much the fools. Gonna go read it now.;-)
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
April 7, 2015 at 12:45 am
dwain.c (4/6/2015)
And here I thought Easter was about putting your eggs in one basket.
Very true. Easter is according to some historians actually a holiday about spring and fertility. And the eggs resemble fertility and new life.
Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP
Viewing 15 posts - 48,061 through 48,075 (of 66,712 total)
You must be logged in to reply to this topic. Login to reply