March 11, 2014 at 12:20 am
Luis Cazares (3/10/2014)
Good Monday everyone,I've been away for a week and seems a lot to me. I moved to a different area in my company and I've been adapting and learning (and struggling with the lack of internet access).
Congratulations to Jack on his new job.
If you want to talk about traffic, It takes me about an hour to get to work when it should take me about 20min. That's the price of living in one of the most populated cities in the world.
Congrats to you and Jack both.
I used to drive 45 miles to work and it would take anywhere from 45 minutes to 3 hours depending on the weather and the traffic.
I've been in 7th heaven for the last 2+ years at my "new" job, though. I live close enough to work that I could ride my unicycle to get there without getting chafe marks. π
--Jeff Moden
Change is inevitable... Change for the better is not.
March 11, 2014 at 3:47 am
Current submissions for SQLBits XII:
March 11, 2014 at 4:33 am
Looks like someone has a split personality.
http://www.sqlservercentral.com/Forums/Topic1549262-2799-1.aspx
Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP
March 11, 2014 at 5:33 am
Koen Verbeeck (3/11/2014)
Looks like someone has a split personality.http://www.sqlservercentral.com/Forums/Topic1549262-2799-1.aspx
Yeah, Koen - "suggest me". I didn't rename the server, but what should I do if I did? Then it's almost like he doesn't know if the server was renamed. :crazy:
March 11, 2014 at 5:36 am
I'm feeling like a parrot today.
"Let me repeat what has already been said in this thread"
"Let me repeat what I said earlier in this thread"
"Let me quote the answer to that question from earlier in this thread"
...
*headdesk*
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
March 11, 2014 at 7:34 am
Someone gives this guy the persistence medal.
http://www.sqlservercentral.com/Forums/Topic1549110-391-1.aspx#bm1549735
Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP
March 11, 2014 at 7:40 am
Koen Verbeeck (3/11/2014)
Someone gives this guy the persistence medal.http://www.sqlservercentral.com/Forums/Topic1549110-391-1.aspx#bm1549735
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
March 11, 2014 at 7:45 am
By the gods, people get hung up on the weirdest darned things. They can focus like a laser on stuff that's just a waste of time. It's weird.
"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
March 11, 2014 at 7:49 am
Grant Fritchey (3/11/2014)
By the gods, people get hung up on the weirdest darned things. They can focus like a laser on stuff that's just a waste of time. It's weird.
I think we're talking about the same topic π
Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP
March 11, 2014 at 7:51 am
Koen Verbeeck (3/11/2014)
Grant Fritchey (3/11/2014)
By the gods, people get hung up on the weirdest darned things. They can focus like a laser on stuff that's just a waste of time. It's weird.I think we're talking about the same topic π
Yup.
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
March 11, 2014 at 7:55 am
GilaMonster (3/11/2014)
Koen Verbeeck (3/11/2014)
Grant Fritchey (3/11/2014)
By the gods, people get hung up on the weirdest darned things. They can focus like a laser on stuff that's just a waste of time. It's weird.I think we're talking about the same topic π
Yup.
And a couple of others recently on other sites. The piercing focus on defragging indexes is another one that seems weird.
"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
March 11, 2014 at 7:56 am
GilaMonster (3/11/2014)
Koen Verbeeck (3/11/2014)
Grant Fritchey (3/11/2014)
By the gods, people get hung up on the weirdest darned things. They can focus like a laser on stuff that's just a waste of time. It's weird.I think we're talking about the same topic π
Yup.
I really wonder if he's been waiting for over a day now to create that new table.
His boss must be very pleased.
Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP
March 11, 2014 at 8:23 am
Koen Verbeeck (3/11/2014)
GilaMonster (3/11/2014)
Koen Verbeeck (3/11/2014)
Grant Fritchey (3/11/2014)
By the gods, people get hung up on the weirdest darned things. They can focus like a laser on stuff that's just a waste of time. It's weird.I think we're talking about the same topic π
Yup.
I really wonder if he's been waiting for over a day now to create that new table.
His boss must be very pleased.
I always approached from the aspect of using the field most appropriate for the data, then IF you have a performance issue, explore your options.
The field either needs decimal precision or not.
Maybe he needs a data dictionary like JDE. π
And their Julian Dates.
March 11, 2014 at 5:45 pm
Editing and rewriting the query tuning book for 2014 when I came across this:
Queries may be attempting to deal with data in a row-by-row fashion (or to quote Jeff Moden, Row By Agonizing Row, which is abbreviated to RBAR and pronounced βreebarβ) instead of in logical sets.
I had completely forgot I put that in there. Gave me a chuckle.
Thanks for such an awesome term Jeff.
"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
March 11, 2014 at 6:19 pm
Grant Fritchey (3/11/2014)
Editing and rewriting the query tuning book for 2014 when I came across this:Queries may be attempting to deal with data in a row-by-row fashion (or to quote Jeff Moden, Row By Agonizing Row, which is abbreviated to RBAR and pronounced βreebarβ) instead of in logical sets.
I had completely forgot I put that in there. Gave me a chuckle.
Thanks for such an awesome term Jeff.
Heh... I had no idea that it would become the proverbial household word in so few years but it has because of good folks like you, Grant, and the good folks on this forum. Thank you very much for the mention in your fine writings. I'm deeply honored and truly humbled.
--Jeff Moden
Change is inevitable... Change for the better is not.
Viewing 15 posts - 43,261 through 43,275 (of 66,712 total)
You must be logged in to reply to this topic. Login to reply