Expert T-SQL Window Functions in SQL Server takes you from any level of knowledge of windowing functions and turns you into an expert who can use these powerful functions to solve many T-SQL queries. Replace slow cursors and self-joins with queries that are easy to write and fantastically better performing, all through the magic of window functions. First introduced in SQL Server 2005, windo…
Expert SQL Server In-Memory OLTP is a deep dive into one of the most significant features of SQL Server 2014 – support for In-Memory Online Transaction Processing. The book describes the architecture and internals of the In-Memory OLTP Engine and explains how to develop, deploy, and maintain systems using it. With it you can dramatically increase transactional throughput to handle thousands o…
This book is a deep dive into perhaps the single-most important facet of good performance: indexes, and how to best use them. The book begins in the shallow waters with explanations of the types of indexes and how they are stored in databases. Moving deeper into the topic, and further into the book, you will look at the statistics that are accumulated both by indexes and on indexes. You’ll be…
Expert Oracle Exadata, 2nd Edition opens up the internals of Oracle's Exadata platform so that you can fully benefit from the most performant and scalable database hardware appliance capable of running Oracle Database. This edition is fully-updated to cover Exadata 5-2 and Oracle Database 12c. If you're new to Exadata, you'll soon learn that it embodies a change in how you think about and manag…
Expert Oracle Application Express, 2nd Edition is newly updated for APEX 5.0 and brings deep insight from some of the best APEX practitioners in the field today. You'll learn about important features in APEX 5.0, and how those can be applied to make your development work easier and with greater impact on your business. Oracle Application Express (APEX) is an entirely web-based development frame…
Learn from F#'s inventor to become an expert in the latest version of this powerful programming language so you can seamlessly integrate functional, imperative, object-oriented, and query programming style flexibly and elegantly to solve any programming problem. Expert F# 4.0 will help you achieve unrivaled levels of programmer productivity and program clarity across multiple platforms includin…
This thesis offers important new insights into and a deeper understanding of premixed flame instabilities and hydrogen safety. Further, it explains the underlying mechanisms that control the combustion processes in tubes. The author’s previous scientific accomplishments, which include a series of high-quality publications in the best journals in our field, Combustion and Flame and Internation…
In Hot Thespian Action! Robin Whittaker argues that new plays can thrive in amateur theatres, which have freedoms unavailable to professionalized companies. And he proves it with ten relevant, engaging playscripts originally produced by one of Canada’s longest-running theatres, Edmonton’s acclaimed Walterdale Theatre Associates. This collection challenges notions that amateur theatre is sol…
Experimental and Applied Mechanics, Volume 6: Proceedings of the 2014 Annual Conference on Experimental and Applied Mechanics, the sixth volume of eight from the Conference, brings together contributions to important areas of research and engineering. The collection presents early findings and case studies on a wide range of topics, including: Advances in Residual Stress Measurement Methods …
Experimental and Applied Mechanics, Volume 4 of the Proceedings of the 2015SEM Annual Conference& Exposition on Experimental and Applied Mechanics, the fourth volume of nine from the Conference, brings together contributions to important areas of research and engineering. The collection presents early findings and case studies on a wide range of topics, including: Advanced Methods for Front…