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,577 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
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
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
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
A RAG pipeline that answers questions in the demo is not the same thing...
By Steve Jones
“A multitude of bad ideas is necessary for one good idea” – from Excellent...
Yesterday I gave a talk for MSSQLTips called “Building a DBA Agent for Your...
Comments posted to this topic are about the item Adding new column with DEFAULT
I've got a web application for my side business. I've added a SQL Server...
Comments posted to this topic are about the item Looking for New Blood
Which number will the COUNT() return after executing the following statements:
DROP TABLE IF EXISTS #test; CREATE TABLE #test (id INT) INSERT INTO #test (id) SELECT * FROM GENERATE_SERIES(1, 3) AS gs ; ALTER TABLE #test ADD flag BIT CONSTRAINT DF_#test_flag DEFAULT 0; go UPDATE #test SET flag = 0 WHERE id = 1 UPDATE #test SET flag = 1 WHERE id = 2 INSERT INTO #test (id) VALUES (4) SELECT COUNT(*) FROM #test AS t WHERE flag = 0See possible answers