SQL Server Performance Forum – Threads Archive

To Boost Performance

We are designing the database for a high load web application. We used 4 techniques. 1.No outer joins,No Unions, > only in reports
2.No joins in main forms
3.Choose the smallest dataTypes possible.
4.Used a single instance for all users.
Are there any additional MAJOR ones?

---

If you can, aviod cursors.
Luis Martin
Moderator
SQL-Server-Performance.com Although nature commences with reason and ends in experience it is necessary for us to do the opposite, that is to commence with experience and from this to proceed to investigate the reason.
Leonardo Da Vinci Nunca esperes el reconocimiento de tus hijos, eso ocurrirá luego de tu muerte
All postings are provided “AS IS” with no warranties for accuracy.

---

Make sure the tables are normalised
http://www.datamodel.org/NormalizationRules.html Madhivanan Failing to plan is Planning to fail

---

]]>