Would like to hear about BPT, human and automatic activities, using waits, using small time out and increasing them Would be great if demonstrate with an use case
Hey, great video! Quick question regarding the index, does indexing the orderId make much difference here? The quantity and productId makes sense to me, as they are directly used to fetched the 384 records from the order line, but the orderId is just used to join the order table right? As you seem to use the index, doesn't that mean that you fetch the 4000 rows from the order table first and then find the 384 rows from the order line table?
At the end of the video there's is PIVOT concept used, there exactly 6 months results are retrieved but i dont find any clause to restrict the query to get MM-1 to MM-6 Can you please explain why or the table itself having like results?
Need more deep dives from our friend Rui? Let us know what you'd like to hear about next!
Great information! Please, keep publishing. Thanks!
Very, Very Useful... Thanks for the content and please continue...
Thanks for the post! What about having the execution plan available in the development studio or other tool?
Thanks for the post, looking for more videos
Great video! Please keep posting SQL enhancement content, it's really cool and helpful
Would like to hear about BPT, human and automatic activities, using waits, using small time out and increasing them
Would be great if demonstrate with an use case
Thanks Rui Barbosa. Great content
Thanks a lot for sharing your knowledge with us.
Really good video, thanks for that
Really helpful.......Much appreciated....Cheers!
Hey, great video! Quick question regarding the index, does indexing the orderId make much difference here? The quantity and productId makes sense to me, as they are directly used to fetched the 384 records from the order line, but the orderId is just used to join the order table right? As you seem to use the index, doesn't that mean that you fetch the 4000 rows from the order table first and then find the 384 rows from the order line table?
Very informative video, please keep posting such video's.. really helpful 👍
At the end of the video there's is PIVOT concept used, there exactly 6 months results are retrieved but i dont find any clause to restrict the query to get MM-1 to MM-6
Can you please explain why or the table itself having like results?
Extremely useful insight, thanks ;)
Great post! Thanks!
could you please explain what is this - o1,o2,o3,o4,o5 and so on