Devendra-Techs

  Hello,   Today’s blog is going to be an interesting one. Many of us might be aware about SSMS shortcuts. If not then please go through this blog. In this blog I am going to share which shortcuts I often use and how we can have customized shortcuts. In SSMS we have many default shortcuts for quick actions and better interaction. I often use below default shortcuts while working on SQL server. Keys Action Alt+F1 Execute SP_HELP Ctrl+R Show/Hide query result Ctrl+M Include actual execution plan. Ctrl+L Display estimated execution plan. Shift+Alt+S Include client statistics Ctrl+K AND Ctrl+C Comment out selected line Ctrl+K AND Ctrl+U Uncomment selected line   Apart from this there are many shortcuts which we can use to add more fun. Please find below URL for more shortcuts. SQLServer Man...

  Recently I got into one discussion regarding installation of CU / Patching post SQL server installation. The point of debate was do we need to install all CUs or latest one only. I heard statement from one of my team mate that, we need to install all CUs post SQL server installation. I asked him about his understanding regarding CUs. He replied that he has been following this practice because his senior said. I said fine and later I shared my blog “ What’s the difference between a hotfix, cumulative update, Service Pack, and Feature Pack? ” If you go through this blog then you will come to know that, CU (Cumulative Update) contains all previous fixes. Hence, we do not need to install each and every CU post SQL server installation. Only Install latest CU. Ex: Latest CU of SQL server 2019 as on date 18th Apr 2022 is CU16. If SQL server is on CU12 then no need to apply all CUs from 12-16. Only installation of CU16 will be fine. Thank You.