2nd Edition. — Microsoft Press, 2020. — 570 p. — ISBN: 978-0135861448. Use window functions to write simpler, better, more efficient T-SQL queries Most T-SQL developers recognize the value of window functions for data analysis calculations. But they can do far more, and recent optimizations make them even more powerful. In T-SQL Window Functions, renowned T-SQL expert Itzik...
Apress, 2020. — 236 p. — ISBN-13 (electronic): 978-1-4842-5581-0. Breathe new life into older applications by refactoring T-SQL queries and code using modern techniques. This book shows you how to significantly improve the performance of older applications by finding common anti-patterns in T-SQL code, then rewriting those anti-patterns using new functionality that is supported...
Apress, 2015. — 1032 p. — ISBN13: 978-1-484207-11-6. This book brings SQL Server administration into the modern era with strong coverage of hybrid cloud environments, In-Memory OLTP, and installation on Server Core. This comprehensive guide to SQL Server Administration for today’s DBA helps you to administer the new and key areas of SQL Server, including Columnstore indexes and...
5th Edition. — Pearson Edacution Ins., 2020. — 438 p. — ISBN13: 978-0-13-518279-6. Sams Teach Yourself SQL in 10 Minutes offers straightforward, practical answers when you need fast results. By working through the book’s 22 lessons of 10 minutes or less, you’ll learn what you need to know to take advantage of the SQL language. Lessons cover IBM DB2, Microsoft SQL Server and SQL...
2nd Edition. — Apress, 2015. — 432 p. — ISBN: 978-1-484211-19-9. 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...
Syncfusion Inc, 2014. — 136 p. Categories: Database The massive amount of data collected by businesses often creates a lot of work without doing much good. To make data work for them, businesses need solutions that summarize and organize it in ways that will influence the decisions they make each day. With SQL Server Analysis Services Succinctly by Stacia Misner, you will learn...
Apress, 2018. — 605 p. — ISBN13: 978-1-4842-4127-1. Get SQL Server up and running on the Linux operating system and containers. No database professional managing or developing SQL Server on Linux will want to be without this deep and authoritative guide by one of the most respected experts on SQL Server in the industry. Get an inside look at how SQL Server for Linux works...
Comments