There is a way to find out few more things. However, before we continue I strongly suggest that you watch the following video about the dropped table.
Running Totals That Reset Every Month
Calculate running totals that reset by calendar month, customer, or fiscal period, using stable ordering and explicit ROWS frames.
Before You KILL a Session: Estimating the Rollback Cost
Before you KILL a session, inspect its transaction age, log bytes, current command, and likely rollback work, then monitor the undo safely.
Hide Code in SSMS – SQL in Sixty Seconds #154
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 SSMS (SQL Server Management Studio). A client asked me during a Health Check, so here is how to do it.