Saturday, December 17, 2011

Speed up query or Stored procedure in sql server 2005 or 2008

Speed up query or Stored procedure in sql server 2005 or 2008

Way to optimize your query or stored procedure:

1. We can use Sql perfomance tuner under Tool's in menu bar. we just need to provide script file or database object like sp to get suggestion from sql server 2005.
Mostly it will ask to add index and statistics into tables.

2. We can also use Estimated Plan to check if our query missing any index or statistics on a table.


Happy Living...
Happy Coding...
Happy Concepts...

    

No comments:

Post a Comment