Too often, denormalization is suggested as the first thing to consider when tackling query performance problems. It is said to be a necessary compromise to be made when a rigorous logical design hits an inadequate database system. As the saying goes, “Normalize ‘til it hurts, then denormalize ‘til it works”. In reality, Denormalization always leads eventually to tears.
2008-07-28
7,924 reads
Steve Jones talks about how IT hasn't changed very much over the years and how your career might not be that different in ten years.
2008-07-27
64 reads
Steve Jones talks about how IT hasn't changed very much over the years and how your career might not be that different in ten years.
2008-07-27
60 reads
Application roles often interesting possibilities in theory. In practice? Brian explores how they work and some of the pros/cons you should consider before selecting them for use in your applications.
2008-07-25 (first published: 2003-08-27)
45,593 reads
SQL Server 2008 introduces the Database Backup Compression feature. This article describes how to take advantage of this new feature
2008-07-25
2,029 reads
Developers tend to be lazy in Steve Jones' view. This week he examines some of the problems that this lack of effort can cause in applications.
2008-07-25
222 reads
Developers tend to be lazy in Steve Jones' view. This week he examines some of the problems that this lack of effort can cause in applications.
2008-07-25
230 reads
Developers tend to be lazy in Steve Jones' view. This week he examines some of the problems that this lack of effort can cause in applications.
2008-07-25
487 reads
This article presents an excerpt from the book, Microsoft SQL Server 2005 Reporting Services Step by Step, by Stacia Misner and Hitachi Consulting. Learn how to monitor reporting services by implementing an execution logging database and reviewing reports that query that database.
2008-07-25
2,797 reads
Here the author introduces SQL Server Data Services, which exposes its functionality over standard Web service interfaces.
2008-07-24
2,158 reads
By Steve Jones
Software is hard. While I love our Lucid Gravity, I realize that they are...
By James Serra
Making Data AI-Ready, Part 2 (This is the second article in a three-part series...
By Steve Jones
Can you use your GPUs when running a local model under Ollama? You can,...
Comments posted to this topic are about the item Checking the Error Log II
Comments posted to this topic are about the item Parameter Sniffing on SQL Server...
Comments posted to this topic are about the item Designing for Teams
What is the reason I should change my old code that uses xp_readerrorlog?
See possible answers