Article Library, Page 5
Every Red9 article in one place, most recently updated first. Written by the senior DBAs who do the work.
- articles
- 208
- categories
- 6
All Articles
Case Study · SQL Server Performance TuningHow We Made T-SQL Queries 8 Times FasterDiscover a simple optimization trick that slashed SQL query execution time from 180 to just 23 ms. Read the full step-by-step guide!
Case Study · SQL Server Performance TuningHow We Made T-SQL Queries 4 Times FasterDiscover a simple optimization trick that slashed SQL query execution time from 142 to just 32 ms. Read the full step-by-step guide!
Case Study · SQL Server Performance TuningHow We Boosted SQL Performance by 40xDiscover a simple optimization trick that slashed SQL query execution time from 40s to less than 1s. Click to read the full step-by-step guide!
Case Study · SQL Server Performance TuningHow We Made T-SQL Queries Run 11 Times FasterDiscover a simple optimization trick that slashed the number of disk operations from over 72M to less than 1M. Read the full guide!
Case Study · SQL Server Performance TuningHow We Made T-SQL Queries Run 51 Times FasterDiscover a simple optimization trick that slashed SQL query execution time from 8,656 ms to just 171 ms. Read the full step-by-step guide!
Case Study · SQL Server Performance TuningHow We Made T-SQL Queries Run 354 Times FasterDiscover a simple optimization trick that slashed SQL query execution time from 44 to almost 1 sec. Read the full step-by-step guide!
Case Study · SQL Server Performance TuningHow We Made T-SQL Queries 562 Times FasterDiscover a simple optimization trick that slashed SQL query execution time from 3,420 to just 30 ms. Read the full step-by-step guide!
Case Study · SQL Server Performance TuningHow We Made T-SQL Queries Run 678 Times FasterDiscover a simple optimization trick that slashed SQL query execution time from 31 sec to under 1 sec. Read the full step-by-step guide!
Case Study · SQL Server Performance TuningHow We Made a T-SQL Query 45 Times FasterDiscover a simple optimization trick that slashed SQL query execution time from 31sec to under 1sec. Read the full step-by-step guide!
Case Study · SQL Server Performance TuningHow We Made T-SQL Queries 38 Times FasterDiscover a simple optimization trick that slashed SQL query execution time from 38sec to under 1sec. Read the full step-by-step guide!
Case Study · SQL Server Performance TuningHow We Made T-SQL Queries Run 589 Times FasterDiscover a simple optimization trick that slashed SQL query execution time from 227 to just 1 ms. Read the full step-by-step guide!
Case Study · SQL Server Performance TuningHow We Made a T-SQL Query 9 Times FasterDiscover a simple optimization trick that slashed SQL query execution time from 34 to less than 4 sec. Click to read the step-by-step guide!
Client Result · SQL Server Performance TuningHow We Made a T-SQL Query Run 17,000x FasterDiscover how an easy optimization trick dropped execution time of a SQL query by over 17k times! Solved blocking and high CPU usage.
Guide · SQL Server TipsWhy Should You Care About CLR Integration in SQL Server?SQL Server CLR integration lets you run .NET code in your database. Check whether it's enabled and review the permissions before using it.
Guide · SQL Server Performance TuningTop 10 SQL Server Performance Tuning MistakesThe 10 performance mistakes we see most on SQL Server, from bad indexes to wrong MAXDOP, and the quick fix for each. How many are you making?
Guide · SQL Server Health CheckHow to Check MaxDOP in SQL Server and Set It for Optimal PerformanceThe right MaxDOP stops parallel queries from choking your CPU. Microsoft's formula, how to check your current setting, and when you should change it.
Guide · SQL Server Performance TuningWasting CPU for Implicit Conversions in SQL ServerImplicit conversions waste SQL performance. What they are, why should you care, how to detect and how to fix implicit conversion problem in SQL Server.
Guide · SQL Server Migrations & UpgradesTwo Most Important Decisions in Disaster Recovery – RPO and RTORPO and RTO define how much data you can lose and how fast you can recover. Learn how to set them, test them, and avoid DR planning mistakes.
Guide · SQL Server Performance TuningUntrusted Foreign Keys and Constraints Can Degrade Your SQL Server PerformanceUntrusted foreign keys and check constraints quietly block the optimizer from skipping work. How to find them, and the command that re-trusts them.
Guide · SQL Server Performance TuningStored Procedures and RECOMPILE Option: When and Why to Use ItExplore the WITH RECOMPILE option, its impact on performance, and how to identify stored procedures that use it. Learn when to use this option.
Guide · SQL Server SecurityWhy Should You Care About Users With Elevated Permissions in SQL Server?Learn how to identify and manage elevated permissions in SQL Server to enhance security and follow best practices for least privilege access.
Guide · SQL Server TipsWhy the Database Compatibility Level Matters in SQL Server?The compatibility level is a setting for each database that adjusts specific behaviors to align with a particular SQL Server version.
Guide · SQL Server Migrations & Upgrades[Step-by-Step Guide] Configure Azure Managed Instance Replication to On-Premises SQL ServerLearn how to configure Azure SQL Managed Instance replication to on-premises SQL Server with this complete guide. Ensure optimal data synchronization.
Guide · SQL Server Health CheckTrace Flags in SQL ServerSQL Server trace flags are configuration handles that can enable or disable a specific SQL Server characteristic or change a particular SQL Server behavior.
Guide · SQL Server Performance TuningSQL Server Performance Has Been Tuned, but What I Got Is “I Cant Feel It!” Wait! What??SQL Server tuning looks good on paper, but your app still feels slow? Compare CPU and logical reads, then look for the next bottleneck.
Guide · SQL Server Performance TuningBest Practices for SQL Server StatisticsDiscover essential SQL Server statistics best practices to boost query speed, and optimize performance with Red9’s expert tips.
Guide · SQL Server TipsSQL Server Shrink: Best PracticesLearn why SQL database shrink is a bad idea and when it's necessary. Follow expert guidelines for safe and effective shrink operations.
Guide · SQL Server Health CheckSQL Server Remote Dedicated Admin Connection (DAC)It’s a diagnostic connection for a database administrator to access SQL. The DAC can make remote troubleshooting easier when SQL Server is unresponsive.
Guide · SQL Server Migrations & UpgradesBest Practices for SQL Server Availability on Amazon RDSAmazon RDS is a fully-managed database service that allows you to provision and run relational databases in the cloud
Guide · SQL Server Migrations & UpgradesSQL Server on Amazon RDSAmazon RDS is a managed database service that makes it easy to provision and run relational databases in the cloud. It supports several relational engines
Guide · SQL Server TipsManaging SQL Server Objects with SET OptionsSQL Server backward compatibility SET options allow legacy T-SQL code to run on newer SQL Server versions without changes while supporting ISO SQL standards
Guide · SQL Server Migrations & UpgradesSQL Server Migration to Amazon RDS StrategiesWe talked about availability and security best practices on Amazon RDS. Completing the series of posts, today we will learn about Migration on Amazon RDS