The effects of DISTINCT in a SQL query
Earlier today, I had a great Twitter conversation with Tim Mitchell (@Tim_Mitchell), Jorge Segarra (@SQLChicken), and Jack Corbett (@unclebiguns) about...
2009-07-24
2,151 reads
Blog Posts
Book Review: The Candy Bombers: The Untold Story of the Berlin Airlift and America's Finest Hour
Found The Candy Bombers: The Untold Story of the Berlin Airlift and America's Finest Hour by Andrei Cherny ($20 @ Amazon) ...
2009-07-23
547 reads
Gadget Man
I'm searching for a new laptop bag. After getting a backpack from Microsoft and using it on a few trips,...
2009-07-23
867 reads
Perfect Game
They rarely happen, just a few in my lifetime, and I saw a portion of one years ago in a...
2009-07-23
628 reads
So You Want To Meet People At PASS…But What Do You Say?
Going to the PASS Summit this November? Let's fast forward and pretend it's November 2. You've made it to Seattle...
2009-07-23
516 reads
SSIS Expressions Basics
For those that are new to SSIS, using expressions may seem very foreign and unpleasant. Not only is it a...
2009-07-23
864 reads
The Kindle Flack
There have been so many reports and debates about the Kindle debacle in the news. I saw an interesting one...
2009-07-23
1,227 reads
Watch Your Repairs
Apparently PC repair people have learned a few things from auto mechanics of the past. A news group in the...
2009-07-23
622 reads
Database Mirroring - Hitting the Limits
When I first heard about database mirroring in 2004, I was excited. Here was a great new feature that would...
2009-07-22
4,382 reads
Featured Blogger: Glenn Berry
This month I’m featuring Glenn Berry, a Denver based MVP that writes Glenn Berry's SQL Server Performance blog. He blogs...
2009-07-22
728 reads
Blogs
ISACA AI Material/Exam Prep Discount (May 18 – June 30, 2026)
By Brian Kelley
If you are considering any of the ISACA AI certs like the Advanced Artificial...
A Fabric solution can be very cost effective
By ChrisJenkins
Are you currently using Microsoft Fabric or considering migrating to it? If so, there...
Track SQL Server Configuration Changes Using the Error Log
By SQLPals
Track SQL Server Configuration Changes Using the Error Log If you...
Forums
Before Using AI with Business Data, Read This
Artificial intelligence tools are quickly becoming part of daily business operations, from document analysis...
Designing SQL Server ETL Pipelines That Don't Break at Scale
Comments posted to this topic are about the item Designing SQL Server ETL Pipelines...
Detecting Deadlocks Quickly
Comments posted to this topic are about the item Detecting Deadlocks Quickly
Question of the Day
Detecting Deadlocks Quickly
In the Database Engine, when a deadlock is detected, what does the detection interval shrink to (in time)?
See possible answers