5 Tips to improve SQL Server performance

See our other Step by Step video series below :-

This is a nice webcast delivered by Pinal dave on 5 important tips to improve SQL server performance.

[dnfvideo]

Do not miss our Interview Question video series

[ishankhobare]

Wow looking at the critics in the comment is making me feel are people looking for SQL skills or Personalization skills? He is teaching SQL and not the way to talk/speak! Cleared the concept of Non-Clustered Index in first 30 mins.. and presently I am going through the rest! Cheers to the lecturer

[dnfvideo]

The above content is taken from live meeting so the audio has its own issues. The session had more than 120 people in 3 room ( sorry if some one was waiting in the lobby) and all waited till the end.

Awesome work.Pinal

[GunaNidhiPokhrel]

Glad to see the pinal in this video tutorial. we are benifiited a lot with the help of your blog already. good job man keep doing the same

[Hjominbonrun]

could be that nonclustered index table had different statistics on the table due to index built, which made query cost estimate of nonclusted index query be more than the threshold for parallelism.
And with Paralellism, comes more cpu due to management of different threads.

[bitkuri]

Simple and stright forward basics things that we need to take care for performance tunning. Very Good Video. you made it very intresting while explaining the 5 points :)

[sajitpyakurel]

What a great teacher. Thank you so much

[ksathish]

Thank you so much Pinal and it was a nice session !

[vrashalipansare]

Thank you !!! concepts are good but voice clarity can be improved

[mdmumtazkhan]

thanks...your way to explain is interested...

[vchandm]

Pinal Rocks !!!! I love his blog ....

[AnujSethi]

Awesome content but very bad recording.
Please keep up the good work and share the knowledge. Very helpful. Thanks :)

[ravishdhingra]

Thanks for video. You made it interesting and I could not stop myself to leave it in

[savagefishstick]

This guy is funny, I like his style. Thanks for the video!

[goutamroy]

its really good but its take performance issue

[ljubafm]

try to use this for measuring time and reads, writes per query

set statistics io on
set statistics time on

[BurninHO]

Pinal should be a comedian and should make a TV show for Indian public. It would be intellectually funny...better than any Daughter-in-law vs Mother-in-law garbage shows.

[riteshranjan]

good content but my feedback to Pinal would be to work on presentation skills especially communication.

[darlove]

It would have been a great learning resource... if only I were able to stand this appalling kind of English :( Not to mention the sound quality.

[satyauall]

Pinal Bro. You tip was good but try to improve the way you present. This might mislead someone to focus on the way you talk rather the what you your intent was good hence thanks again..:-)