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.
SQL SERVER – Datatype Decimal Explained – Datatype Numeric
Just the other day I received an email from a client who was confused about the Datatype Decimal. Let us learn today how it works.
SQL SERVER – Two Advantages of Sort in TempDB Options
A client of Comprehensive Database Performance Health Check asked me the advantages of enabling Sort in TempDB Options. Let us learn.