Featured

SQL Server Performance Tuning: A Far From Almost Comprehensive Guide for the Curious Coder

Part 0 - Introduction and All That Stuff.... Hello, wonderful coders! Are you ready for another thrilling adventure into the world of technology? Today, we're diving deep into the mystifying and magical world of SQL Server performance tuning. That's right, my intrepid readers, we're about to unravel the secrets behind a faster, smoother, and more … Continue reading SQL Server Performance Tuning: A Far From Almost Comprehensive Guide for the Curious Coder

Featured

Setup a Simple Transactional Replication lab

At my former employer, one of the key components of our Business Intelligence environment was transactional replication of data between production and the Data Warehouse. Because this replication was critical to our reporting/BI pipeline, not to mention my livelihood, I wanted to dig into to how transactional replication works. As usual for me, the first … Continue reading Setup a Simple Transactional Replication lab

The Importance of Updating Statistics in SQL Server and the Challenges with Large Tables

As a database enthusiast and SQL Server aficionado, I've come across countless scenarios where performance was subpar and the underlying issues were obscured. Today, I want to shed some light on the importance of updating statistics in SQL Server and discuss why large tables with billions of rows might not be suitable candidates for auto-updating … Continue reading The Importance of Updating Statistics in SQL Server and the Challenges with Large Tables

Part 1: SQL Server Performance Tuning: A Far From Almost Comprehensive Guide for the Curious Coder

Section 1: Why Performance Tuning Matters – A Deeper Dive with Examples Ah, my knowledge-thirsty friend, you're in for a treat! Let's delve deeper into the significance of performance tuning and explore some examples to illuminate the benefits of this enigmatic art. Performance tuning is like casting a magic spell on your SQL Server, transforming … Continue reading Part 1: SQL Server Performance Tuning: A Far From Almost Comprehensive Guide for the Curious Coder

How I Learned to Stop Worrying and Add The Nonclustered Index

In my post about transactional replication we configured the dbo.Badges table for replication. Recall that this is a table that lives in the StackOverflow database.   Let's pretend that over time the production table we replicated has grown to billions of rows, and our reporting relies on hitting the dbo.Badges subscriber table in the SO_small … Continue reading How I Learned to Stop Worrying and Add The Nonclustered Index