MANNING
SAMPLE CHAPTER
DEEP DIVES
EDITED BY Paul Nielsen Kalen Delaney Greg Low Adam Machanic Paul S. Randal Kimberly L. Tripp
MVP CONTRIBUTORS
John Baird Bob Beauchemin Itzik Ben-Gan Glenn Berry Aaron Bertrand Phil Brammer Robert C. Cain Michael Coles John Paul Cook Hilary Cotter Louis Davidson Christopher Fairbairn Rob Farley Denis Gobo Bill Graziano Dan Guzman Paul Ibison Tibor Karaszi Kathi Kellenberger Don Kiely Kevin Kline Hugo Kornelis Alex Kuznetsov Matija Lah Cristian Lefter Andy Leonard Greg Linwood Bruce Loehle-Conger Brad McGehee Paul Nielsen Pawel Potasinski Matthew Roche Dejan Sarka Edwin Sarmiento Gail Shaw Linchi Shea Richard Siddaway Jasper Smith Erland Sommarskog Scott Stauffer Tom van Stiphout Gert-Jan Strik Ron Talmage William R. Vaughn Joe Webb John Welch Erin Welker Allen White
● ● ● ● ● ● ● ● ● ● ● ● ● ● ● ● ● ● ● ● ● ● ● ● ● ● ● ● ● ● ● ● ● ● ● ● ● ● ● ● ● ● ● ● ● ● ●
Author royalties go to support War Child International
SQL Server MVP Deep Dives
Edited by Paul Nielsen, Kalen Delaney , Greg Low, Adam Machanic, Paul S. Randal, Kimberly L. Tripp
Chapter 1
Copyright 2010 Manning Publications
brief contents
PART 1 DATABASE
1 2 3
DESIGN AND ARCHITECTURE ..............1
3 11
Louis and Paul's 10 key relational database design ideas SQL Server tools for maintaining data integrity Finding functional dependencies 28
PART 2
DATABASE DEVELOPMENT ..............................41
4 5 6 7 8 9 10 11 12 13 14 15 16 17
Set-based iteration, the third alternative Gaps and islands 59
43 73 102
Error handling in SQL Server and applications Pulling apart the FROM clause 86 111 119
What makes a bulk insert a minimally logged operation Avoiding three common query mistakes Introduction to XQuery on SQL Server Using XML to transport relational data Full-text searching 176 Simil: an algorithm to look for similar strings Table-valued parameters Build your own index 221 200 210 LINQ to SQL and ADO.NET Entity Framework 234

下一页