We don't believe in brain dumps. We are a certification website dedicated to providing answers to your questions about mcad, mcsd .net, mcdba, mcsa, and mcse information, requirements, books, exams, and training to help you earn your Microsoft certifications.
Save money using this special offer discount voucher coupon code on your Microsoft Certified Professional exams from Pearson VUE testing exam centers Save on your Microsoft Certification
Exams with this discount voucher coupon code!Click here to find out how to save money.
MCSE exam discounts, MCDBA exam vouchers, MCSD .NET coupon codes
View my shopping cart containing certification books View My Shopping Cart
Certification resources including books, exam notes, training courses, training centers, bootcamps, and study websites.
No braindumps, just a wealth of information.
MCSE MCSA MCSD .NET MCAD MCDBA Training Centers
MCSE information, MCSE requirements, MCSE benefits, MCSE exams, MCSE questions, MCSE answers, MCSE study guides, MCSE help, MCSE bootcamps, MCSE training, windows 2003 exams
MCDBA information, MCDBA requirements, MCDBA benefits, MCDBA exams, MCDBA questions, MCDBA answers, MCDBA study guides, MCDBA help, MCDBA bootcamps, MCDBA training, SQL Server 2000 examsMCSD .NET information, MCSD .NET requirements, MCSD .NET benefits, MCSD .NET exams, MCSD .NET questions, MCSD .NET answers, MCSD .NET study guides, MCSD .NET help, MCSD .NET bootcamps, MCSD .NET training, ASP .NET exams, VB.NET exams, C# exams
MCSA information, MCSA requirements, MCSA benefits, MCSA exams, MCSA questions, MCSA answers, MCSA study guides, MCSA help, MCSA bootcamps, MCSA training, windows 2003 system administrator study notes
MCAD information, MCAD requirements, MCAD benefits, MCAD exams, MCAD questions, MCAD answers, MCAD study guides, MCAD help, MCAD bootcamps, MCAD training, windows 2003 certification exams
Click To View Larger Picture Transact-SQL Desk Reference: For Microsoft SQL Server
by Deac Lancaster
List Price: $39.99
Our Price: $27.99
ISBN: 0130293393
Publisher: Prentice Hall PTR (11 September, 2003)
Edition: Paperback
Sales Rank: 9,033
Average Customer Rating: 4.5 out of 5
05
Buy now directly from Amazon.com
Purchase this book, safely and securly from the largest book dealer on the Internet, Amazon.com
VUE Voucher Number, Save money on all your Microsoft Certification Professional (MCP) Exams taken at Pearson VUE examination testing centers. No catch, 100% legitimate. Click to get the Voucher Number ( Promotion Code, Coupon Code ).

Customers Reviews:
Rating: 5 out of 5
05
Scott Hill
Excellent examples and clear explanations. 12/22/2003

This book is exactly what I was looking for, an extension of Books Online with extra clear examples and explanations. Books Online is often still my first reference because it is convenient and does an excellent job. But when I need a second source for more information I now turn to Transact-SQL Desk Reference. If I still don't find what I need then I have to go to user groups or other external sources, but so far that has only happened once.

The tutorial in the first chapter is a nice overview for those who need it, but an advanced user can skip past it and go straight to the reference material starting in Chapter 2. The index is excellent and so far has never failed to put me in the right place to find what I want. I particularly like the extra examples of how to use different features. And the explanation of how to do disk layout to help restorability and performance is well beyond what I expected in a reference book. I plan to use the layout presented as a starting point for configuring my production database.

It could be argued that the syntax definitions taken from Books Online could be omitted, though in some cases the book has a better explanation of some of the items. All in all, it is definitely worth the price.


Rating: 4 out of 5
05
Easy lookup of examples
You know some SQL or you want to learn it? Otherwise why are you pondering this book and this review? But suppose you have never used Microsoft SQL Server. The title may then be puzzling. You see, Transact-SQL is Microsoft's name for the "Microsoft SQL Server SQL" [sic]. The latter quoted phrase is actually logically correct. It parses as Microsoft's extension of SQL2 or SQL3 that is implemented by its SQL Server. But the phrase looks ridiculous. Hence Transact-SQL.

Like their database competitors, IBM and Oracle, Microsoft supplies online documentation and hardcopy. But the sheer complexity of all the SQL options and the proprietary extensions, plus the undoubted opacity of the official documentation has spawned an independent sideline of books that provide alternative and presumably clearer views of the databases. Ideally, therefore, this book should not exist!

It assumes you already know the theory of SQL and relational databases. But that at times you will be casting around for the precise syntax of a command. So the book emphasises quick easy lookup of commands. Numerous examples are provided in bold font, to help you quickly get there. By contrast, the full syntax of a query is written in regular font, in BNF. [So you need to know BNF, but that is easy.] This may differ from some texts, where the full syntax is visually emphasised instead of its examples. Logically, the latter formulation makes sense. But the pragmatic pedagogy here is actually often more useful. Most of us will understand a few examples far quicker than perusing the abstraction of a full BNF description of a command. A simple display decision. But you may find that this is a nice usability feature that gives the book utility to you.


Please note: Checkout and payment processing is done safely and securely through Amazon.com.
Prices (as shown) are subject to change without notice and cannot be guaranteed.
Email this page to a friendEmail this page to a friend Correction/Comment/Suggestion Regarding This PageCorrection/Comment/Suggestion Regarding This Page?
©2003 CertificationWorks.com  Privacy Policy | Terms of Use | Contact Us
Microsoft Corporation in no way endorses or is affiliated with CertificationWorks.com.  All trademarks displayed on this website are trademarks of their respective owners.