Question: Where is SQL Jobs Stored?
Answer: In MSDB Database in dbo.sysjobs table. Let us learn about it in today’s blog post.
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.
SQL SERVER – NULL Values and CONCAT Function
A lot of SQL in the Sixty Seconds video recently, we will be looking at a very interesting T-SQL CONCAT function and how it works with the NULL Values.
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.
Pinned Tab – SSMS Efficiency Tip – SQL in Sixty Seconds #121
Lots of people asked me to share the SSMS efficiency tip so I have shared the same in this blog post. Today’s topic is the pinned tab in SSMS for efficiency.
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.
Nonclustered Primary Key – SQL in Sixty Seconds #119
I will describe in detail a bit later on during this blog post. Today we are going to learn that it is possible to have a nonclustered primary key.Â