Full Description
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.
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.
