This tip is on databases. Here you go — free on us — compliments of http://www.sozohosting.com/ and also compliments of http://www.biznesstechnologies.com/ :

Writing SQL To Perform For Scalability

You should be using SQL Studio management tools such as a profiler and the query tool to analyze the Execution Plan Statistics of your SQL queries so start with the big queries first. If you are using Microsoft SQL Server Management Studio, run a query in the query window, then click on the “QUERY” menu at the top, and select the submenu “DISPAY ESTIMATED EXECUTION PLAN” option. This will bring up a new execution plan tab for you to look at all your SQL queries to make sure they perform. Look not only at the subtree costs but also for table scans. (Table scans are bad for performance). Correct the SQL with new table designs or new indexes and run the same steps above to optimze. Best to use the ACTUAL EXECUTION PLAN when you are finally done.

Here is a link to learn more on Execution Plans:  http://www.simple-talk.com/sql/performance/execution-plan-basics/

For more information click on this link: http://www.sozohosting.com/knowledge/microsoft-sql-server-database-tips.cfm

Categories: Uncategorized ,Web Hosting ,Web Hosting and Database Tips


Leave a Reply

You must be logged in to post a comment.