Let us learn how to store non-English Characters in SQL Server tables. You will learn in this video the major difference between VARCHAR and NVARCHAR.
Nested Transactions are Myth – SQL in Sixty Seconds #125
Many sent me an email that they want to know more about the nested transactions. Let us learn about them in today’s blog post.
Dropping Temp Table in Stored Procedure – SQL in Sixty Seconds #124
Is dropping temp table in stored procedure code really needed? In this SQL in Sixty Seconds video, I compare two procedures to show what happens.
25 Recent SQL in Sixty Seconds Video
I have been recording SQL in the Sixty Seconds videos for many years. I would like to share my recent 25 SQL in the Sixty Seconds video.
CONCAT and NULL – SQL in Sixty Seconds #123
I have decided to convert the blog into the video of SQL in the Sixty Seconds. Let us learn about CONCAT and NULL – SQL in Sixty Seconds #123.
Sleeping vs Suspended Process – SQL in Sixty Seconds #122
There are so many different statuses of the processes in SQL Server. Let us learn today the difference between Sleeping vs Suspended Process.
Split Screen for SSMS Efficiency – SQL in Sixty Seconds #120
I often struggle to remember the changes done to the stored procedure and in this situation, the Split Screen of SSMS really comes very helping.