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
classic explanation sir!!keep on sharing your knowledge. every topic you share is drilled deep into my mind..i really appreciate your explanation skills..
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.
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.
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.
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!
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.
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?
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 ?
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'
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.
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
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.
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?
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
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
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..
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.
Still one of a kind Decade later, thank you very much, sir!!!
Really Nice videos...from long time I was searching SQl videos...Excellent job...Thank you very much...
Hi Venkat great work. Really no one could explain things better than this!! Keep Going!
I must say.....All Videos till now very very helpful for us....Thanks for all....
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.
some people just show you that life is still okay ...and you are one of them Sir , thank you
Revisiting to refresh my memory.
Thanks a bunch
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.
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!!!!!
I just discovered you canal, absolutely love your simple way of explaning things. Keep up the good work
Hi sir,,thank you so much ,,your explanation is soo good,really appreciate 👏🏻👏🏻keep on sharing your knowledge sir,,looking forward for more 👍👍
thankyou sir, its a best way to understand by practically and enough therotically
My Pranams to you Vankat sir!
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.
This is very important video and defaults explained very well.Thanks a bunch
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?
kudos to "kud" venkat ...Well organized, easy to understand tutorials.
Sir u r doing a great great job... Really... 😊😊 Thnku so so much ...
Going through your videos the night before interview.. excellent work sir🙂
Amazingly crafted and delivered, cheers!
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
wow...... You made my life easy....
Thank you Venkat!!
Thank you for this index information.
Please answer for the question that How many clustered index should be there in a Table and why....?
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.
BTW you're so cute when you say "you know..."
😂😂 lol
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?
such good content. thanks
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')
Really good one , Thanks for sharing this.
Very Well Explained
Pays extra attention when Venkat says "Look at this"
Thanks....that's great bro
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
Great
very good explanation... Thank you
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
Ma Sha Allah it Goods for those who Learn SQL in very Depth. Excellent Lectures for all Students. #Pakistan.
primary key and unique key constraints uses indices to enforce the uniqueness of the record - is it same for other relational databases??
Thank you very much venkat
Nice explanation .thanks Sir.
The way you explain.. i can say that you are Dronacharya of c#. :)
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
Great ... Thank you
One major difference between a unique constraint and a unique index is that the latter supports included columns and can be filtered.
Good work sir.
Please give an example when should you be creating a Unique constraint and when data integrity is the objective.
Hi Venkat what about NoN UniQue IndeXes...
Great sir...
Thanks alot
Thanks Sir.
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.?
Concept is clearly explained.
I didn't see that you didn't define NonClustered Index, why?
Thanks anyways
Can we have primary key and on the same table can we create a unique clustered index
nice !
thanks much.
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
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
And how to validate the performance after index and before index? Please comment this will be helfull!!!
please do course on python tutorial bro
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?
Thanq
when we are creatig clustred indexes ,why we need unique clustred indexes ,if we crete clustred index ,it auomatically gives uniqueness
Her unique constraint and unique key what is the difference?
HOW TO EXEC A INDEX ..AND HOW WE CAN FIND,ITS FINDS DATA QUIKLY?
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.
Sir, where is non -unique index??🙄🙄🙄
Thumbs up if you are annoyed by the Udemy course ads
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