SQL Server Performance Tuning Made Easy - Pinal Dave | Craft 2019

[@arjun2514]

The number of minutes of technical content in this video is exactly equal to the number chips in a 100 grams lays packet.

[@azdesi2]

So what did i learn? Problems but no solution. Some attitude adjustment needed from Pinal.

[@jfaquinojr]

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.

[@theislamicvoyager]

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..

[@JosePla]

SQL stand up comedy And an intro to not abuse from indexing

[@robj2118]

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.

[@sutrejito]

Pinal is my number one source of info on SQL he is a based dude

[@BhavinPatel5916]

Wasting extra time to make long seminar. There is hardly 10 minutes of technical worth discussion.

[@SuperErmacX]

22:57 - what an odd hyperbolic statement...

[@sajitha.k.8141]

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 ?

[@PinalDaveSQLAuthority]

Just try out yourself. Check the query cache for table first and then rebuild it.

[@harmenbos]

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.

[@BsiennKhan]

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.

[@android01978]

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.

[@tinaxu4214]

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😀.

[@haiderhussain4706]

He doesn't know anything. He is just pretending

[@kirole7381]

Thanks, it was great and fun stuff.

[@shiwanginishishulkar4744]

watched entire session 2 times. 2 most wanted scripts :D , this isn't a comedy show :D

[@TechandArt]

Heheh

[@hengxie4839]

Amazing！

[@dbberater]

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....

[@yogeshjadon9188]

Literally! after watching this video...totally confused about Index.

[@haiderhussain4706]

Don't be confused, stick to Microsoft suggestions. Dump this guy. He himself got to learn a lot.

[@EternalEvanesce]

Q:How long does it take to tune my system? A: How long does it take to drop the indexes!?

[@akrooma]

His task is to leave you more confused. . So you can reach out for him for business. . Stupid plan though !

[@BsiennKhan]

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?

[@voltairend]

Good one

[@coreymagin]

Thank you!

[@saneeshj8]

0/0 = 1? 😳

[@azihcchidi001]

If rebuilding indexes are the worst practices, how do we fix fragmentation?

[@erwinekkel9676]

Who says fragmentation is an issue?

[@shiwanginishishulkar4744]

Very good. Knowledgeable and practical session.

[@varundeshpandevd]

Yeah his sense of humour is wired. He could have made it even better by telling us the reason for bad performance.

[@haiderhussain4706]

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.

[@Kurnacopia]

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.

[@RadheyaZunjur]

Indexing doesn't slow down the performance, Wrong indexes can significantly slow down SQL Server performance.

[@subhashkomy]

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? :(

[@rajatmaurya6401]

He is literally making fun of all of us. 😂😂😂😂

[@darotweiler7]

Un-used indexes hurt performance not all indexes in general.

[@dbatexas]

Indexes are needed for sure, you may not need more but you need them

[@Ex-Introverts]

Wow surprised...

[@KARTIK_RAJPUT_07]

can you please send me script of this demo

[@snehachakraborty7476]

I actually got a hear attack, unused indexes kills performance

[@gatlaaravind3178]

Great sir.. Thanks, Arvind, from Indian

[@manuzzz123]

Binary tree are used to make searching fast. Thats what happens when index are created then how we can say it reduces speed

[@sqlforeveryep215]

Pinal ... Next time don't waste my time... I know you are good .... not agree with your statement

[@haiderhussain4706]

You are wrong. He doesn't know anything on MSSQL. He swipes Google and copies what others have said but can't explain

[@50tigres79]

This guy is funny lol

[@kushalthapa2865]

Too much unwanted talk. Shameless marketing of own. Bad organizer and presenter.

[@akrooma]

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 !

[@whymizan]

nice subject and cool things to learn but why this kind of jokes in the middle without any reason. its not comedy show

[@Kbhgdfjvf]

Index hate mssql. Index love oracle

[@hnbright]

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.

[@kattarajesh6305]

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.

[@frysf750]

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?

[@MrOlegYT]

Pretend to be comedian or what?

[@whymizan]

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.

[@haiderhussain4706]

He hasn't learned anything on MSSQL yet

[@PrakashPatil-dw5be]

Teaching too fast

[@sergemwira6981]

ce bon mais il faut aussi l'amélioration.

[@eugeneng]

very arrogant speaker, and make people even more confuse.

[@muneerdba]

this guy knows very less but pretends as if he knows everything under the sun.

[@dariuszspiewak5624]

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.

[@vanithaa6017]

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.

[@damirbolic6836]

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.

[@pixeluser8243]

This is a Microsoft scam.

[@foobarmaximus3506]

5 people in the audience, and he was "happy". LOLOL Junk

[@whymizan]

you need to learn how to present and remember its not F........... comedy show

[@whymizan]

why unnecessary side talk ,its not f......comedy show . just talk abt technical issue mr.

[@funmoments1782]

Waste of time and nothing learnt from this video.

[@yoggita]

Total waste of time!!!