Patience game strong! It's all part of the interview dance. You never know when that lightbulb moment will happen. 💡 Maybe next time, they'll surprise us with an answer that'll blow our minds! 😂. More over i would like see this as technical conversation instead of mock interview.#MockInterviewAdventures.
These mock interviews r helping too much ..i got many new scenario based questions and correct resolution steps ... If we go through these mock interviews ..can help us to crack interviews for sure 💯 thank u very much ...
Hi Vijay Deadlock in SQL Server occurs when two or more transactions are blocked, each waiting for the other to release a lock. The term "SPID" refers to a SQL Server Process ID, which is a unique identifier assigned to each connection to the SQL Server instance Handling deadlocks generally involves identifying the cause and taking appropriate actions to resolve the issue. However, if you are specifically asked about a "single SPID deadlock," it might be a bit of a misnomer. Deadlocks typically involve at least two SPIDs. Seems it is like Single-thread deadlocks can occur when a thread attempts to take a lock that it already owns as per microsoft document. learn.microsoft.com/en-us/windows-hardware/drivers/devtest/deadlock-detection Thanks & Regards MS SQL DBA TECH SUPPORT
You know he don’t k ow the answer, but still explaining and asking 2 -3 times! You got the patience! 😂
Patience game strong! It's all part of the interview dance. You never know when that lightbulb moment will happen. 💡 Maybe next time, they'll surprise us with an answer that'll blow our minds! 😂. More over i would like see this as technical conversation instead of mock interview.#MockInterviewAdventures.
I have recently started taking interviews and your videos are pretty helpful to determine on how to go about it.
That's fantastic to hear! I'm glad to know that you find the videos helpful!.
These mock interviews r helping too much ..i got many new scenario based questions and correct resolution steps ... If we go through these mock interviews ..can help us to crack interviews for sure 💯 thank u very much ...
Thanks for the compliment
Perfect Mock Interview..
Thanks
Your videos are awesome.
Can you please share SQL DBA what's app group link to discuss doubts?
Thanks,
For some reasons we are not maintaining any whatsapp groups
Superb questions
Thanks
What is power she'll script to find servers are up and running or not
Here is the video and script too
ua-cam.com/video/vWXGjRP7a8s/v-deo.htmlsi=e321T2Ewm3LMPouU
And yesterday o faced one interview there asking single spid deadlock
Hi Vijay
Deadlock in SQL Server occurs when two or more transactions are blocked, each waiting for the other to release a lock. The term "SPID" refers to a SQL Server Process ID, which is a unique identifier assigned to each connection to the SQL Server instance
Handling deadlocks generally involves identifying the cause and taking appropriate actions to resolve the issue. However, if you are specifically asked about a "single SPID deadlock," it might be a bit of a misnomer. Deadlocks typically involve at least two SPIDs.
Seems it is like Single-thread deadlocks can occur when a thread attempts to take a lock that it already owns as per microsoft document.
learn.microsoft.com/en-us/windows-hardware/drivers/devtest/deadlock-detection
Thanks & Regards
MS SQL DBA TECH SUPPORT
❤
Thanks
I need an DBA
Use below link to join the MS SQL DBA whatsapp group and ask technical doubts what u had
chat.whatsapp.com/L8QlUf0zRCO8v0YiG7cC1r
😊😊
😊😊😊
😀
P AA
😀