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.
please do more videos like that tq we will support always your channel
Such a inspring video uploaded being a DBA, please keep up the good Job.
Please upload new interview videos
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.
💥💥💥Wow excellent😮😮
Thank you 🙏 kindly share yur suggestions and imputes to upload more videos 😊
Excellent
Thank you :)
Good One..
Thanks ✌️
Nice
Thank you 🙏 and you
Hi bro