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

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

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

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

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.

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

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

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

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.

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.

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

Thanks, it was great and fun stuff.

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

Very good. Knowledgeable and practical session.

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 ?

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

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

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

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

Thank you!

Amazing！

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

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

0/0 = 1? 😳

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

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

Great sir.. Thanks, Arvind, from Indian

Good one

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

can you please send me script of this demo

I actually got a hear attack, unused indexes kills performance

This guy is funny lol

Wow surprised...

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.

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

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

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.

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

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 !

Pretend to be comedian or what?

very arrogant speaker, and make people even more confuse.

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

Index hate mssql. Index love oracle

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.

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.

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

Teaching too fast

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

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.

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.

This is a Microsoft scam.

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.

Total waste of time!!!