September 2010
Intermediate to advanced
1704 pages
111h 8m
English
If you are just starting to design and develop a new SQL Server–based implementation, it would be great to factor in all possible performance and tuning considerations from the beginning. In real life, this is rarely done primarily because much is unknown from a data access, number of users, and table design point of view. However, you are not precluded from designing in certain common performance and tuning considerations, nor are you precluded from incorporating a performance and tuning “prototyping” step in your methodology so that you have known and predictable results of what you are building “as you go” and not “at the end.” As you have no doubt experienced (or heard many times), changing ...