Performance Based Transact Coding

Hi all,

I am looking for some study meaterial focussed on performance based transact SQL development. I am a fairly well seasoned (3+ years self taught), and I am getting into situations where different query constructs yield the same results, but the performance (execution time and disk I/O) varies.

I have found that sometimes nested select statements execute faster than joins, but usually the opposite is true, for example, and I would like to learn why.

Info would be appreciated.

some food for the brains for DBA's

most database performance relies on the following

1. database design (normalization)

2. Tsql Syntax. it pays to know your select, insert, update, stament indepth

3. know your index

4. know your join. from which table should you select first. lets say order of joined tables

5. when to cusrsor and when not to

6. selecting only the needed data

7. physical - files and filegroups, tlogs location, raids. etc

8. locks and deadlocks

|||

Hi,

Thanks for the reply. I am aware of the points you mentioned above, what I am looking for however is some courses on the point 2 above.

I am a developer and not a DBA, so my tasks relate more to the writing of "best" T-SQL queries and stored procedures, do you maybe have any documentation on it?

|||

any sql server 70-229 book will do.

you cam try osborne, sybex, and mspress

|||

Hi Andriaan,

There are several aspects considered for efficient T-SQL scripts that do not hit perforamnce and improve performance.

Theres no single resource that would fetch you a complete 100% coverage. But, there are good aspects you add on each time you read something and improve on them.

The basics like "IF exists" ...and stuff can be found in books. There are ample resources on MSDN,MS KB,Forums and Blogs.

Like the articles on : http://www.sql-server-performance.com/articles_performance.asp

will keep you updated on good articles