October 8, 2010 at 8:52 am
Keeping in mind the developers.
Keeping mind the poorly written SQL and network issues.
I am looking for references to Best Practices while writting Structured Querry Langauage.
Ex: Why to not use cursors, How to avoid them ?
using HINTS in Qurries.
wise usage of where caluse.
What ever.
I am looking at TSQL and PL/SQL.
thanks a bunch experts.
I dont care if it is a in depth discussion or over view. I will do teh refining part. Thanks
[font="Verdana"]
Today is the tomorrow you worried about yesterday:-)[/font]
October 8, 2010 at 11:28 am
Start with an online search for "t-sql best practices" and "pl/sql best practices". You'll find dozen or hundreds of good articles on the subjects.
- Gus "GSquared", RSVP, OODA, MAP, NMVP, FAQ, SAT, SQL, DNA, RNA, UOI, IOU, AM, PM, AD, BC, BCE, USA, UN, CF, ROFL, LOL, ETC
Property of The Thread
"Nobody knows the age of the human race, but everyone agrees it's old enough to know better." - Anon
October 8, 2010 at 11:37 am
Best thing you can do is pick up a copy of Itzik Ben-Gan's Inside SQL Server TSQL Querying. Make all the developers read that. That'll do more positive than any suggestion on how to avoid cursors will do for you.
"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
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply