Conventions

In this book, you will find a number of styles of text that distinguish between different kinds of information. Here are some examples of these styles, and an explanation of their meaning.

Code words in text are shown as follows: "You may notice some TextData appearing multiple times in a trace for a single execution of a T-SQL statement."

A block of code is set as follows:

--creating table for demonstration
CREATE TABLE ordDemo (OrderID INT IDENTITY, OrderDate DATETIME, Amount MONEY, Refno INT)
GO

Any command-line input or output is written as follows:

dta -D AdventureWorks2012 -s adventureworks2012FromDTA5 -S WIN-SLYJ9UY3PKD\DENALICTP3 -E -if D:\test.sql -F -of D:\DTA.sql

New terms and important words are shown in bold. Words that ...

Get Microsoft SQL Server 2012 Performance Tuning Cookbook now with the O’Reilly learning platform.

O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.