You may have to register before you can download all our books and magazines, click the sign up button below to create a free account.
Microsoft SQL Server implements extensive support for location-based data. Pro Spatial with SQL Server 2012 introduces SQL Server’s spatial feature set, and covers everything you'll need to know to store, manipulate, and analyze information about the physical location of objects in space. You’ll learn about the geography and geometry datatypes, and how to apply them in practical situations involving the spatial relationships of people, places, and things on Earth. Author Alastair Aitchison first introduces you to SQL Server’s spatial feature set and the fundamental concepts involved in working with spatial data, including spatial references and co-ordinate systems. You’ll learn to qu...
Dive deep inside the architecture of SQL Server 2012 Explore the core engine of Microsoft SQL Server 2012—and put that practical knowledge to work. Led by a team of SQL Server experts, you’ll learn the skills you need to exploit key architectural features. Go behind the scenes to understand internal operations for creating, expanding, shrinking, and moving databases—whether you’re a database developer, architect, or administrator. Discover how to: Dig into SQL Server 2012 architecture and configuration Use the right recovery model and control transaction logging Reduce query execution time through proper index design Track events, from triggers to the Extended Event Engine Examine internal structures with database console commands Transcend row-size limitations with special storage capabilities Choose the right transaction isolation level and concurrency model Take control over query plan caching and reuse
For many North Americans, Arab Americans are invisible, recalled only when words like "terrorism" or "anti-American sentiments" arise. However, people of Arab descent have been contributing to U. S. an d Canadian culture since the 1870s in fields as diverse as literature, science, politics, medicine, and commerce -- witness surgeon Michael DeBakey, former Oregon governor Victor Atiyeh, consumer advocate Ralph Nader, and Canadian M.P. Mac Harb. Yet while Arab American contributions to our society are significant and Arab Americans surpass the U.S. average in both education and economics, they still struggle for recognition and acceptance. In this volume, editor Michael Suleiman brings togethe...
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: Move from procedural programming to the language of sets and logic Optimize query tuning with a top-down methodology Assess algorithmic complexity to predict performance Compare data-aggregation techniques, including new grouping sets Manage data modification—insert, delete, update, merge—for performance Write more efficient queries against partitioned tables Work with graphs, trees, hierarchies, and recursive queries Plus—Use pure-logic puzzles to sharpen your problem-solving skills
This book constitutes the thoroughly refereed proceedings of the 21st International Conference on User Modeling, Adaption, and Personalization, held in Rome, Italy, in June 2013. The 21 long and 7 short papers of the research paper track were carefully reviewed and selected from numerous submissions. The papers cover the following topics: recommender systems, student modeling, social media and teams, human cognition, personality, privacy, web curation and user profiles, travel and mobile applications, and systems for elderly and disabled individuals.
Studying the entangled histories of the areas conceptualized as Middle Eastern and North Atlantic World in the interwar years is crucial to understanding the two areas' respective and common histories until today. However, many of the manifold connections, exchanges, and entanglements between the areas have not received thorough scholarly attention yet. The contributors to this volume address this by bringing together various innovative and interdisciplinary approaches to the topic. They thereby further the understanding of the two areas' entangled histories and diversify prevailing concepts and narratives. Through this, the volume also offers enriching insights into the global history of the early 20th century.