Every single time when I go for Comprehensive Database Performance Health Check, I get many different questions from the users. However, there are some questions which are very common and I have started to build a list of the such questions so I can share the same with you. Today’s question is about the Stored Procedure Execution Count.
SQL SERVER – How to Create Table Variable and Temporary Table?
This is a very simple question and indeed many of us know about this one. However, if you are absolutely beginner, you will for sure need help with this one. Let us understand how we can create a table variable and temporary table in this simple tutorial.
SQL SERVER – Configure Stored Procedure to Run at Server Startup – Simple Tutorial
One of the most popular questions I received during my SQL Server Performance Tuning Practical Workshop is how users can run sets of procedure when their SQL Server starts automatically. Today, let us see a simple tutorial to run stored procedure at server startup.
SQL SERVER – RETAINDAYS Does Not Delete Backup After x Days
Just the other day one of my customers asked me that they are facing a situation where they have specified in their backup script RETAINDAYS option but it is actually not deleting their older database backups.
SQL SERVER – 5 Don’ts When Database Corruption is Detected
Here is an email I received about database corruption and that has lead me to write this quick blog post about database corruption.
SQL SERVER – How to Delete a Single Table From SQL Server Backup File (.bak)
Question: How to Delete a Single Table From SQL Server Backup File (.bak)?
SQL SERVER – How to Enable Backup Compression On by Default
In this blog post we will discuss how to Enable Backup Compression on by default.