Unique and Non Unique Indexes in sql server Part 37

[@Flaxymc]

The work you did 10 years ago is priceless.

[@biruksolomon5572]

Still one of a kind Decade later, thank you very much, sir!!!

[@Pragyasurjan1406]

hey man !!!you are absolutely brilliant !!! cant imagine how efficiently you have addded all the information here...toooo goood:) awesome !!!

[@sayedtalha2689]

sir MASHALLAH THANK YOU SO MUCH YOUR SQL SERVER SESSIONS ARE MORE HELPING TO LEARN AND YOUR BLOG IS MOSTLY HELPING SIR

[@Csharp-video-tutorialsBlogspot]

Hello Syed - Thank you very much for the feedback. Means a lot. I have included all the SQL Course videos, slides and text articles in sequence on the following page. Hope you will find it useful. www.pragimtech.com/courses/sql-server-tutorial-for-beginners/ When you have some time, can you please leave your rating and valuable feedback on the reviews tab. It really helps us. Thank you. Good luck and all the very best with everything you are doing.

[@pavansoni4]

Really Nice videos...from long time I was searching SQl videos...Excellent job...Thank you very much...

[@sangasanikumar1153]

classic explanation sir!!keep on sharing your knowledge. every topic you share is drilled deep into my mind..i really appreciate your explanation skills..

[@TheJayashree12345]

I must say.....All Videos till now very very helpful for us....Thanks for all....

[@krismaly6300]

Revisiting to refresh my memory. Thanks a bunch

[@bizzar31]

some people just show you that life is still okay ...and you are one of them Sir , thank you

[@rathishkumar6680]

Hi Venkat great work. Really no one could explain things better than this!! Keep Going!

[@parikshithgari]

Hi Venkat, Your videos are very informative. The video title includes Non Unique Index. I see we haven't touched that topic in this video. Could you please include that and its possible scenarios for using Non unique index? Thanks!

[@varunjain4571]

thankyou sir, its a best way to understand by practically and enough therotically

[@krismaly]

This is very important video and defaults explained very well.Thanks a bunch

[@kirtim1930]

Extra ordinary! Explained so nicely. Helps me understand the concept of clustered and non-clustered index. Thank yo so much!!!!!

[@kavyajayesh7665]

Hi sir,,thank you so much ,,your explanation is soo good,really appreciate 👏🏻👏🏻keep on sharing your knowledge sir,,looking forward for more 👍👍

[@saurabhgulati3480]

Great

[@sijimathew9982]

wow...... You made my life easy....

[@adityac2290]

kudos to "kud" venkat ...Well organized, easy to understand tutorials.

[@nimeshambalalpatel3032]

My Pranams to you Vankat sir!

[@Tommietusindbuks]

I just discovered you canal, absolutely love your simple way of explaning things. Keep up the good work

[@mummz3371]

Pays extra attention when Venkat says "Look at this"

[@aishwaryaghosh7251]

Going through your videos the night before interview.. excellent work sir🙂

[@gullidickson]

hi venkat thank you for all your videos which are really helpful and I can understand better., i learned MS SQL Server 2008 few weeks back and now ur videos are helping me to update and understand better. Regards Dickson.

[@soma9883]

BTW you're so cute when you say "you know..."

[@siddharthmishra3937]

😂😂 lol

[@aarushigupta7258]

Sir u r doing a great great job... Really... 😊😊 Thnku so so much ...

[@raisabhanumohammed314]

Thank you Venkat!!

[@wasimakramkhan2822]

Hello Kudvenkat, i have been following your tutorials for SQL server. It has very good content and your teaching style is very user friendly..... I wan to know if you are going to make videos on Python?

[@abhishekarora5422]

Amazingly crafted and delivered, cheers!

[@armsolutions1165]

Ma Sha Allah it Goods for those who Learn SQL in very Depth. Excellent Lectures for all Students. #Pakistan.

[@karthikkarki1849]

Thank you for this index information. Please answer for the question that How many clustered index should be there in a Table and why....?

[@nayanmakwana7388]

Really good one , Thanks for sharing this.

[@ssheel]

Very Well Explained

[@jyotikushwaha218]

Wow...what a great explanation to each and every concept..it's really Vry helpful..thanks for this This is very 🆒..may God bless u

[@data9051]

such good content. thanks

[@2Fast4Mellow]

One major difference between a unique constraint and a unique index is that the latter supports included columns and can be filtered.

[@MH_Sandeep]

very good explanation... Thank you

[@neerajagandla4366]

Hi very well explained. what are non-unique indexes? can we create index on a column that has duplicate values? what happens when we do so?

[@yv7363]

Hello ! I love your videos, you make it very easy to understand. However, could you explain the purpose of Non-Unique Indexes or where or how is it used ?

[@MrPrince750]

Used mainly in bulk important tools.

[@9970tt]

Thanks a lot It is the most organised and well presented video. just One correction on this video session the sql command sp_helpindex tblEmployee generate error message i think the table name should be inside single quote like sp_helpindex 'tblEmployee'

[@bsarun7266]

yes bro iam also found the error.but with single code also not working (sp_helpindex 'tblEmployee')

[@Krishna-pk9up]

Thanks....that's great bro

[@omarnajmi4471]

Thank you very much

[@Csharp-video-tutorialsBlogspot]

