SQL Server 2005 T-SQL Recipes: A Problem-Solution Approach

Front Cover
Apress, Nov 10, 2006 - Computers - 768 pages

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.

 

What people are saying - Write a review

User Review - Flag as inappropriate

Well organized, with each topic clearly defined and explored. Strongly recommend.

User Review - Flag as inappropriate

i am not able to download this books .why?

Contents

INSERT UPDATE DELETE
61
Transactions Locking Blocking
83
Tables
109
Indexes
155
Figure 51 Btree structure of a clustered index
156
FullText Search
173
Views
191
SQL Server Functions
209
Service Broker
485
Configuring and Viewing SQL Server
517
Creating and Configuring Databases
523
CHAPTER 22 CREATING AND CONFIGURING DATABASES
524
Database Integrity and Optimization
571
Maintaining Database Objects and
589
Database Mirroring
595
Figure 251 Database Mirroring Basic Architecture
597

Conditional Processing
255
Stored Procedures
271
UserDefined Functions and Types
289
Triggers
313
CLR Integration
337
XML
355
Web Services
375
Error Handling
393
Principals
407
Securables and Permissions
433
Encryption
459
Database Snapshots
615
Linked Servers and
621
Performance Tuning
637
Figure 281 The Connect to Server dialog box
640
Because there are two queries youll also see two actual
648
Figure 2822 Report tab
673
Figure 2824 Applying Recommendations status dialog box
674
Figure 2826 Query execution plan prior to applying a Plan
679
Backup and Recovery
683
FILEGROWTH 1024KB
700
Copyright

Other editions - View all

Common terms and phrases

Popular passages

Page 20 - emps3.empid' is invalid in the select list because it is not contained in an aggregate function and there is no GROUP BY clause.

About the author (2006)

Joseph Sack is a Principal Consultant with SQLskills. He has worked as a SQL Server professional since 1997 and has supported and developed for SQL Server environments in financial services, IT consulting, manufacturing, retail, and the real estate industry. Prior to joining SQLskills, he worked at Microsoft as a Premier Field Engineer supporting very large enterprise customer environments. He was responsible for providing deep SQL Server advisory services, training, troubleshooting, and ongoing solutions guidance. His areas of expertise include performance tuning, scalability, T-SQL development, and high-availability. In 2006 Joe earned the Microsoft Certified Master: SQL Server 2005 certification; and in 2008, he earned the Microsoft Certified Master: SQL Server 2008 certification. In 2009 he took over responsibility for the SQL Server Microsoft Certified Master program and held that post until 2011. He is the author of a few books and white papers, including most recently, SQL Server 2008 Transact-SQL Recipes (Apress, 2008). Joe's blog is at www.SQLskills.com/blogs/joe, and he can be reached at joe@SQLskills.com.

Bibliographic information