T-SQL Querying (Developer Reference)

T-SQL Querying (Developer Reference)

<b>T-SQL insiders help you tackle your toughest queries and query-tuning problems</b> <br />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 response time and resource usage. Emphasizing a correct understanding of the language and its foundations, the authors present unique solutions they have spent years developing and refining. All code and techniques are fully updated to reflect new T-SQL enhancements in Microsoft SQL Server 2014 and SQL Server 2012.<br /> <br /> <b>Write faster, more efficient T-SQL code:</b> <br /> <ul> <li>Move from procedural programming to the language of sets and logic</li> <li>Master an efficient top-down tuning methodology</li> <li>Assess algorithmic complexity to predict performance</li> <li>Compare data aggregation techniques, including new grouping sets</li> <li>Efficiently perform data-analysis calculations</li> <li>Make the most of T-SQL€s optimized bulk import tools</li> <li>Avoid date/time pitfalls that lead to buggy, poorly performing code</li> <li>Create optimized BI statistical queries without additional software</li> <li>Use programmable objects to accelerate queries</li> <li>Unlock major performance improvements with In-Memory OLTP</li> <li>Master useful and elegant approaches to manipulating graphs</li> </ul> <br /> <b>About This Book</b> <br /> <ul> <li>For experienced T-SQL practitioners</li> <li>Includes coverage updated from<b> <i> Inside Microsoft SQL Server 2008 T-SQL Querying</i> </b> and <b> <i>Inside Microsoft SQL Server 2008 T-SQL Programming</i> </b> </li> <li>Valuable to developers, DBAs, BI professionals, and data scientists</li> <li>Covers many MCSE 70-464 and MCSA/MCSE 70-461 exam topics</li> </ul>