May 1, 2007 at 4:47 pm
I have around 2 years of experience in programming but find myself wangting in implementing some of cool features like derived tables etc when writing queries.I am looking for a book that can provide me with sample scenarios for which i can write queries so that I can write efficient queries.
May 2, 2007 at 4:13 am
The inside sql server books would be my first port of call, there's three which probably cover your question;
Applied Techniques, T-SQL Programming and T-SQL Querying.
[font="Comic Sans MS"]The GrumpyOldDBA[/font]
www.grumpyolddba.co.uk
http://sqlblogcasts.com/blogs/grumpyolddba/
May 2, 2007 at 5:47 am
I would not recommend the book in the thread below to some one new to SQL Server, my advice install the product and run searches for code samples on MSDN2 and the BOL. When experts writes a book full of errors it can confuse new users of the product.
http://www.sqlservercentral.com/forums/shwmessage.aspx?forumid=61&messageid=362187
Kind regards,
Gift Peddie
May 2, 2007 at 6:47 am
well, maybe, but two years doesn't sound new to me.
[font="Comic Sans MS"]The GrumpyOldDBA[/font]
www.grumpyolddba.co.uk
http://sqlblogcasts.com/blogs/grumpyolddba/
May 2, 2007 at 7:29 am
I know that book was not written for SQL Server 2005, it will not help the person to write code that will be rejected by SQL Server 2005.
Kind regards,
Gift Peddie
May 2, 2007 at 8:03 am
Thanks for all the posts i have received. I will surely follow the book as well as run samples from BOL. I sincerely hope that I will improve and get to my objective of writing efficient queries.Thanks again.
May 3, 2007 at 6:48 am
One of my favorites is Beginning Transact SQL ... by wrox press.
Best,
Kevin G. Boles
SQL Server Consultant
SQL MVP 2007-2012
TheSQLGuru on googles mail service
May 3, 2007 at 7:32 am
The best, most comprehensive:
Inside Microsoft SQL Server 2005: T-SQL Querying by Itzik Ben-Gan
May 3, 2007 at 7:42 am
That is not what the posting by Microsoft support says and I agree.
http://www.sqlservercentral.com/forums/shwmessage.aspx?forumid=61&messageid=362187
Kind regards,
Gift Peddie
May 3, 2007 at 8:08 am
I have the HIGHEST regards for Itzik's skills with TSQL and enjoy his writings and even use a number of his examples in my classes/presentations. This book, however, is NOT one to help a relative newcomer get better at TSQL. Also I personally think he spends too much of this book covering more esoteric (and thus not often used) topics. Perhaps I am just an isolated sql guy though and everyone else does have a regular need for graphing, trees, apply, ranking, etc. :-))
Best,
Kevin G. Boles
SQL Server Consultant
SQL MVP 2007-2012
TheSQLGuru on googles mail service
May 3, 2007 at 8:10 am
Hi ,
I downloaded latest BOL version from microsoft.I looked at SQL books online and saw Samples and Sample Databases link.Is that you are talking of samples? I am not able to find much samples in BOL. Most of the topics are related to Integration,Notification services etc. I know they are also to be get aware of, but right now i am looking at T-SQL . Can you provide me any link where i could get to write and test my T-SQL skills after referring BOL and books refered in the posts.Thanks for your help in this regard.
Regards
May 3, 2007 at 8:11 am
I want to jump on the band wagon and recommend Itzik Ben-Gan's "Inside TSQL Querying". Add to it his "Inside TSQL Programming". The first book is all about TSQL queries. The second book is about applying them to XML, CLR, stored procedures, triggers, transactions and exception handling. After that, The Art of SQL.
Here are in depth reviews of two of those books:
(full disclosure, I wrote this review)
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore Roosevelt
Author of:
SQL Server Execution Plans
SQL Server Query Performance Tuning
May 3, 2007 at 8:15 am
There is a lot of time in Itzik's book on graphing & trees & pivots that, in my opinion, won't be used by most people (myself included). However the APPLY & RANKING stuff is extremely useful. Next time you have a sub-select, see if the CROSS APPLY or OUTER APPLY will work instead of a regular join. Testing around here found that, when it worked, it radically increased performance.
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore Roosevelt
Author of:
SQL Server Execution Plans
SQL Server Query Performance Tuning
May 3, 2007 at 8:16 am
Download the AdventureWorks database from Microsoft. It's a pretty good place for running tests & learning.
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore Roosevelt
Author of:
SQL Server Execution Plans
SQL Server Query Performance Tuning
May 3, 2007 at 8:17 am
Thanks, you have covered what I am trying to get across, the product changed and they did not get how much which is very sad.
Kind regards,
Gift Peddie
Viewing 15 posts - 1 through 15 (of 22 total)
You must be logged in to reply to this topic. Login to reply