Suggest a Book which teaches TSQL to expert level

Question

I'm a DB Developer I'm working on TSQL, SSIS & SSRS for last 18 months. I know basics in TSQL but I want o learn TSQL to expert level. Want to learn wrinting good Stored Procs & use better optimizing techniques.

Please suggest me the best book which teaches TSQL from High to Low level. Also send me download links if u have any.

---

Royal Thomas

Answer 1

Get http://www.amazon.com/Microsoft-Server-2012-T-SQL-Fundamentals/dp/0735658145 by Itzik Ben-Gan

---

For every expert, there is an equal and opposite expert. - Becker's Law


My blog

Answer 2

>Want to learn wrinting good Stored Procs & use better optimizing techniques.

Consider the following book:

The Guru's Guide to SQL Server Stored Procedures, XML, and HTML [Paperback]
Ken Henderson (Author)

Stored procedure samples:

http://www.bing.com/search?q=stored+procedure+site%3A+www.sqlusa.com

---

Kalman Toth Database & OLAP Architect sqlusa.com
Paperback / Kindle: Pass SQL Exam 70-461 & Job Interview: Programming SQL Server 2012

Answer 3

I'm a DB Developer I'm working on TSQL, SSIS & SSRS for last 18 months. I know basics in TSQL but I want o learn TSQL to expert level. Want to learn wrinting good Stored Procs & use better optimizing techniques.

Please suggest me the best book which teaches TSQL from High to Low level. Also send me download links if u have any.

---

Royal Thomas

SQL Server 2008 Transact-SQL Recipes: A Problem-Solution Approach (Books for Professionals by Professionals

http://www.amazon.com/Server-2008-Transact-SQL-Recipes-Problem-Solution/dp/1590599802

---

HTH, \\K [Kindly mark the reply as answer if it helps - Support SQLServer Family :-)]