SQL Server 2008 Query Performance Tuning Distilled

This book provides you with the tools you need to answer those questions. I’ll show you how to set up mechanisms for collecting performance data on your server for the SQL Server instances and databases living there. I’ll go over the more tactical methods of collecting data on individual T-SQL call...

Mô tả đầy đủ

Đã lưu trong:
Chi tiết về thư mục
Những tác giả chính: Fritchey, Grant, Dam, Sajal
Định dạng: Sách
Ngôn ngữ:English
Được phát hành: Apress 2013
Những chủ đề:
SQL
Truy cập trực tuyến:http://scholar.dlu.edu.vn/thuvienso/handle/DLU123456789/34785
Các nhãn: Thêm thẻ
Không có thẻ, Là người đầu tiên thẻ bản ghi này!
Thư viện lưu trữ: Thư viện Trường Đại học Đà Lạt
Miêu tả
Tóm tắt:This book provides you with the tools you need to answer those questions. I’ll show you how to set up mechanisms for collecting performance data on your server for the SQL Server instances and databases living there. I’ll go over the more tactical methods of collecting data on individual T-SQL calls. Along the way, I’ll be discussing index structure, choice, and maintenance; how best to write your T-SQL code; and a whole slew of other topics. One of my goals when writing this book was to deliver all these things using examples that resemble the types of queries you’ll see in the real world, at your desk. The tools and methods presented are mostly available with SQL Server Standard Edition, although some are available only with SQL Server Enterprise Edition. These are called out whenever you might encounter them.