question

hanoihanoi avatar image
hanoihanoi asked

Books On Writing SQL Queries

Respected Sirs, I wanted to know which is the best book now in markt for SQL 2012 writing queries. I am Low to medium in SQL Queries But wanted to become an expert in writing queries.
sql-server-2012querybooks
4 comments
10 |1200

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

nidheesh.r.pillai avatar image nidheesh.r.pillai commented ·
Try this book as a start! [Microsoft SQL Server 2012 T-SQL Fundamentals (MSPress) By: Itzik Ben-Gan][1] [1]: http://tsql.solidq.com/books/tsqlfund2012/
7 Likes 7 ·
hanoihanoi avatar image hanoihanoi commented ·
Great . Thanks For all your responce. Its reatly apprciated. Hanoi
0 Likes 0 ·
hanoihanoi avatar image hanoihanoi commented ·
Great. Thank you all for your response. All is appreciated. Hanoi
0 Likes 0 ·
Grant Fritchey avatar image Grant Fritchey ♦♦ commented ·
This web site runs by votes. For all the helpful answers below, please indicate this by clicking on the thumbs up next to each of those answers. If any one answer lead to a solution, please indicate this by clicking the check mark next to that answer.
0 Likes 0 ·
Grant Fritchey avatar image
Grant Fritchey answered
All of Itzik's books are worth having. The latest book is [T-SQL Querying][1]. It will be more advanced than the Fundamentals book, but still should be readable. It will absolutely be useful. [1]: http://www.amazon.com/T-SQL-Querying-Developer-Reference-Ben-Gan/dp/0735685045/ref=sr_1_1?ie=UTF8&qid=1435658837&sr=8-1&keywords=itzik+ben-gan
10 |1200

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

David Wimbush avatar image
David Wimbush answered
This is an excellent idea. I would suggest covering two aspects of query writing: 1. How to write good queries. Definitely Itzik Ben-Gan's books. 2. How to check your queries are being executed efficiently, and where the problem is if they are not. That means understanding the execution plan and there's a great book by some guy called Grant Fritchey: [ http://www.red-gate.com/community/books/sql-server-execution-plans-ed-2][1] [1]: http://www.red-gate.com/community/books/sql-server-execution-plans-ed-2
1 comment
10 |1200

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

Grant Fritchey avatar image Grant Fritchey ♦♦ commented ·
I hear the second man is of somewhat questionable character.
3 Likes 3 ·

Write an Answer

Hint: Notify or tag a user in this post by typing @username.

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.