๐”– Scriptorium
โœฆ   LIBER   โœฆ

๐Ÿ“

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

โฌ‡  Acquire This Volume

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


SQL Server 2005 T-SQL Recipes: A Problem
โœ Joseph Sack ๐Ÿ“‚ Library ๐Ÿ“… 2005 ๐ŸŒ English

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
โœ Joseph Sack ๐Ÿ“‚ Library ๐Ÿ“… 2005 ๐Ÿ› Apress ๐ŸŒ English

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

SQL Server 2008 Transact-SQL Recipes: A
โœ Joseph Sack ๐Ÿ“‚ Library ๐Ÿ“… 2008 ๐ŸŒ English

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 : a proble
โœ Jason Brimhall; et al ๐Ÿ“‚ Library ๐Ÿ“… 2012 ๐Ÿ› Apress ๐ŸŒ English

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

SQL Server 2012 T-SQL Recipes: A Problem
โœ Jason Brimhall, David Dye, Jonathan Gennick, Andy Roberts, Wayne Sheffield (auth ๐Ÿ“‚ Library ๐Ÿ“… 2012 ๐Ÿ› Apress ๐ŸŒ English

<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

SQL Server 2012 T-SQL Recipes: A Problem
โœ Jason Brimhall, David Dye, Jonathan Gennick, Andy Roberts, Wayne Sheffield (auth ๐Ÿ“‚ Library ๐Ÿ“… 2012 ๐Ÿ› Apress ๐ŸŒ English

<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