Tomograph: highlighting query parallelism in a multi-core system
Proceedings of the Sixth International Workshop on Testing Database Systems
| Hi-index | 0.00 |
Discussing new and existing features, SQL Server designer and administrator Michael Coles takes you on an expert guided tour of TransactSQL functionality in SQL Server 2008 in his book Pro TSQL 2008 Programmers Guide. Fully functioning examples and downloadable source code bring Coles technically accurate and engaging treatment of TransactSQL into your own hands. Stepbystep explanations ensure clarity, and an advocacy of bestpractices will steer you down the road to success. Pro TSQL 2008 Programmers Guide is every developers key to making full use of SQL Server 2008s powerful, builtin TransactSQL language. TransactSQL is the language developers and DBAs use to interact with SQL Server. Its used for everything from querying data, to writing stored procedures, to managing the database. New features in SQL Server 2008 include a spatial data type, SQLCLR integration, the MERGE statement, a dramatically improved and marketleading XML feature set, and support for encryptionall of which are covered in this book What youll learn Write stored procedures, functions, and triggers using TransactSQL Apply bestpractices when centralizing procedural logic inside your SQL Server database. Seamlessly work with XML data using XQuery, XPath, and the XML type. Use SQLCLR to write .NET code that runs inside SQL Server. Implement fulltext search within your database. Load data more efficiently using the new MERGE statement. Learn about the new geography type for storing spatial data. Who is this book for? Pro TSQL 2008 Programmers Guide is written for SQL Server and TransactSQL developers who want to implement bestpractices and take full advantage of all that SQL Server has to offer. .NET programmers will find the book helpful in showing how to run .NET code within SQL Server. Database administrators who need to write triggers and the occasional stored procedure will also benefit from the book. About the Apress Pro Series The Apress Pro series books are practical, professional tutorials to keep you on and moving up the professional ladder. You have gotten the job, now you need to hone your skills in these tough competitive times. The Apress Pro series expands your skills and expertise in exactly the areas you need. Master the content of a Pro book, and you will always be able to get the job done in a professional development project. Written by experts in their field, Pro series books from Apress give you the hardwon solutions to problems you will face in your professional programming career. Related Titles SQL Server 2008 Transact-SQL Recipes: A Problem-Solution Approach Pro SQL Server 2008 XML Accelerated SQL Server 2008 Beginning SQL Server 2008 for Developers: From Novice to Professional