If you are watching this in year 3024 , i would like to tell you that this channel has the best videos available and this teacher is a god of teaching.
Venkat - I watched a bunch of your videos over the weekend. I have to say that these are really effective videos - concise and yet informative. Some of the things that I have struggled with in past have been put in such a simple way. I had to drop a line to THANK YOU for your work. Do you have anything on algorithms/data structures ?
Thank you very much for taking time to give feedback. This means a lot. I am very glad you found the videos useful. I have organised all the Dot Net & SQL Server videos in to playlists, which could be useful to you ruclips.net/user/kudvenkatplaylists?view=1&sort=dd If you need DVDs or to download all the videos for offline viewing please visit www.pragimtech.com/order.aspx Slides and Text Version of the videos can be found on my blog csharp-video-tutorials.blogspot.com Tips to effectively use my youtube channel. ruclips.net/video/y780MwhY70s/видео.html If you want to receive email alerts, when new videos are uploaded, please subscribe to my youtube channel. ruclips.net/user/kudvenkat If you like these videos, please click on the THUMBS UP button below the video. May I ask you for a favor. I want these tutorials to be helpful for as many people as possible. Please share the link with your friends and family who you think would also benefit from them. Good Luck Venkat
Hi Venkat , can u plz upload videos on Transaction Isolation Levels and and how to solve SQL deadlocks and blocking , ur videos r really informative and helpful , thnx for sharing ur valuable knowledge to all of us. Thanks in Advance :)
Hello Sir... No doubt, your tutorials are the best ... Could you be kind to tell me some negative examples of ACID? For each letter, bad thing that could happen because of atomic property of transactions , and when consistency of transaction could be bad ? For isolation property , bad things are dearty reads I suppose, for durability I guess the lost of transaction log file example... But what could possibly be bad about A and C ? It is a job interview question emergency :) Thanks a lot
Hi Sir, Many thanks for helping us. Can you please provide or upload some video for Sharepoint development. It will a great help for us if you kindly educate us on sharepoint.
I'm running Microsoft SQL Server Developer (64-bit) 2019, version 15.0.2070.41 on Windows 10 Pro. TRANSACTION_ISOLATION_LEVEL is ReadCommitted In one query window 1 I run this: begin tran update tblProduct41 set ProductName = 'Books-Test' where ProductId=1 In query window 2 I run this: select * from tblProduct41 where ProductId = 4 The select query never completes, until the transaction is query window 1 is either rolled back or committed. Has the meaning of isolation levels changed between the version Venkat is using (probably 2008) and 2019? Thanks.
hi sir this is me kiran as you help me every time a lot. i need one more fever from you is that i have done one application on pathology lab basis and now i want to make its marketing on 20 days trial base so what type of code i have to write to make my application expired after 20 day. or any other things,,,
Hi Venkat, I have one doubt on transaction ACID proprieties i.e as per durable property once change is made ,it is permanent .suppose if power failure or some system problem transaction as terminated in the middle,in that case how do it gets to its original state, is it stores previous state of the table some where in the server to get to its original state? why i am asking means as per this property changes made or permanent then how do it get to know about its previous state of table.
That's strange. So, when you run the select statement in another session/window, it waits for the update statement to commit which doesn't seem to be the case when you fire the same select statement in the session where you ran the update statement?
If you are watching this in year 3024 , i would like to tell you that this channel has the best videos available and this teacher is a god of teaching.
Hey there, I just wanted to say thank you for these tutorials. You speak very clearly and the videos are very informative and helpful.
Venkat - I watched a bunch of your videos over the weekend. I have to say that these are really effective videos - concise and yet informative. Some of the things that I have struggled with in past have been put in such a simple way. I had to drop a line to THANK YOU for your work. Do you have anything on algorithms/data structures ?
Good contribution to the world of Computer Professionals
Best videos on DBMS with practical example.easy to understand. thanks for sharing these videos...
It's a good way you repeat a lot of material. You are a great , really great teacher . Best teachers should learn from U!
Revisiting
Thanks for educating the community.
Thanks a lot
Awesome Video !!! I like it your style to tech us,
SIR PLZ UPLOAD TRANSACTION ISOLATION LEVELS.PLZ PLZ PLZ...
UR EXPLANATION STYLE IS AWESOME...
Nice demo Venkat. Thank you
excellent work as usual guys. thank you for this
thanks for all your sql videos... like your teaching style...😊
Thank you very much for taking time to give feedback. This means a lot. I am very glad you found the videos useful.
I have organised all the Dot Net & SQL Server videos in to playlists, which could be useful to you
ruclips.net/user/kudvenkatplaylists?view=1&sort=dd
If you need DVDs or to download all the videos for offline viewing please visit
www.pragimtech.com/order.aspx
Slides and Text Version of the videos can be found on my blog
csharp-video-tutorials.blogspot.com
Tips to effectively use my youtube channel.
ruclips.net/video/y780MwhY70s/видео.html
If you want to receive email alerts, when new videos are uploaded, please subscribe to my youtube channel.
ruclips.net/user/kudvenkat
If you like these videos, please click on the THUMBS UP button below the video.
May I ask you for a favor. I want these tutorials to be helpful for as many people as possible. Please share the link with your friends and family who you think would also benefit from them.
Good Luck
Venkat
superb tutor. hats off sir
nice explanation.....
Thanks a lot
Thanks for the explanation
Perfect content, Thank you
Thank you sir your work is great vary things is simple and clear thanks lotttttttttttttttttttttt
God bless you!
Hi Venkat , can u plz upload videos on Transaction Isolation Levels and and how to solve SQL deadlocks and blocking ,
ur videos r really informative and helpful , thnx for sharing ur valuable knowledge to all of us.
Thanks in Advance :)
solid presentation boss
Thanks Sir nice explanation
Happy Birthday to you venkat sir.
Hello Sir... No doubt, your tutorials are the best ... Could you be kind to tell me some negative examples of ACID? For each letter, bad thing that could happen because of atomic property of transactions , and when consistency of transaction could be bad ? For isolation property , bad things are dearty reads I suppose, for durability I guess the lost of transaction log file example... But what could possibly be bad about A and C ? It is a job interview question emergency :) Thanks a lot
Thank you sir.
Hi Sir, Many thanks for helping us. Can you please provide or upload some video for Sharepoint development. It will a great help for us if you kindly educate us on sharepoint.
Thanks it's good
I'm running Microsoft SQL Server Developer (64-bit) 2019, version 15.0.2070.41 on Windows 10 Pro.
TRANSACTION_ISOLATION_LEVEL
is ReadCommitted
In one query window 1 I run this:
begin tran
update tblProduct41 set ProductName = 'Books-Test' where ProductId=1
In query window 2 I run this:
select * from tblProduct41 where ProductId = 4
The select query never completes, until the transaction is query window 1 is either rolled back or committed.
Has the meaning of isolation levels changed between the version Venkat is using (probably 2008) and 2019?
Thanks.
great tutorial
sir please add some special video on case statement for different different areas
hi venkat ji,
pls upload video on isolation levels....
hi sir this is me kiran as you help me every time a lot. i need one more fever from you is that i have done one application on pathology lab basis and now i want to make its marketing on 20 days trial base so what type of code i have to write to make my application expired after 20 day.
or any other things,,,
if there is locking --how amazon like big comanies process transactions for orders? can you post video on it?
Hi Venkat,
I have one doubt on transaction ACID proprieties i.e
as per durable property once change is made ,it is permanent .suppose if power failure or some system problem transaction as terminated in the middle,in that case how do it gets to its original state, is it stores previous state of the table some where in the server to get to its original state? why i am asking means as per this property changes made or permanent then how do it get to know about its previous state of table.
whats the difference between consistancy and durable?
That's strange. So, when you run the select statement in another session/window, it waits for the update statement to commit which doesn't seem to be the case when you fire the same select statement in the session where you ran the update statement?
Please Upload Isolation Levels
still isolation level is read committed by default ?
hi venkat,can u post some videos related to SSIS , SSRS , SSAS...... thanq
good concept
Little confusion. Without transaction statement also data should be consistence.
Why no Audio
No audio..
hi sir i got a code for expiry period, sorry for trouble...
Anyone in 2025?