February 17, 2009 at 7:04 am
Hi ALl,
Please provisde me some insights on how to improve the SQL stored procedures performance in SQL 2008 server.
I am a novice to sql 2008.
Thanks in advance.
February 18, 2009 at 12:42 pm
v-makath (2/17/2009)
Hi ALl,Please provisde me some insights on how to improve the SQL stored procedures performance in SQL 2008 server.
I am a novice to sql 2008.
Thanks in advance.
You ought to post this in one of the SQL Server 2008 forums. This one is for 2005.
Also, I'm gonna guess that you're having problems with a specific stored procedure? Examples would be most helpful, if you want help.
February 18, 2009 at 1:03 pm
One of the best ways to improve performance is to write good queries.
Another is to have a well-defined data architecture (schema).
You should also set up the right indexes and maintenance for them.
Does that help?
- 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
February 18, 2009 at 1:46 pm
That's a way too open question.
You should read (A LOT) first about how SQL Server works.
* Noel
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply