What is the data compression feature in SQL Server? It is a feature introduced in SQL Server 2008 Enterprise Edition. Later, Microsoft added to Standard

What is the SQL Server change trackings feature? Change tracking was introduced in SQL Server 2008 to help you sync data. It allows relatively easy

You’ve probably heard: “indexes are not free”. They are right! Indexes can greatly improve queries performance in the SQL server, but they may hamper the

What is the Query Store? The SQL Server Query Store is a feature introduced in SQL Server 2016. It provides you with insight on query plan choice

Description: Problem: Stored procedure takes 38 seconds to execute. It times out on the application front-end. It was performing multiple scans and reading too much

Description: Problem: This stored procedure showed up in the top resource-consuming report. It was putting too much stress on the CPU. Solution: Added two new

Description: Problem: Select command inside trigger (EHRHist<removed>_AFTER_INSERT_UPDATE) doing an index scan. Solution: Added an index. Command: Change: Before: After: Technical Background: Most SQL Servers bottleneck

Description: Problem: Slowness in the biling process. Solution: SQL code refactoring. Time to run stored proc before tuning: 34s Time to run stored proc after

Description: Problem: Slow procedure killing SQL Server performance Change: To improve the stored procedure performance, we created four views. Also, we made changes to the

Description: Problem: Slow stored procedure Notes: After making couple of small tweaks to the SQL Server stored procedure we were able to get few improvements:

Problem: Slow stored procedure 75,336% improvement in stored procedure performance! Notes: Improvements achieved: • CPU from 18,922 to 1,249 • Reads from 12,850,589 to 18,532