SQL Performance Tuning

Learn the latest SQL Server 2014 database design methods for career advancement; among them in-memory OLTP tables, FileTable FILESTREAM storage and ColumnStore indexes. Relational database design teac

Fill the gap between planning and doing with SSIS 2014The 2014 release of Microsoft's SQL Server Integration Services provides enhancements for managing extraction, transformation, and load operations

Considered the best Oracle PL/SQL programming guide by the Oracle community, this definitive guide is precisely what you need to make the most of Oracle’s powerful procedural language. The sixth editi

Performance problems are rarely "problems" per se. They are more often "crises" during which you’re pressured for results by a manager standing outside your cubicle

Thorough and updated coverage of database design and SQL for DB2 are the focus of this guide for the relational database-management system used on IBM i computer systems. Suitable for classroom instru

Relational database design and SQL (Structured Query Language) programming teach-by-practical-diagrams-&-examples book for developers, programmers, systems analysts and project managers who are ne

Learn the latest SQL Server 2012 database design methods for career advancement; among them FileTable FILESTREAM storage and ColumnStore indexes. Relational database design teach-by-practical-diagrams

Pro SQL Azure, 2nd Edition shows how to create enterprise-level database deployments without the usual investment in datacenter and other infrastructure. Take advantage instead of Microsoft's worldwid

Relational database design and SQL (Structured Query Language) programming teach-by-practical-diagrams-&-examples book for developers, programmers, systems analysts and project managers who are ne

Book-and-video package gets novices up to speed on Microsoft SQL Server 2012If you need a practical, hands-on introduction, especially to SQL Server Integration Services (SSIS), this book-and-video pa

SQL Server 2012 Data Integration Recipes provides focused and practical solutions to real world problems of data integration. Need to import data into SQL Server from an outside source? Needto export

Pro TSQL 2012 Programmer's Guide is every developer's key to making full use of SQL Server 2012's powerful, builtin TransactSQL language. Discussing new and existing features, the book takes you on an

Pro SQL Server 2012 Reporting Services opens the door to delivering customizable, web-enabled reports across your business at reasonable cost. Reporting Services is Microsoft's enterprise-level report

本書以面向應用為原則，深入淺出的介紹了oracle平臺上使用pl/sql語言進行數據庫開發的技術。通過大量的示例，詳細介紹了pl/sql的語言特性、使用技巧，同時配以2個在實際工作中的示例來深入的剖析了pl/sql進行oracle開發的方方面面。 本書附帶1張dvd光盤，內容為作者為本書錄制的全程語音教學視頻及本書所涉及的源代碼。 本書共分為20章，分為5大篇。涵蓋的內容主要有pl/sql語言

Master the advanced concepts of PL/SQL for professional-level certification and learn the new capabilities of Oracle Database 12cAbout This BookLearn advanced application development features of Oracl

The demand for SQL information and training continues to grow with the need for a database behind every website capable of offering web-based information queries. SQL is the de facto standard for data

Now available in paperback— Service Broker is a key Microsoft product in support of message–based processing between applications. Pro SQL Server 2008 Service Broker helps you to take full advantage o

Provides a practical overview of SQL, the most common management database system for large shared data banks including information on clauses, expressions, predicates, queries, and statements.

SummarySQL Server MVP Deep Dives, Volume 2 is a unique book that lets you learn from the best in the business - 64 SQL Server MVPs offer completely new content in this second volume on topics ranging

There are a lot of books on SQL and many more web sites. The classic difficulty is that the books tend to be shallow overviews for complete beginners and the web sites tend to have deep knowledge on o

A guide to designing and implemeting database solutions using SQL Server covers such topics as relational theory, data modeling, database security, normalization, and concurrency.

Presents an instructional guide to SQL which uses humor and simple images to cover such topics as the structure of relational databases, simple and complex queries, creating multiple tables, and prote

Written by experienced SQL Server developers, this second edition shows readers how to build Windows or Web-based reporting systems. The book covers features added to the newest version of Reporting S

In this complete revision and expansion of his first SQL Puzzles book, Joe Celko challenges you with his trickiest puzzles—and then helps solve them with a variety of solutions and explanations. Joe d

Stored procedures and built-in functions can greatly expand the power and usefulness of SQL, but surprisingly these highly useful tools remain untapped by many programmers. For programmers who are new

Despite its wide availability and usage, few developers and DBAs have mastered the true power of Oracle SQL*Plus. This bestselling book--now updated for Oracle 10g--is the only in-depth guide to this

