Index on a Foreign Key?
About two weeks ago, I had a discussion on Twitter and via email with Jeremiah Peschka (@peschkaj) about placing indexes...
2009-10-06
657 reads
Blog Posts
More SQL Server Benchmarks From AnandTech
AnandTech has another I.T. oriented post up comparing the performance and value of two-socket servers to four-socket servers. The gist...
2009-10-06
806 reads
My Journey - Part II
This is part II of my journey to being a DBA. I was "tagged" by Jacob Sebastian, so I decided...
2009-10-06
925 reads
PASS Editorial for Oct 7, 2009
I currently write the editorial for the PASS Connector which is published every two weeks as part of my role...
2009-10-06
338 reads
Perth SQL Server Users Group is Second Stop in Australia
On Friday, October 3, I spoke a second time at Perth, this time at the Perth SQL Server Users Group....
2009-10-06
359 reads
Perth SQL Server Users Group is Second Stop in Australia
On Friday, October 3, I spoke a second time at Perth, this time at the Perth SQL Server Users Group....
2009-10-06
631 reads
Rant: Cold Calls Are So Twentieth Century
I hate cold calls from vendors. Nothing gets my blood hotter than some vendor trying to call me when we...
2009-10-06
704 reads
[Tagged] Anatomy of a Geek
I got tagged by my buddy Michael Coles, aka Sergeant SQL to talk about how I "became" a geek. (I...
2009-10-05
349 reads
A Tale of Two Utility Companies
I live in Parker, Colorado, which is a suburb of Denver, about 25 miles southeast of downtown Denver. I have...
2009-10-05
612 reads
Ad Hoc Queries Don’t Reuse Execution Plans: Myth or Fact
Another frequently heard story is that stored procedures get and reuse execution plans, but ad hoc queries do not. A...
2009-10-05
3,205 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