Get a detailed look at the internal architecture of T-SQL with this comprehensive programming reference. Database developers and administrators get best practices, expert techniques, and code samples to master the intricacies of this programming language--solving complex problems with real-world sol[...]
Tackle the toughest set-based querying and query tuning problems--guided by an author team with in-depth, inside knowledge of T-SQL. Deepen your understanding of architecture and internals--and gain practical approaches and advanced techniques to optimize your code's performance.
Discover how to[...]
Gain a solid understanding of T-SQL--and write better queriesMaster the fundamentals of Transact-SQL--and develop your own code for querying and modifying data in Microsoft(R) SQL Server(R) 2012. Led by a SQL Server expert, you'll learn the concepts behind T-SQL querying and programming, and then ap[...]
Apply powerful window functions in T-SQL--and increase the performance and speed of your queriesOptimize your queries--and obtain simple and elegant solutions to a variety of problems--using window functions in Transact-SQL. Led by T-SQL expert Itzik Ben-Gan, you'll learn how to apply calculations a[...]
Ace your preparation for Microsoft(R) Certification Exam 70-461 with this 2-in-1 Training Kit from Microsoft Press(R). Work at your own pace through a series of lessons and practical exercises, and then assess your skills with practice tests on CD--featuring multiple, customizable testing options.Ma[...]
Apply powerful window functions in T-SQLand increase the performance and speed of your queries Optimize your queriesand obtain simple and elegant solutions to a variety of problemsusing window functions in Transact-SQL. Led by T-SQL expert Itzik Ben-Gan, you'll learn how to apply calculations agains[...]
T-SQL insiders help you tackle your toughest queries and query-tuning problems
Squeeze maximum performance and efficiency from every T-SQL query you write or tune. Four leading experts take an in-depth look at T-SQL's internal architecture and offer advanced practical techniques for optimizing re[...]