In this video, you will learn to use RANK() function in SQL Server. RANK () is one of the four Ranking Functions that are available in SQL Server. 1. ROW_NUMBER() 2. RANK() 3. DENSE_RANK() 4. NTILE(N) In one of our previous videos we have already discussed about ROW_NUMBER() function, you can watch that video here: https://youtu.be/mihn6z5sLo0
In this video, you will learn to get back truncated data using backup and restore mechanism.
There are many ways of monitoring SQL Server pressure. Here is a quick demo.
When you have dozens of databases hosted in a single instance, it helps to narrow down on databases that are contributing towards maximum IO reads and writes. In other words we are trying to narrow down on databases that are consuming maximum IO.