I'm new to SQL development..

Question

Post reply

I'm new to SQL development..

squvi.87

Default port

Points: 1450
More actions
September 28, 2014 at 10:07 pm

#311218

Hi There,
I'm new to SQL development.. please assist me something that every developer must know & the performance perspectives. suggest me some links to read out and equip my self.
Thanks in advance

Viewing 6 posts - 1 through 5 (of 5 total)

You must be logged in to reply to this topic. Login to reply

Koen Verbeeck SSC Guru Points: 259155 More actions · Answer 1

As a SQL developer, you should know how to develop TSQL of course.

I can recommend the books written by Itzik Ben-Gan.

Microsoft SQL Server 2012 T-SQL Fundamentals

If you have more specific questions, we'll be glad to answer them.

Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP

Luis Cazares SSC Guru Points: 183706 More actions · Answer 2

You could also try this basic tips: 45 Database Performance Tips for Developers.

The book recommended by Koen is more complete, but this one can give you some basic performance principles on SQL.

Luis C.
General Disclaimer:
Are you seriously taking the advice and code from someone from the internet without testing it? Do you at least understand it? Or can it easily kill your server?

How to post data/code on a forum to get the best help: Option 1 / Option 2

Alan Burstein SSC Guru Points: 61141 More actions · Answer 3

I would second both recommendations and add that you can't go wrong with any Itzek ben-Gan book.

Learn what a tally table is; that has changed my career.

This site is goldmine; take a look at the stairways and free pdf's.

"I cant stress enough the importance of switching from a sequential files mindset to set-based thinking. After you make the switch, you can spend your time tuning and optimizing your queries instead of maintaining lengthy, poor-performing code."

-- Itzik Ben-Gan 2001

Jason-299789 SSC-Insane Points: 21601 More actions · Answer 4

If you are new then the books by Itzik Ben-gan are very good, the previously mentioned book, as well as Inside Microsoft® SQL Server® 2008: T-SQL Querying which can be found here http://www.amazon.co.uk/Inside-Microsoft%C2%AE-SQL-Server%C2%AE-2008/dp/0735626030

for more advanced topics then look for books by Grant Fritchey who is also a regular on these boards.

Finally simply come back to SSC and ask on the boards there are always a number of people willing to help and offer solutions. Just remember to follow posting rules, to get optimal help.

_________________________________________________________________________
SSC Guide to Posting and Best Practices

Koen Verbeeck SSC Guru Points: 259155 More actions · Answer 5

Alan.B (9/29/2014)
Learn what a tally table is; that has changed my career.

+1000

Good set based programming is what makes the difference between a good SQL developer and a great SQL developer.

Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP

I'm new to SQL development..

Cookies on SQLServerCentral