Unique and Non Unique Indexes in sql server Part 37
Vložit
- čas přidán 21. 07. 2024
- In this video we will learn about
1. What is a Unique Index
2. Difference between unique index and unique constraint
Text version of the video
csharp-video-tutorials.blogspo...
Healthy diet is very important both for the body and mind. If you like Aarvi Kitchen recipes, please support by sharing, subscribing and liking our CZcams channel. Hope you can help.
/ @aarvikitchen5572
Slides
csharp-video-tutorials.blogspo...
All SQL Server Text Articles
csharp-video-tutorials.blogspo...
All SQL Server Slides
csharp-video-tutorials.blogspo...
All Dot Net and SQL Server Tutorials in English
czcams.com/users/kudvenka...
All Dot Net and SQL Server Tutorials in Arabic
/ kudvenkatarabic
The work you did 10 years ago is priceless.
hey man !!!you are absolutely brilliant !!! cant imagine how efficiently you have addded all the information here...toooo goood:) awesome !!!
classic explanation sir!!keep on sharing your knowledge. every topic you share is drilled deep into my mind..i really appreciate your explanation skills..
Hi Venkat great work. Really no one could explain things better than this!! Keep Going!
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
sir MASHALLAH THANK YOU SO MUCH YOUR SQL SERVER SESSIONS ARE MORE HELPING TO LEARN AND YOUR BLOG IS MOSTLY HELPING SIR
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.
Revisiting to refresh my memory.
Thanks a bunch
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!
Extra ordinary! Explained so nicely. Helps me understand the concept of clustered and non-clustered index. Thank yo so much!!!!!
Really Nice videos...from long time I was searching SQl videos...Excellent job...Thank you very much...
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.
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
I must say.....All Videos till now very very helpful for us....Thanks for all....
thankyou sir, its a best way to understand by practically and enough therotically
kudos to "kud" venkat ...Well organized, easy to understand tutorials.
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?
some people just show you that life is still okay ...and you are one of them Sir , thank you
I just discovered you canal, absolutely love your simple way of explaning things. Keep up the good work
This is very important video and defaults explained very well.Thanks a bunch
wow...... You made my life easy....
Amazingly crafted and delivered, cheers!
Still one of a kind Decade later, thank you very much, sir!!!
Going through your videos the night before interview.. excellent work sir🙂
Hi sir,,thank you so much ,,your explanation is soo good,really appreciate 👏🏻👏🏻keep on sharing your knowledge sir,,looking forward for more 👍👍
Really good one , Thanks for sharing this.
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.
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.
Sir u r doing a great great job... Really... 😊😊 Thnku so so much ...
Pays extra attention when Venkat says "Look at this"
very good explanation... Thank you
Nice explanation .thanks Sir.
Thank you Venkat!!
Great ... Thank you
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?
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.?
The way you explain.. i can say that you are Dronacharya of c#. :)
Great sir...
Thank you very much venkat
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
Thanks....that's great bro
Thank you for this index information.
Please answer for the question that How many clustered index should be there in a Table and why....?
Thanks Sir.
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 ?
Used mainly in bulk important tools.
One major difference between a unique constraint and a unique index is that the latter supports included columns and can be filtered.
BTW you're so cute when you say "you know..."
😂😂 lol
Good work sir.
primary key and unique key constraints uses indices to enforce the uniqueness of the record - is it same for other relational databases??
such good content. thanks
My Pranams to you Vankat sir!
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
thank you can you expline how partition table in sql to increase performance
Thanks alot
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'
yes bro iam also found the error.but with single code also not working (sp_helpindex 'tblEmployee')
Great
Very Well Explained
Please give an example when should you be creating a Unique constraint and when data integrity is the objective.
awesome way of explanation..!
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.
Thank you very much
thanks much.
Hi Venkat what about NoN UniQue IndeXes...
Concept is clearly explained.
I didn't see that you didn't define NonClustered Index, why?
Thanks anyways
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
Can we have primary key and on the same table can we create a unique clustered index
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.
I did the same and it deleted my clustered index, replaced it with the column on which i set the PK
Thanq
nice !
And how to validate the performance after index and before index? Please comment this will be helfull!!!
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?
when we are creatig clustred indexes ,why we need unique clustred indexes ,if we crete clustred index ,it auomatically gives uniqueness
HOW TO EXEC A INDEX ..AND HOW WE CAN FIND,ITS FINDS DATA QUIKLY?
Ma Sha Allah it Goods for those who Learn SQL in very Depth. Excellent Lectures for all Students. #Pakistan.
Her unique constraint and unique key what is the difference?
So basically, primary key and unique constraints are backed by indexes
We are creating a constraint but items are reflecting in the Indexes and Keys folder, not in constraints ..lol.. woowwww ! Microsoft.
Thumbs up if you are annoyed by the Udemy course ads
Sir, where is non -unique index??🙄🙄🙄
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