Need to brush up on a specific SQL Server task, 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 new T-SQL-realted features offered in SQL Server 2005, but are more interested in practical applic
SQL Server 2005 T-SQL Recipes: A Problem-Solution Approach
โ Scribed by Joseph Sack (auth.)
- Publisher
- Apress
- Year
- 2006
- Tongue
- English
- Leaves
- 746
- Edition
- 1
- Category
- Library
No coin nor oath required. For personal study only.
โฆ Synopsis
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.
โฆ Table of Contents
Front Matter....Pages i-xxix
Select....Pages 1-59
Insert, Update, Delete....Pages 61-82
Transactions, Locking, Blocking, and Deadlocking....Pages 83-107
Tables....Pages 109-153
Indexes....Pages 155-171
Full-Text Search....Pages 173-189
Views....Pages 191-207
SQL Server Functions....Pages 209-253
Conditional Processing, Control-of-Flow, and Cursors....Pages 255-270
Stored Procedures....Pages 271-287
User-Defined Functions and Types....Pages 289-312
Triggers....Pages 313-336
CLR Integration....Pages 337-353
XML....Pages 355-374
Web Services....Pages 375-391
Error Handling....Pages 393-406
Principals....Pages 407-432
Securables and Permissions....Pages 433-458
Encryption....Pages 459-484
Service Broker....Pages 485-516
Configuring and Viewing SQL Server Options....Pages 517-521
Creating and Configuring Databases....Pages 523-570
Database Integrity and Optimization....Pages 571-587
Maintaining Database Objects and Object Dependencies....Pages 589-594
Database Mirroring....Pages 595-614
Database Snapshots....Pages 615-620
Linked Servers and Distributed Queries....Pages 621-636
Performance Tuning....Pages 637-681
Backup and Recovery....Pages 683-716
Back Matter....Pages 717-733
โฆ Subjects
Programming Languages, Compilers, Interpreters; Programming Techniques; Data Structures
๐ SIMILAR VOLUMES
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-Solut
Without Transact-SQL, there is nothing. Developers and database administrators using Microsoft SQL Server 2008 are highly-motivated to learn Transact-SQL, because that language enables them to store and retrieve data, to move business logic into the database, and to interface with advanced SQL Serve
SQL Server 2012 T-SQL Recipes is an example-based guide to the Transact-SQL language that is at the core of SQL Server 2012. It provides ready-to-implement solutions to common programming and database administration tasks. Learn to create databases, insert and update data, generate reports, secure y
<p><em>SQL Server 2012 T-SQL Recipes</em> is an example-based guide to the Transact-SQL language that is at the core of SQL Server 2012. It provides ready-to-implement solutions to common programming and database administration tasks. Learn to create databases, insert and update data, generate repor
<p><em>SQL Server 2012 T-SQL Recipes</em> is an example-based guide to the Transact-SQL language that is at the core of SQL Server 2012. It provides ready-to-implement solutions to common programming and database administration tasks. Learn to create databases, insert and update data, generate repor