Cover image for SQL Server 2005 T-SQL Recipes A Problem-Solution Approach
SQL Server 2005 T-SQL Recipes A Problem-Solution Approach
Title:
SQL Server 2005 T-SQL Recipes A Problem-Solution Approach
Author:
Sack, Joseph. author.
ISBN:
9781430200994
Personal Author:
Physical Description:
XXIX, 768 p. online resource.
Contents:
Select -- Insert, Update, Delete -- Transactions, Locking, Blocking, and Deadlocking -- Tables -- Indexes -- Full-Text Search -- Views -- SQL Server Functions -- Conditional Processing, Control-of-Flow, and Cursors -- Stored Procedures -- User-Defined Functions and Types -- Triggers -- CLR Integration -- XML -- Web Services -- Error Handling -- Principals -- Securables and Permissions -- Encryption -- Service Broker -- Configuring and Viewing SQL Server Options -- Creating and Configuring Databases -- Database Integrity and Optimization -- Maintaining Database Objects and Object Dependencies -- Database Mirroring -- Database Snapshots -- Linked Servers and Distributed Queries -- Performance Tuning -- Backup and Recovery.
Abstract:
Need to brush up on specific SQL Server tasks, procedures, or Transact-SQL commands? Not finding what you need from SQL Server books online? Or perhaps you just want to familiarize yourself with the practical application of new T-SQL related features. SQL Server 2005 T-SQL Recipes: A Problem-Solution Approach is an ideal book, whatever your level as a database administrator or developer. This no-fluff desk reference offers direct access to the information you need to get the job done. It covers basic T-SQL data manipulation, the use of stored procedures, triggers and UDFs, and advanced T-SQL techniques for database security and maintenance. It also provides hundreds of practical recipes that describe the utilities of features and functions, with a minimim of background theory. Additionally, this book provides how-to answers to common SQL Server T-SQL questions, conceptual overviews, and highlights of new features introduced in SQL Server 2005. It also features concise T-SQL syntax examples, and you can use the book to prepare for a SQL Server-related job interview or certification test.
Added Corporate Author:
Holds: Copies: