SQL Server 2008 TransactSQL Recipes: A ProblemSolution Approach is an examplebased guide to the TransactSQL language that is at the core of SQL Server 2008. Learn to create databases, insert and update data, generate reports, secure your data, and more. Author Joseph Sack takes common TransactSQL tasks and breaks them down into a problem/solution format that is quick and easy to read so that you can get the job done fast when the pressure is on.\ \ Focused on solutions: Look up what you...
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 Server features. The recipe format facilitates just-in-time learning, showing readers immediately how to perform their assigned tasks, and is sure to be a hit with today's busy professional.
Ch. 1 Select 1Ch. 2 Perform, Capture, and Track Data Modifications 63Ch. 3 Transactions, Locking, Blocking, and Deadlocking 115Ch. 4 Tables 143Ch. 5 Indexes 197Ch. 6 Full-Text Search 217Ch. 7 Views 239Ch. 8 SQL Server Functions 257Ch. 9 Conditional Processing, Control-of-Flow, and Cursors 307Ch. 10 Stored Procedures 325Ch. 11 User-Defined Functions and Types 343Ch. 12 Triggers 373Ch. 13 CLR Integration 401Ch. 14 XML, Hierarchies, and Spatial Data 419Ch. 15 Hints 449Ch. 16 Error Handling 459Ch. 17 Principals 475Ch. 18 Securables, Permissions, and Auditing 501Ch. 19 Encryption 547Ch. 20 Service Broker 579Ch. 21 Configuring and Viewing SQL Server Options 615Ch. 22 Creating and Configuring Databases 621Ch. 23 Database Integrity and Optimization 669Ch. 24 Maintaining Database Objects and Object Dependencies 687Ch. 25 Database Mirroring 697Ch. 26 Database Snapshots 717Ch. 27 Linked Servers and Distributed Queries 723Ch. 28 Query Performance Tuning 739Ch. 29 Backup and Recovery 789Index 823