around 13:35 you are saying cost threshold value will be in seconds like value 5 its not about time in seconds its about query subtree cost, Sql server will decide whether it can run in parallel or not based on cost threshold value if query cost is greater than 5 which is default value then it will run in parallel based on MAXDOP value, If its 0 it will use all the processor if need.
@@nagaraj09021993 Thank you so much for taking your time for writing this but seems like your answer is very similar to my answer what I have said in the video. Anyway thanks for your suggestion I will check that again and I will correct it in my next video.
I am grateful that you uploaded these videos; they are excellent for preparing for interviews.
Such a inspring video uploaded being a DBA, please keep up the good Job.
please do more videos like that tq we will support always your channel
Sure 😊
Seriously Helpfull 👍👍
around 13:35 you are saying cost threshold value will be in seconds like value 5 its not about time in seconds its about query subtree cost, Sql server will decide whether it can run in parallel or not based on cost threshold value if query cost is greater than 5 which is default value then it will run in parallel based on MAXDOP value, If its 0 it will use all the processor if need.
@@nagaraj09021993 Thank you so much for taking your time for writing this but seems like your answer is very similar to my answer what I have said in the video. Anyway thanks for your suggestion I will check that again and I will correct it in my next video.
Please upload new interview videos
Excellent
Thank you :)
💥💥💥Wow excellent😮😮
Thank you 🙏 kindly share yur suggestions and imputes to upload more videos 😊
@solved pages
Upload SQL developer mock interview as well having 2,3years of experience
@@shahrukhpatel9333 Sure, we will upload them soon
Good One..
Thanks ✌️
Nice
Thank you 🙏 and you
Hi bro