Recently a good friend of mine asked me question whether is there any performance benefit in filtering the data out in subqueries, and then joining them. Well, answer
Hi Friends. If you are wondering if we should check [context_switches] counter for SQL Server Queries while performance tuning, then here is the official verdict from Paul Randal.
Recently as part of Server Migration, I had to move nested folders and files from Source server to Destination. This task becomes hard when directory has child folders