Are the posted questions getting worse?
-
Steve Jones - SSC Editor (11/3/2016)
Hugo Kornelis (11/2/2016)
Hi Grant,Of course views are faster than stored procedures. And that cars are faster than laptops.
Ah, laptops can be just as fast as cars
To quote my family words:
Well, actually,
The car is still ahead of the laptop and therefore, faster. Just sayin'.
What we'd need to do is take the laptop and throw it ahead of the car at speed and get a good photo of that. Then it would be true.
I volunteer your laptop for the experiment.
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore RooseveltAuthor of:
SQL Server Execution Plans
SQL Server Query Performance Tuning -
Grant Fritchey (11/3/2016)
Steve Jones - SSC Editor (11/3/2016)
Hugo Kornelis (11/2/2016)
Hi Grant,Of course views are faster than stored procedures. And that cars are faster than laptops.
Ah, laptops can be just as fast as cars
To quote my family words:
Well, actually,
The car is still ahead of the laptop and therefore, faster. Just sayin'.
What we'd need to do is take the laptop and throw it ahead of the car at speed and get a good photo of that. Then it would be true.
I volunteer your laptop for the experiment.
And your car? 😎
Hugo Kornelis, SQL Server/Data Platform MVP (2006-2016)
Visit my SQL Server blog: https://sqlserverfast.com/blog/
SQL Server Execution Plan Reference: https://sqlserverfast.com/epr/ -
Surely they'd be travelling at the same velocity unless or until the car braked suddenly, when the laptop might consequently shoot forwards and overtake it (or smash into it) at a greater speed (uncertain velocity).
-
Hugo Kornelis (11/3/2016)
Grant Fritchey (11/3/2016)
Steve Jones - SSC Editor (11/3/2016)
Hugo Kornelis (11/2/2016)
Hi Grant,Of course views are faster than stored procedures. And that cars are faster than laptops.
Ah, laptops can be just as fast as cars
To quote my family words:
Well, actually,
The car is still ahead of the laptop and therefore, faster. Just sayin'.
What we'd need to do is take the laptop and throw it ahead of the car at speed and get a good photo of that. Then it would be true.
I volunteer your laptop for the experiment.
And your car? 😎
It's not a car. It's a Jeep.
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore RooseveltAuthor of:
SQL Server Execution Plans
SQL Server Query Performance Tuning -
Overheard conversation at a "database" conference:
a: That guy must be an Oracle DBA!
b: Why on earth do you think that?
a: Watch him, he doesn't bring anything to the table!
😎
-
jasona.work (11/2/2016)
Luis Cazares (11/2/2016)
I'm not looking for a job, but I take a look at offers from LinkedIn every now and then just to see what's being offered/requested.That said, can anyone explain to me how is this a Jr position? https://www.linkedin.com/comm/jobs/view/218716553
I'm not even sure some the heavy-hitters around here (Grant, Gail, Jeff Moden, Steve) would meet the qualifications...
Maybe they're trying to keep the salary low by calling it a "Jr" position?
Of course, the responses they're likely to get are either going to be actual Jr DBAs with an overblown belief in their skillset, or the sort of "Jr/Sr" DBA who meets the requirements but isn't really all that good at it...
Either way, I think they'll be in for a rude awakening down the line...
The guy in this tube must be at least a part time DBA.
http://www.wimp.com/brass-band-multitasker/
--Jeff Moden
RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
First step towards the paradigm shift of writing Set Based code:
________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.Change is inevitable... Change for the better is not.
Helpful Links:
How to post code problems
How to Post Performance Problems
Create a Tally Function (fnTally) -
Luis Cazares (11/2/2016)
I'm not looking for a job, but I take a look at offers from LinkedIn every now and then just to see what's being offered/requested.That said, can anyone explain to me how is this a Jr position? https://www.linkedin.com/comm/jobs/view/218716553
No problem... no where did they say that the candidate must know how to get the current date and time. 😛
--Jeff Moden
RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
First step towards the paradigm shift of writing Set Based code:
________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.Change is inevitable... Change for the better is not.
Helpful Links:
How to post code problems
How to Post Performance Problems
Create a Tally Function (fnTally) -
Jeff Moden (11/6/2016)
jasona.work (11/2/2016)
Luis Cazares (11/2/2016)
I'm not looking for a job, but I take a look at offers from LinkedIn every now and then just to see what's being offered/requested.That said, can anyone explain to me how is this a Jr position? https://www.linkedin.com/comm/jobs/view/218716553
I'm not even sure some the heavy-hitters around here (Grant, Gail, Jeff Moden, Steve) would meet the qualifications...
Maybe they're trying to keep the salary low by calling it a "Jr" position?
Of course, the responses they're likely to get are either going to be actual Jr DBAs with an overblown belief in their skillset, or the sort of "Jr/Sr" DBA who meets the requirements but isn't really all that good at it...
Either way, I think they'll be in for a rude awakening down the line...
The guy in this tube must be at least a part time DBA.
That is a great video. My son is going to love that.
_______________________________________________________________
Need help? Help us help you.
Read the article at http://www.sqlservercentral.com/articles/Best+Practices/61537/ for best practices on asking questions.
Need to split a string? Try Jeff Modens splitter http://www.sqlservercentral.com/articles/Tally+Table/72993/.
Cross Tabs and Pivots, Part 1 – Converting Rows to Columns - http://www.sqlservercentral.com/articles/T-SQL/63681/
Cross Tabs and Pivots, Part 2 - Dynamic Cross Tabs - http://www.sqlservercentral.com/articles/Crosstab/65048/
Understanding and Using APPLY (Part 1) - http://www.sqlservercentral.com/articles/APPLY/69953/
Understanding and Using APPLY (Part 2) - http://www.sqlservercentral.com/articles/APPLY/69954/ -
Sean Lange (11/7/2016)
Jeff Moden (11/6/2016)
jasona.work (11/2/2016)
Luis Cazares (11/2/2016)
I'm not looking for a job, but I take a look at offers from LinkedIn every now and then just to see what's being offered/requested.That said, can anyone explain to me how is this a Jr position? https://www.linkedin.com/comm/jobs/view/218716553
I'm not even sure some the heavy-hitters around here (Grant, Gail, Jeff Moden, Steve) would meet the qualifications...
Maybe they're trying to keep the salary low by calling it a "Jr" position?
Of course, the responses they're likely to get are either going to be actual Jr DBAs with an overblown belief in their skillset, or the sort of "Jr/Sr" DBA who meets the requirements but isn't really all that good at it...
Either way, I think they'll be in for a rude awakening down the line...
The guy in this tube must be at least a part time DBA.
That is a great video. My son is going to love that.
I sent a link to my daughter in college and got to watch her face on Skype as she watched it. It was funny.
-
Hugo Kornelis (10/29/2016)
Chad Crawford (10/28/2016)
Well, the summit has been good to me this year. I participated in many good sessions, including those by Grant, Gail, Wayne and Hugo (you all did GREAT! 6.0/5.0 stars :cool:). If I missed anyone on the thread who presented, let me know - when I get the downloads I plan to watch several that I was not able to attend.Chad
Thanks, Chad! I appreciate the kind words.
Which of my two session is the one you attended and liked so much?
Your session on estimates, I missed the lightning talk. I particularly liked the section about assumptions (independence/uniformity/containment). I'll have to watch it again when I get the downloads to catch all of your equations, you put a lot of work into that area.
Chad
-
Grant - your blog gets a wide enough audience that you're going to always have someone who misreads it, misunderstands it, or deliberately maligns it for some reason. Chops to you (not pork chops though) for trying to help each one of them understand the principles clearly and doing so in a polite way.
If you want the mathematical (statistical) decision on whether the 5 ms difference is actually important, you can use a t-test. It takes into account both the values and how spread out they are to determine if the averages are statistically different (i.e. did stored procs actually beat the view, or is it probably just random noise). The statistical test for consistency is the f-test, which would show if one set of values is more spread out than the other (i.e. do stored procs perform more consistently while the performance of views vary a lot). Both you can do pretty easily in Excel once you understand the principles behind the test.
Chad
-
Chad Crawford (11/7/2016)
Grant - your blog gets a wide enough audience that you're going to always have someone who misreads it, misunderstands it, or deliberately maligns it for some reason. Chops to you (not pork chops though) for trying to help each one of them understand the principles clearly and doing so in a polite way.If you want the mathematical (statistical) decision on whether the 5 ms difference is actually important, you can use a t-test. It takes into account both the values and how spread out they are to determine if the averages are statistically different (i.e. did stored procs actually beat the view, or is it probably just random noise). The statistical test for consistency is the f-test, which would show if one set of values is more spread out than the other (i.e. do stored procs perform more consistently while the performance of views vary a lot). Both you can do pretty easily in Excel once you understand the principles behind the test.
Chad
Thanks Chad. Great info. Exactly the kind of stuff I'm trying to learn. Appreciate it.
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore RooseveltAuthor of:
SQL Server Execution Plans
SQL Server Query Performance Tuning -
Got my blog working again, finally. Hosting provider can't figure out how the files got wiped, restored a 3 month old backup, got my name incorrect in their last reply and and thanked me for hosting with them.
Time to move the blog, as soon as I get a free evening/weekend. Anyone got any experience with DreamHost?
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverabilityWe walk in the dark places no others will enter
We stand on the bridge and no one may pass -
I've been using DreamHost for several years now. It's been a very solid experience.
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore RooseveltAuthor of:
SQL Server Execution Plans
SQL Server Query Performance Tuning -
Good, then it's decided. Thank you
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverabilityWe walk in the dark places no others will enter
We stand on the bridge and no one may pass
Viewing 15 posts - 56,506 through 56,520 (of 66,575 total)
You must be logged in to reply to this topic. Login to reply