question

Parm avatar image
Parm asked

Book suggestion

i want to make a stored procedure's in sql server 2005 and also want to gain knowledge about them. Can anyone please suggest me the books. So i can start studying about the stored procedures and make my own.

Please reply me as soon as possible...................

books
10 |1200

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

Jay Bonk avatar image
Jay Bonk answered

For learning the fundamentals of SQL Server I could recommend this book: Microsoft SQL Server 2008 T-SQL Fundamentals

And for understanding Stored Procedures, User Defined Functions, Views, Triggers, etc. this would be an excellent choice: Inside Microsoft SQL Server 2008: T-SQL Programming, Itzik Ben-Gan is the author of both books.

3 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.

Grant Fritchey avatar image Grant Fritchey ♦♦ commented ·
Huge pluses for Itzik Ben-Gan and his excellent books. This is the place to build TSQL knowledge.
1 Like 1 ·
Blackhawk-17 avatar image Blackhawk-17 commented ·
Inside Microsoft SQL Server 2005: T-SQL Querying, another Itzik Ben-Gan offering, is excellent as well.
1 Like 1 ·
TimothyAWiseman avatar image TimothyAWiseman commented ·
I concur and those are good recommendations, but I think he specified 2005.
1 Like 1 ·
Fatherjack avatar image
Fatherjack answered

If you are beginning then simply start with Books OnLine - press F1 when you are is the query editor window in SSMS or use the online version here http://msdn.microsoft.com/en-us/library/ms187926.aspx

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.

Jay Bonk avatar image Jay Bonk commented ·
+1 For the online link to MSDN, found this one also... http://www.informit.com/articles/article.aspx?p=25288
0 Likes 0 ·
Matt Whitfield avatar image
Matt Whitfield answered

Two excellent books:
MVP Deep Dives
SQL Server 2008 Query Performance Tuning Distilled

If you just want to learn how to make stored procedures as quickly as possible, use Google, Copy & Paste. If you want to learn how to write good stored procedures, and know why they are good, then you are at the beginning of a long journey. It's a road I've been travelling down for about 12 years, and I learn new stuff all the time. The books above will help you on that journey immensely.

10 |1200

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

TimothyAWiseman avatar image
TimothyAWiseman answered

You didn't specify what level of knowledge of Sql you have.

If you are already fairly knowledge on the basics, then I will second Jay's suggestions of Itzik Ben-Gan's works. He is phenomenal. Though, since you mentioned 2005 make sure you are picking up the 2005 and not the 2008 versions. The differences between the two are relatively minor, but no reason to have a mismatch between your study material and your work environment.

If you are on the other hand just starting out, the Manga Guide to Databases is a surprisingly good primer. It is only a primer, but if you are just starting it is good to read before starting on the more advanced books Jay and the others have recommended.

Also, do not neglect online articles and magazines like Sql Server Magazine. www.SqlServerCentral.com has a wealth of good article, and I especially recommend everything by Jeff Moden. www.simple-talk.com is also an awesome resource that also dives into .Net and general windows administration.

10 |1200

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

DaniSQL avatar image
DaniSQL answered

All outstanding Recommendations!

We are in the same boat and here is what I am doing in a quest to learn T-SQL programming:

If you are just starting out check out this links for beginners from sql-server-performance.com and also this article from informit.com. Also checkout Books online.

Then check out Itzik Ben-Gan books(currently reading his books after suggested to me here in this forum and it's as good as they said) then check out "SQL Server 2008 Query Performance Tuning Distilled" to take your skills to the next level.(atleast thats what I am hoping for when I finally pick it up from my desk after I am done with Itzik Ben-Gan books:-)

Finally: Practice! Practice! Practice! Practice! Practice!

Good Luck!

10 |1200

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

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.