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…
In this volume, top seismic experts and researchers from Europe and around the world, including the George E. Brown, Jr. Network for Earthquake Engineering Simulation (NEES) in the USA, present the most recent outcome of their work in experimental testing, as well as the results of the transnational access activities of external researchers who have used Europe's seven largest and most advanced…
Ivana Bušljeta Banks is a senior lecturer in the Department of Marketing and Communication at the Zagreb School of Economics and Management. Patrick De Pelsmacker is professor of marketing at the University of Antwerp, part-time professor of marketing at Ghent University (both in Belgium), and visiting professor at the Universities of Lugano, Genève (Switzerland), and IBS Moscow (Russia). Shi…
Business Processes and Information Technology takes a business process focus towards understanding and managing operations, information systems, and management/ decision making in contemporary organizations. A wide range of information technologies in business processes are integrated throughout.
This book identifies and furthers the state of the art in green logistics and transportation with a supply chain focus. It includes discussions on concerns and linkages across policy, corporate strategy and operations and inter-organizational relationships and practices. Separate sections are assigned to discuss issues related to greening of logistics and transportation functions, including gre…
This book shows the capabilities of Microsoft Excel in teaching human resource management statistics effectively. Similar to the previously published Excel 2013 for Human Resource Management Statistics, this book is a step-by-step exercise-driven guide for students and practitioners who need to master Excel to solve practical human resource management problems. If understanding statistics isnâ€â€¦