My client during Comprehensive Database Performance Health Check. Today we will learn about CHECK CONSTRAINT to Allow Only Digits in Column.
Zoom in SSMS – SQL in Sixty Seconds #153
It is possible to zoom in the SSMS (SQL Server Management Studio). I was recently asked by my client if this is even possible during Health Check.
Transfer Schema of Table – SQL in Sixty Seconds #152
My client during the Comprehensive Database Performance Health Check. I created a video on the topic of Transfer Schema of Table.
Find a Table in Execution Plan – SQL in Sixty Seconds #151
While all other methods work fine, let us see how easily we can find this in an SSMS. Let us learn how to find a table in an execution plan.
150 Videos on SQL in Sixty Seconds
I am so happy to share with you that the other day when I posted Transactions and Variables – SQL in Sixty Seconds #150, I completed 150 videos.
SQL SERVER – Find a Table in Execution Plan
Of course yes, we can easily find a table in the execution plan with the Find Node feature of SSMS (SQL Server Management Studio).
Transactions and Variables – SQL in Sixty Seconds #150
Transactions and Variables both are not related at all. There is no impact of a transaction on a variable. Let us learn about it today.