Introduces a series of effective techniques to solve essential problems in the Oracle database using PL/SQL, with a focus on the stored procedures, how to code them, and practical uses for them in the

Explains how SQL Server and its core technologies are designed, how they work, and how they interoperate. As a complement to his other two books on SQL, Henderson explores Windows' process and thread

In Performance Ethnography, one of the world’s most distinguished authorities on qualitative research, established the initial published connection of performance narratives with performance ethnograp

Demonstrates important concepts and offers working Transact-SQL code, covering data filtering, DDL, DML, statistical functions, runs and sequences, transactions, stored procedures and triggers, and pe

瞄準當前高等院校SQL Server數據庫理論和實驗的教學需求，本書以SQL Server 2019為平臺，全面、系統地介紹了SQL Server數據庫管理系統的基本原理和技術。同時，本書理論和實驗相互配套，重點深化實驗課的教學，其中，實驗包含驗證性實驗和設計性實驗。本書各章內容為：數據庫概述、數據定義、數據操縱、數據查詢、視圖和索引、數據庫程序設計、數據庫編程技術、系統安全管理、備份和還原、事務和鎖、基於Visual C#和SQL Server數據庫的學生成績管理系統的開發。本書可作為普通高等院校數據庫相關課程的教學用書，也可供計算機應用人員和數據庫愛好者自學使用，還可作為培訓機構數據庫相關課程的參考用書。

本書結合豐富的案例，清晰地詮釋了SQL Server 2019 編程語言與數據庫開發涉及的每一個核心概念和技術。全書力求闡述實際開發應用中涉及的SQL Server 2019 的功能組件和管理工具；注重實際操作，採用可視化圖解的方式，對SSMS、SSCM 等關鍵工具的操作步驟進行了詳細說明，使得讀者能夠直觀地看到操作過程和操作效果；注重編程技巧，對於核心的T-SQL 操作，在詳細介紹其語法、參數後，都會附加案例的高級編程T-SQL 代碼，這些T-SQL 代碼在筆者的開發環境中都經過嚴格的調試，讀者可以直接用於自己的項目開發實踐。本書可供數據庫設計與開發等方向初學者、程序開發人員閱讀，也可作為高等院校計算機、軟件開發相關專業的教材。

全書分為三部分：第一部分為基礎部分，介紹數據庫的基本原理和SQL語句；第二部分為應用部分， 介紹了SQL程序設計的基礎知識，並以圖書館信息系統為例，介紹數據庫設計的具體開發過程，同時，介紹了數據庫開發過程中涉及的安全性、並發性等問題的處理方法。第三部分為實驗部分， 通過有關的實驗，使讀者可以把理論與實踐結合起來，提高動手能力。

Precision CNC Machining for High-Performance Gears: Theory and Technology covers basic theories and methods, key technologies, and machining equipment in precision CNC machining of high-performance gears. Sections cover research status and development trends of machining technologies and CNC machining equipment of high-performance gears, calculation theories of the precision modification method of high-performance gears, methods of reducing the machining principle errors of high-performance gears, the modeling method of multi-source errors and the compensation technique of CNC gear machine tools, the key technologies of precision CNC gear machine tools, the optimization method of the process parameters of hobbing and grinding, key technologies, and more.

本書基於金倉數據庫管理系統KingbaseES V9版本，採用“理論+實踐”的形式編寫。在全面介紹KingbaseES PL/SQL基本知識的基礎上，詳細講解了PL/SQL開發的所有功能模塊、方法和技巧，包括PL/SQL中的靜態SQL語句、事務處理、動態SQL語句、異常處理、輸入與輸出、子程序、用戶自定義對象、用戶自定義聚集函數、程序包、觸發器、代碼保護、調試、調度與執行等主要內容。本書以一個簡化的在線購物平臺數據庫為例，將理論知識翔實地融入實踐當中，以大量應用實例驗證、解讀，讓讀者體驗完整的項目實操過程。此外，考慮與Oracle及PostgreSQL數據庫的兼容性，協助數據庫開發人員用好國產數據庫，提高國產數據庫在國民經濟各領域的應用範圍，本書還作了差異性比較和轉換操作。本書適用于KingbaseES數據庫開發人員、KingbaseES數據庫管理員等相關數據庫從業人員，也可作為大中專院校計算機科學與技術、軟件工程等相關專業師生的參考用書，還可作為培訓機構的培訓教材。

