There are so many different statuses of the processes in SQL Server. Let us learn today the difference between Sleeping vs Suspended Process.
My clients were not sure which SPs are the recent SP and which SP is no longer used. Today we will learn about the recent execution of the stored procedure.
After careful investigation, we figured out the cause for not auto-updating statistics. Let us learn about that today with STATISTICS_NORECOMPUTE.
Today’s post is written by SQL Server Expert Brian Gale. Why SQL Server Doesn’t Give the Memory Back to OS? Let us learn an amazing concept.
Question: How to Find the IP Address of All SQL Server Connection?
I had recently received this question during a recent consultation.
The next task for us was to find out how many partitions so far has been created by the same partition function. Let us learn about that today.