I have received so many emails from all of you to create a video on the topic of SQL SERVER – Hide Code in SSMS. Here is the video on the topic.
SQL SERVER – Hide Code in SSMS
Today we are going to learn something very simple but asked a lot by all of you as well as my client is that how to hide code in SSMS.
SQL SERVER – CHECK CONSTRAINT to Allow Only Digits in Column
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.
What is N in nvarchar? – Interview Question of the Week #301
Question: What is N in nvarchar?
Answer: n in nvarchar or nchar stands for world national. Let us learn today about datatypes.