I want some Moore

Blog about stuff and things and stuff. Mostly about SQL server and .Net
posts - 219, comments - 2287, trackbacks - 33

My Links

Advertisement

News

Hi! My name is 
Mladen Prajdić  I'm from Slovenia and I'm currently working as a .Net (C#) and SQL Server developer.

I also speak at local user group meetings and conferences like SQLBits and NT Conference
Welcome to my blog.
SQL Server MVP

My Books

SQL Server MVP Deep Dives 2
The Red Gate Guide to SQL Server Team based Development Free e-book

My Blog Feed via Email
Follow MladenPrajdic on Twitter


Users Online: who's online

Article Categories

Archives

Post Categories

Cool software

Other Blogs

Other stuff

SQL stuff

Book Review: Inside SQL Server 2005: T-SQL QUERYING

This is an AWSOME book!

Written by Itzik Ben-Gan and coauthored by Lubor Kolar and Dejan Sarka it's definitly worth it's money.

It starts with the chapter on logical query processing in which it explaines the basics of the full select statement and the order of processing it.

Just basic stuff.

Chapter 2 covers the phyisical query processing. Explaines what parsing, algebratization and executions plans are and how it's all tied together.

Chapter 3 covers the query tuning methodology and tools to use for it. In my opinion This chapter is one of the best in the book.

Chapter 4 introduces us to subqueries, CTE's and Rank functions.

Chapter 5 talks about joins and set operations like INTERSECT, EXCEPT and UNION.

Chapter 6 is about Aggregation and Pivoting. This is one of the 3 best chapters in the book.

Chapter 7 covers Top and Apply operators.

Chapter 8 talks about data modification: Insert, delete and update statements.

Chapter 9 brings us Graphs, Trees, Hierarchies and Recursion. It's all covered in great detail and uses new SQL Server features to accomplish the goals.

This one is also in the Top 3 chapters in the book along side Chapters 3 and 6.

 

There's also an appendix that holds interesting logic puzzles whic can be a lot of fun to play with.

 

For me reading this book was a very special experience. Why? Because i learned at least 1 new thing per 5-10 pages.

And in my opinion THAT makes a book GREAT!

 

I recommend this one to every sql developer out there. Simply because it's handy and a great reference to have.

And if for nothing else just for chapters 3, 6 and 9. Simply awsome.

 

Amazon link here.

Print | posted on Friday, May 11, 2007 11:27 AM | Filed Under [ SQL Server Reviews ]

Feedback

Gravatar

# re: Book Review: Inside SQL Server 2005: T-SQL QUERYING

How much time did you spend reading this book? Congrats for xeam :)
5/11/2007 8:49 PM | Edge
Gravatar

# re: Book Review: Inside SQL Server 2005: T-SQL QUERYING

thanx!

i read it in 4 days. it's very readable :)))
5/11/2007 8:58 PM | Mladen
Gravatar

# re: Book Review: Inside SQL Server 2005: T-SQL QUERYING

I have the same book I also have his other one for TSQL, the first one is the querying book followed by his tsql programming one. I dunno, I did not feel the same way, I got a bit bored with his book. He has some complex examples, and probably very good stuff, but I could not find myself reading it for more than 20 minutes.
5/11/2007 10:18 PM | Jon
Gravatar

# re: Book Review: Inside SQL Server 2005: T-SQL QUERYING

i also have T-SQL Programming and The Storage Engine.
I've already read the programming one and finishing up on The Storage Engine.

I found both as great as T-SQL querying.

but i guess it's what interests you what counts, right? :)
5/11/2007 10:22 PM | Mladen
Gravatar

# re: Book Review: Inside SQL Server 2005: T-SQL QUERYING

i'm a very fast reader :))

i know how it is reading on a train. you get distracted very easy.
the interruptions are constant so you can't focus on the content 100%.
at least it's like that for me.

I had peace and quiet for 4 days.
5/11/2007 10:28 PM | Mladen
Gravatar

# re: Book Review: Inside SQL Server 2005: T-SQL QUERYING

I am still reading it but when I was commuting from Princeton and New York City I would read at least a book a week. I took the Amtrak every day and that was very good for reading books (or watching movies) compared to NJ Transit. Now that I have a 10 minute commute and 3 kids I don't read (or do anything else for that matter) that much ;-(
It is a great book a lot of good detail

5/12/2007 12:58 AM | Denis the SQL Menace
Gravatar

# re: Book Review: Inside SQL Server 2005: T-SQL QUERYING

ok good
3/8/2008 2:14 PM | bala
Gravatar

# re: Book Review: Inside SQL Server 2005: T-SQL QUERYING

The fourth volume Inside SQL Server 2005: Query Tuning and Optimization, was released in September 2007. This volume was not a solo effort, but has chapters written by Sunil Agarwal and Craig Freedman of the SQL Server product team at Microsoft, and well as chapters by two of my colleagues: Adam Machanic and Ron Talmage.
5/11/2010 8:25 AM | Scegli il migliore casinò
Comments have been closed on this topic.

Powered by:
Powered By Subtext Powered By ASP.NET