home | the book | the author | error log | q&a | my blog | recommended reading | feedback form
Error Log for Inside SQL Server 2005: Query Tuning and Optimization
Updated: 16 February 2008
Introduction
· Page xx, last line:
DELTE should be DELETE.
· Page xxi, second paragraph:
This paragraph seems to have been just copied from The Storage Engine volume. It describes that book’s role in the series, but it is not the book you are holding if you are reading the Query Tuning and Optimization book. It should say: “The Storage Engine volume covers SQL Server storage and retrieval of data.”
· Page xxiv, first paragraph, third line:
The URL for the companion Web site is hyphenated as it is split across two lines, which I think is a bad idea. There is no hyphen in the URL; it should be
www.InsideSQLServer.com/companion
Chapter 1
· Page 4, last paragraph:
"your application will need to more join operations…"
Should be: “… your application will need more join operations …”
· Page 7, near top of page, *Atomicity*
"Changes done under a transaction that are either all commit or are all rolled back"
Should be: “Changes made under a transaction are either all committed or are all rolled back.”
· Page 7, top of page, *Consistency*
" Changes done under a transaction database from one consistent state to another."
Should be: “Changes made under a transaction transform a database from one consistent state to another.”
· Page 8, last paragraph, first line:
"…cognoscente…" should be: “…cognizant...”
· Page 9, second paragraph, third line:
"..default isolation…"
Should be: “…default isolation level...”
· Page 9, third paragraph:
"..explore couple ways…"
Should be: “…explore a couple of ways...”
· Page 12, third paragraph
"..maximum degree of parallelism…"
Should be: “…the maximum degree of parallelism...”
· Page 12, fourth paragraph
"..affinity mask option…"
Should be: “…the affinity mask option...”
· Page 14, first paragraph, in the middle:
"..onTechNet…"
Should be: “…or TechNet...” [a space needs to be here in addition to the word change]
· Page 17, end of first paragraph:
“SQL Server Tracing and the SQL Server Profiler are discussed in much greater detail in Chapter 3.”
SQL Server Tracing and the Profiler are actually discussed in Chapter 2.
· Page 17, second paragraph, fourth line:
"..recommendations for use useful indexes…"
Should be: “…recommendations for useful indexes...”
· Page 18, second paragraph, first line:
“DMVs expose this information in relational format so that it can be accessed using familiar
paradigm, using Select statement…”
Should be: “…DMVs expose this information in a relational format so that it can be accessed using a familiar
paradigm, using a SELECT statement…”
· Page 18, third paragraph, second line:
"..with sysprocesses system table…"
Should be: “…with the sysprocesses system table...”
· Page 21, second line:
“…blocked on resource?”
Should be: “…blocked on some resource?”
· Page 21, Detection paragraph, seventh line:
"Unless SQL Server is the only application running out of the box,…"
Should be: ”Unless SQL Server is the only application running on the machine,...”
· Page 26, end of first paragraph:
“…it will lead more physical I/Os.”
Should be: “…it will lead to more physical I/Os.”
· Page 26, second paragraph, middle:
" …but note only 4GB of the referenced memory is actually in the RAM…"
Should be: ”… but only 4GB of the referenced memory is actually in RAM…”
· Page 26, second paragraph, three lines from the end:
" … there are two kinds memory pressures…"
Should be: ”… there are two kinds of memory pressure…”
· Page 27, fourth line:
"… by shrinking the tuffer pool…”
Oops… silly typo; this should have been caught by a spell checker. Of course it should be buffer pool, or else there’s a lot I don’t know about memory management.
· Page 50, second bullet:
"… if a useful index is missing, it may force transaction to read data …”
I probably should have an article in there: “… if a useful index is missing, it may force the transaction to read data …”
· Page 52, last paragraph, three lines above the code:
"… one or missing indexes …”
Should be: “… one or more missing indexes …”
Chapter 2
· Page 93, second paragraph, middle:
“…the HoBt (Hash or B-Tree) ID,”
If you’ve read the Storage Engine book, you’ll know what HoBT stands for.
This should be: “…the HoBT (Heap or B-Tree) ID…” [and usually HoBT is written using uppercase T, if not all uppercase: HOBT]
Chapter 3
· Page 110, table 3-1, last line:
“SET STATISTICS PROFILE XML”
There is no such command. It should be SET STATISTICS XML ON.
Chapter 5
· Page 279, last bullet:
“Trigger ( )
I am assuming we don’t need further explanation for what a trigger is. It should just be Trigger.