本書全面講述了數據庫的基本原理和SQL Server 2012的應用，全書以理論夠用、實用，實踐第一的原則，使讀者能夠快速、輕鬆地掌握SQL Server數據庫技術與應用。第1～4章講述數據庫的基本理論知識，其內容包括數據庫系統概述、數據模型、關係數據庫和數據庫設計；第5～14章講述數據庫管理系統SQL Server 2012的應用，其內容包括SQL Server 2012基礎，數據庫的概念和操作，表的操作，數據庫查詢，T-SQL編程，視圖和索引的操作，存儲過程和觸發器，事務與並發控制，數據庫系統的安全性，數據庫的備份與還原；第15章介紹了基於C#.NET 的數據庫應用系統開發過程。 本書理論和實踐相結合，既闡述了數據庫的基本理論，又結合了SQL Server 2012數據庫管理系統的應用，內容翔實，實例豐富，圖文並茂，體系完整，通俗易懂，有助於讀者理解數據庫的基本概念，掌握要點和攻克難點；為便於學習，每章還配有豐富的習題。 本書可作為大學本科、專科、高等職業院校“SQL Server數據庫”課程的教學用書，也可以作為培養數據庫系統工程師的培訓教材，還可以作為數據庫管理人員及數據庫應用系統開發人員的參考用書。

本書結合高職高專的教學特點，系統地介紹了學生必須掌握的資料庫原理相關理論知識，在此基礎上，通過大量實例著重講解SQL Server 2014資料庫的操作與管理，以某公司人事系統後臺資料庫設計專案為例貫穿全書，使得資料庫原理的闡述與SQL Server 2014的實際應用融為一體，讀者可以通過必要的基本理論指導其對資料庫操作的實踐，同時也能在實踐中加深對資料庫原理的理解。為方便讀者更好地掌握SQL Server 2014的使用方法，書中採用通俗易懂的方式介紹了有關操作步驟和原理，並輔以大量實例和插圖，章後配有相關內容的專案實訓，便於讀者通過實際操作和練習，鞏固所學知識。本書共計三大部分，其中第一部分（第1章至第4章）主要介紹資料庫基本概念和理論；第二部分（第5章至第7章）主要介紹SQL Server 2014的安裝、管理和資料操作等；第三部分（第8章和第11章）主要介紹資料庫系統設計方法。本書內容翔實、敘述清晰、注重實踐、習題豐富，可作為高職高專電腦相關專業的必修教材，也適合電腦相關人員自學使用。

Irish Revivalist playwright J. M. Synge is often regarded as a realist. Yet what happens when his work is analysed through wider performance studies and situated alongside less familiar historical contexts? By addressing this question, Hélène Lecossois offers new and valuable perspectives on Synge's plays while at the same time engaging with the complexity of his treatment of a range of performance practices – from keening at rural funerals to the performances of 'native villagers' in the entertainment section of International Exhibitions. What emerges from her study is a dramatist acutely aware of the ability of theatre in performance to counteract relentless forward-moving narratives of modernity. Through detailed, contextualized case studies, the book simultaneously makes meaningful contributions to performance studies and opens up theoretical questions of performance relating to the status of the object on stage, the body on stage and theatrical time.

The Methuen Drama Companion to Performance Art offers a comprehensive guide to the major issues and interdisciplinary debates concerning performance in art contexts that have developed over the last decade. It understands 'performance art' as an institutional, cultural, and economic phenomenon rather than as a label or object. Following the ever-increasing institutionalization and mainstreaming of performance and its methods of display, representation, and mediation in the wider cultural sphere, the book’s chapters identify a marked change in the economies and labor practices surrounding performance art and its institutional curating and presenting practices, reflective of an advanced stage of capitalism that approaches art production in tandem with event production. Embracing what we perceive to be the 'oxymoronic status' of performance art―where it is simultaneously precarious and highly profitable―the essays in this book map the myriad gestures and radical possibilities of this e

The Methuen Drama Handbook of Interculturalism and Performance explores ground-breaking new directions and critical discourse in the field of intercultural theatre and performance while surveying key debates concerning interculturalism as an aesthetic and ethical series of encounters in theatre and performance from the 1960s onwards. The handbook’s global coverage challenges understandings of intercultural theatre and performance that continue to prioritise case studies emerging primarily from the West and executed by elite artists. By building on a growing field of scholarship on intercultural theatre and performance that examines minoritarian and grassroots work, the volume offers an alternative and multi-vocal view of what interculturalism might offer as a theoretical keyword to the future of theatre and performance studies, while also contributing an energized reassessment of the vociferous debates that have long accompanied its critical and practical usage in a performance contex