SQL Server Performance Tuning Made Easy - Pinal Dave | Craft 2019
HTML-код
- Опубликовано: 9 фев 2025
- 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/...
![I.N "HALLUCINATION" | [Stray Kids : SKZ-PLAYER]](http://i.ytimg.com/vi/n5B5q1Hwt_U/mqdefault.jpg)
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..
Wasting extra time to make long seminar. There is hardly 10 minutes of technical worth discussion.
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.
watched entire session 2 times. 2 most wanted scripts :D , this isn't a comedy show :D
Heheh
22:57 - what an odd hyperbolic statement...
Thanks, it was great and fun stuff.
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
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.
33:00
INDEX REBUILD will NOT do the same as DBCC FREEPROCCACHE!
Index Rebuilds will remove nothing from the plan cache but the Query Optimizer "may" mark the plan as outdated and creates a new one.
This will happen, if statistics have changed but not because the index has been rebuild....
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.
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.
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?
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.
Indexing doesn't slow down the performance, Wrong indexes can significantly slow down SQL Server performance.
Amazing！
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.
Very good. Knowledgeable and practical session.
Q:How long does it take to tune my system?
A: How long does it take to drop the indexes!?
0/0 = 1? 😳
If rebuilding indexes are the worst practices, how do we fix fragmentation?
Who says fragmentation is an issue?
Good one
Thank you!
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? :(
He is literally making fun of all of us. 😂😂😂😂
Indexes are needed for sure, you may not need more but you need them
Un-used indexes hurt performance not all indexes in general.
can you please send me script of this demo
Wow surprised...
I actually got a hear attack, unused indexes kills performance
Great sir..
Thanks,
Arvind, from Indian
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
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 !
nice subject and cool things to learn but why this kind of jokes in the middle without any reason. its not comedy show
Too much unwanted talk. Shameless marketing of own. Bad organizer and presenter.
Binary tree are used to make searching fast. Thats what happens when index are created then how we can say it reduces speed
Index hate mssql. Index love oracle
This guy is funny lol
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?
ce bon mais il faut aussi l'amélioration.
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.
Teaching too fast
Pretend to be comedian or what?
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
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.
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.
This is a Microsoft scam.
5 people in the audience, and he was "happy". LOLOL Junk
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.
you need to learn how to present and remember its not F........... comedy show
Total waste of time!!!
why unnecessary side talk ,its not f......comedy show . just talk abt technical issue mr.
Waste of time and nothing learnt from this video.