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

[arjun]

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

[sutrejito]

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

[JosePla]

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

[azdesi]

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

[theRevelationsurah]

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

[robj]

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.

[yogeshjadon]

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

[BhavinPatel]

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

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

[sajitha.k.]

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 ?

[android]

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.

[akrooma]

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

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

[shiwanginishishulkar]

Very good. Knowledgeable and practical session.

[azihcchidi]

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

[SuperErmacX]

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

[shiwanginishishulkar]

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

[radheyazunjur]

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

[EternalEvanesce]

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

[varundeshpandevd]

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