Databases are software. I've based the second half of a software development career that began in 1978 on this simple idea. If you've found this book, chances are you're willing to at least entertain the possibility that databases and their attendant programmability are worthy of the same rigor and process as the rest of an application. Good for you It's a great pleasure for me to join you on this jo- ney, however briefly, via this foreword. There is a good possibility that you've grown as skeptical as I have of the conventional wisdom that treats the "back end" as an afterthought in the...

T-SQL insiders help you tackle your toughest queries and query-tuning problems
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...