Thank you very much for taking time to give feedback. I am really glad you found these videos useful. If you want to receive email alerts, when new videos are uploaded, please feel free to subscribe to my youtube channel. May I ask you for a favour. I want these tutorials to be helpful for as many people as possible. Please free to share the link with your friends and family who you think would also benefit from them. If you like these videos, please click on the THUMBS UP button below the video

[@alaaabdelfatah]

Thanks alot

[@ssiseli7561]

Thanks for the videos..I am a begginner in SQL SERVER and MSBI .What is the difference between Unique clustered index and non unique clustered index

[@malharjajoo7393]

At 10:02 - I think it is important for you to explain that by "key" here you mean the key of the index that is created behind the scenes

[@Felixantony84]

Great ... Thank you

[@ALPCOD]

Thanks Sir.

[@stutitehri993]

Nice explanation .thanks Sir.

[@shashikantmishra477]

Great sir...

[@mayanknaithani]

Thank you very much venkat

[@Me.anything]

The way you explain.. i can say that you are Dronacharya of c#. :)

[@siddeshbagali13]

awesome way of explanation..!

[@Csharp-video-tutorialsBlogspot]

Hello Siddesh - Thank you very much for the feedback. Means a lot me. I have included all the jQuery tutorial videos, slides and text articles in sequence on the following page. Hope you will find it handy. www.pragimtech.com/courses/sql-server-tutorial-for-beginners/ When you have some time, can you please leave your rating and valuable feedback on the reviews tab. It really helps us. Thank you. Good luck and all the very best with everything you are doing.

[@tilaw09]

Good work sir.

[@54321anas]

thank you can you expline how partition table in sql to increase performance

[@hungcao1342]

nice !

[@anilkumarmalipatil3162]

primary key and unique key constraints uses indices to enforce the uniqueness of the record - is it same for other relational databases??

[@elenelenaelena8846]

Please give an example when should you be creating a Unique constraint and when data integrity is the objective.

[@mallamraj8355]

thanks much.

[@sapramprasannakumar8616]

please do course on python tutorial bro

[@colombuzz8550]

And how to validate the performance after index and before index? Please comment this will be helfull!!!

[@krismaly]

Concept is clearly explained. I didn't see that you didn't define NonClustered Index, why? Thanks anyways

[@Csharp-video-tutorialsBlogspot]

Hi Jayashree, Thank you very much for taking time to give feedback. I am really glad you found these videos useful. If you want to receive email alerts, when new videos are uploaded, please subscribe to my youtube channel. May I ask you for a favour. I want these tutorials to be helpful for as many people as possible. Please free to share the link with your friends and family who you think would also benefit from them. Good Luck.

[@paladugu1000]

Thanq

[@The1989rahul]

Can we change the Sort Order (i.e from Asc to Desc)of the default Unique Cluster index which is created on Primary Key Column.?

[@gullidickson]

hi venkat Sir Please can u send me some of interview questions on Indexes, T-SQL Statements, Stored Procedures, backups, recovery,Replications and performance tuning? Thanks Dickson gulli

[@Csharp-video-tutorialsBlogspot]

Thank you very much for taking time to give feedback. I am really glad you found these videos useful. If you want to receive email alerts, when new videos are uploaded, please subscribe to my youtube channel. May I ask you for a favour. I want these tutorials to be helpful for as many people as possible. Please free to share the link with your friends and family who you think would also benefit from them. Good Luck.

[@HemanthHemu]

Hi Venkat what about NoN UniQue IndeXes...

[@VipulKumar-xf8uh]

Can we have primary key and on the same table can we create a unique clustered index

[@naveenreddy2059]

when we are creatig clustred indexes ,why we need unique clustred indexes ,if we crete clustred index ,it auomatically gives uniqueness

[@satishgarepalli5977]

Her unique constraint and unique key what is the difference?

[@harikanilla8969]

when i deleted my clustered index it is throwing me an error when trying to get the data from table saying"The query processor is unable to produce a plan because the index 'PK__Employee__3214EC07821E96D8' on table or view 'Employee' is disabled.". how to resolve this?

[@SatishKumar-yi8qi]

when a primary key is created it automatically creates a unique clustered index for that column. but when I created a uniques clustered index on one column say for name column and then altered the table to have primary key on ID column it is allowing. but I should get error when i try to make a column as primary key. As creation of primary key will try to create a unique clustered index on ID. Can you please explain this.

[@StClair90]

I did the same and it deleted my clustered index, replaced it with the column on which i set the PK

[@manikandanr1966]

HOW TO EXEC A INDEX ..AND HOW WE CAN FIND,ITS FINDS DATA QUIKLY?

[@malharjajoo7393]

So basically, primary key and unique constraints are backed by indexes

[@ashishkumar6084]

We are creating a constraint but items are reflecting in the Indexes and Keys folder, not in constraints ..lol.. woowwww ! Microsoft.

[@rishavraj3127]

Sir, where is non -unique index??🙄🙄🙄

[@somensingh1817]

No clarity in explaination.. That's why so few comment. I don't understand what are you saying.. index has no use ..if I believe in what u are explaining. Useless ..just doing work without making us understand..just doing timepass

[@malharjajoo7393]

Thumbs up if you are annoyed by the Udemy course ads