SQL Server Performance Tuning Made Easy - Pinal Dave | Craft 2019
HTML-код
- Опубликовано: 14 май 2019
- Every new release of SQL Server brings a whole load of new features that an administrator can add to their arsenal of efficiency. SQL Server 2016 / 2017 has introduced many new features. In this 55 minute session, we will be learning quite a few of the new features of SQL Server 2016 / 2017. Here is the glimpse of the features we will cover in this session. - Captured Live on Ustream at www.ustream.tv/channel/craftconf3
Наука
The number of minutes of technical content in this video is exactly equal to the number chips in a 100 grams lays packet.
SQL stand up comedy
And an intro to not abuse from indexing
So what did i learn? Problems but no solution. Some attitude adjustment needed from Pinal.
The solution was to delete unused indexes. Do not rebuild indexes but rather update statistics directly (he didnt show how but said there are different ways to do it).
His attempt at humor was porbably misunderstood as attitude problem. At first it was awkward but soon warmed up to me.
Pinal is my number one source of info on SQL he is a based dude
If you thinks indexes reduces the performance than wonder how heap structure is going to help him. He has taken one of the example of unused index and claiming it reduces the performance. Now wondering why index are meant for in RDMS..
Thanks, it was great and fun stuff.
Literally! after watching this video...totally confused about Index.
Don't be confused, stick to Microsoft suggestions. Dump this guy. He himself got to learn a lot.
Very good. Knowledgeable and practical session.
I don't know if this was this specific issue, but the added index gave more options for the query compiler to consider. I suppose it's possible the compilation timed-out and was stuck with an inferior plan.
Thank you!
Wasting extra time to make long seminar. There is hardly 10 minutes of technical worth discussion.
Amazing！
watched entire session 2 times. 2 most wanted scripts :D , this isn't a comedy show :D
Heheh
Good one
Great sir..
Thanks,
Arvind, from Indian
The example when a not used index has a negative effect on query execution is a sign of wrong behavior of the query optimizer. It does not proof that any index has a negative effect.
That's not the point, The point is understanding how underlying system works, and what precautions to make and have best use of the system. As per your statement, that's exactly what the sql server 2019 version fixed regarding the function call in select. It was not a bug in query rather the server/optimizer issue.
22:57 - what an odd hyperbolic statement...
He is literally making fun of all of us. 😂😂😂😂
Q:How long does it take to tune my system?
A: How long does it take to drop the indexes!?
Indexes are needed for sure, you may not need more but you need them
I didn't observed or read regarding "When we rebuild the index it is clearing all the cache related to that Table." Can you please share or give any evidence to prove your word ?
Just try out yourself. Check the query cache for table first and then rebuild it.
Didn't make sense to me. If I am using 10 Different queries on the table where I have created index and I am using index in 2 query and not using in 8 query mean query I am ruining 8 queries without index will run slow? :(
This guy is funny lol
I actually got a hear attack, unused indexes kills performance
can you please send me script of this demo
His task is to leave you more confused. . So you can reach out for him for business. . Stupid plan though !
That is absolutely correct exactly my thoughts. This trick works though because a) the problem is real and b) he knows the prob and solution to it for a fee of course. At least we get to know more for free. That's a plus right?
If rebuilding indexes are the worst practices, how do we fix fragmentation?
Who says fragmentation is an issue?
0/0 = 1? 😳
Wow surprised...
Un-used indexes hurt performance not all indexes in general.
Indexing doesn't slow down the performance, Wrong indexes can significantly slow down SQL Server performance.
This guy probably knows what he’s talking about, but he spends all his time trying to appear like some kind of wizard who knows all of the less than intuitive behaviour in sql server. He never gives any useful information, why the behaviour is that way, or how to fix it. It come across as ‘if you have removed all indexes and there’s still an issue then it’s too complex for you so you should pay me a fortune to wave my wand and fix it for you’.
Indexes certainly aren’t evil, but you must be careful with them.
This guy knows very well about the SQL server. He thinks very deep into SQL server, and had answered tons of questions that no body else answered well. By searching answers on internet, I began to him who gave the right answers 7 years ago😀.
He doesn't know anything. He is just pretending
Yeah his sense of humour is wired. He could have made it even better by telling us the reason for bad performance.
He keeps telling again and again that he will prove that index reduces performance but never proves it. He copies things from other websites and posts it.
Binary tree are used to make searching fast. Thats what happens when index are created then how we can say it reduces speed
He would have driven me crazy the first 5 minutes. I have no time for jokes and mental hopscotch concerning SQL. The man is brilliant, but I couldn't stand this for very long.
Index hate mssql. Index love oracle
damn! did you say 0/0 =1? did you eevn dare? the result should be undefined! Sir, you should change your drug's quantity/quality !
ce bon mais il faut aussi l'amélioration.
Pinal ... Next time don't waste my time... I know you are good .... not agree with your statement
You are wrong. He doesn't know anything on MSSQL. He swipes Google and copies what others have said but can't explain
nice subject and cool things to learn but why this kind of jokes in the middle without any reason. its not comedy show
Teaching too fast
This Guy never shares solution even in his blogs, he only states to reach out to him for further investigation and troubleshooting. He is not good at knowledge sharing like Balmukund.
Giving free advices is one thing but you still need to make a living. You have to draw a line. Or you're working for free?
it was an interesting session. But Pinal, I must mention here that most of your "jokes" were on the offensive end, kindly work on that.
Pretend to be comedian or what?
Too much unwanted talk. Shameless marketing of own. Bad organizer and presenter.
This is a Microsoft scam.
this guy knows very less but pretends as if he knows everything under the sun.
why you talk or bring unnecessary stuff in the middle of the lesson. You are educated but you need to learn how to present or teach.
He hasn't learned anything on MSSQL yet
very arrogant speaker, and make people even more confuse.
Good content, and I do use Pinal's content from sqlauthority often. Watching him for the first time, sorry, but he is arrogant and belittling participants.
I remember the time when I first stumbled upon this guy on a blog or in a vid. And it was my last time. Hes ways are not to my liking. There are so many great SQL guys out there (Brent Ozar, Glen Berry, Kendra Little, Paul White...) that it's a total waste of time to give an ear to him. Sorry to say that but it's the truth. I tried to listen to this talk but - again - got convinced he's a waste of time.
you need to learn how to present and remember its not F........... comedy show
5 people in the audience, and he was "happy". LOLOL Junk
why unnecessary side talk ,its not f......comedy show . just talk abt technical issue mr.
Pretty poor technical presentation. Nothing is explained, im guessing you gotta pay extra for that. 1 or 2 examples with a lot of audience patronization.
Total waste of time!!!