Installing SSDT (SQL Server Data Tools) 2019

The Business Intelligence platform has been changing on each new version. In the beginning, it was part of the SQL Server setup, and then since SQL Server 2014 started to be distributed separately. Also, the name of this tool and its installation method started to vary from version to version of Visual Studio (VS). For

How to fix Recovery Pending State in SQL Server?

This post will explain why a database operates in a RECOVERY PENDING state and show you some Methods to Fix it. These are technical processes. If you do not have the confidence to settle this problem, you can use our emergency SQL Support to help you do it in a simple and effective way. How to

Case study – Stored procedure 354 faster!

Here what can be done during a session of SQL performance tuning. Problem summary Slow store procedure. This query was running for a long time, causing a blocking chain and High CPU usage. What was done Added these two new indexes:   Total improvement As expected, the same output (result set) was presented by the original

Case study – Proactive action to prevent possible issues

This is an excellent example of what you can get by teaming up with our part-time SQL DBA Service provider. Our daily checks include many aspects of SQL Server and some aspects of hardware, such as CPU, memory, disk space, etc. This is a proactive action to prevent possible issues and problems that may cause

Case study – Stored procedure 181x faster

Here is another significant improvement. Problem summary Slow procedure killing SQL Server performance. The client was experiencing severe issues with the application stability. What we done To improve it, we created an indexed view to improve the store procedure performance. Total improvement Sometimes changes can make TSQL run 20,000% faster, sometimes 50%, other times slicing

Case study – Improving performance using indexes

Problem Summary The client is experiencing issues with SQL server performance. Two stored procedures that are run hundreds of times per hour were taking a long time to execute. What was done Simple. For this case, we created only a new index to improve both stored procedures. The first one: The another one: As soon

Case study – Removing a bad SQL query hint

Here what can be done when you have one of our DBA plans. The procedure below was extracted from a  stored procedure that was found during a database Assessment What was done We removed the MAXDOP hint. In this case, the procedure was refactored, but the dev team did not change this query hint.   The results

Case study – Tuning a slow report

Problem summary A report was taking a long time to complete. It was also causing deadlocks during the execution. What was done We started monitoring the SQL Server environment. A comprehensive methodology was applied to look at various levels SQL depended on: CPU, RAM, networking, storage, VMWare setup, Windows Operating System settings, and few more

Case study – Dealing with deadlocks

Problem Summary Two procedures were involved in 80% of deadlocks related to a third-party app. Deadlocks are a common problem handled by SQL Server automatically. Nevertheless, you have to make sure that you minimize deadlocks as much as possible because every rolled back transaction negatively influences your end-users. What was done To improve the stored

Best practices for SQL Server Installation

SQL Server installation does not often repeat, especially if you are using on-premises servers. In this article, you will see a few settings that are recommended to be reviewed after the SQL Server installation checklist. Preparation If possible, start with a freshly installed OS and install the latest drivers. Check if BIOS power management is

Microsoft SQL Server Management Studio (SSMS)

What is SSMS? SQL Server Management Studio (SSMS) is an integrated environment for managing any MS SQL Server infrastructure, from on-promise to an Azure SQL Database. It provides tools to query, design, and manage your databases and data warehouses, wherever they are – on your local computer or in the cloud. How to download installation

Database engine tuning advisor for MS SQL Server

What is a database tuning advisor? Changing database design to a proper one makes it to perform better. One of the performance-critical areas of databases is proper table indexing and their usage. Database tuning advisor helps to decide if existing indexes are correct and if new indexes are required. This tool does not require an