Nov
15
2012
--

Joe Celko’s review of “SQL Performance Explained”

Joe Celko’s review of my book SQL Performance Explained was just published. The bottom line: “This book is definitively worth having in the company library.”

Mar
18
2012
--

Delete Performance

Todays installment covers delete performance. It is similar, yet different, than insert performance covered last week.

Mar
11
2012
--

DML Performance

Todays installment opens the—for the time being—last chapter in Use The Index, Luke. After spending a year and a half writing about the benefits of proper indexing, I have, of course, also tell you about the dark side of indexes. That is insert, update and delete performance.

After the very short chapter intro, todays installment shows you the indexing impact on insert statement.

Jan
30
2012
--

Paging through Results

Todays installment continues the Chapter about efficiently fetching partial results—that is, whenever you don’t need all the rows. Todays part explains how to fetch the next page efficiently.

Jan
12
2012
--

Partial Results

Todays installment opens the Chapter about efficiently fetching partial results—that is, whenever you don’t need all the rows, but just a few from the beginning. These kind of queries are every often used to show lists in a page wise manner.

The installment consists of two parts: the chapter intro and the first section about the Top-N queries.

Powered by WordPress | Theme: Aeros 2.0 by TheBuckmaker.com