Discussion Locked
0 helpful
6 replies
Closed to new repliesThis discussion is closed. It stays readable, but it takes no new replies.
I am using SQL Server 2000. And i wrote some SP. I need to run this stored procedure on 2.2 million data, and it again creats 7.8 million data. Its taking so much time to do this. I want to know some tips to improve the SQL Server performance and some tips regarding the Stored Procedures. Please let me know. Thank you.
6 replies
Hi,
Without knowing what your query is or the structure of your database, I cant really give you specifics... but here is a site that describes tuning a SQLServer2000 database.
It will have useful information for your SP writing too!
Hope it helps,
Cheers,
Tim.
The question was auto-closed by TechRepublic
by sachinp78
Just visit these sites
http://www.sql-server-performance.com/
http://www.sqlmag.com
http://www.microsoft.com/sql
http://msdn.microsoft.com/sqlserver/
http://www.swynk.com
The question was auto-closed by TechRepublic
This question was auto closed due to inactivity
This discussion is closed to new replies.
Trending Web Development posts
Sort by Trending
Question Unanswered
How can developers improve performance on content-heavy websites?
0 helpful
0 replies
Question Unanswered
How do you protect downloadable files on a WordPress store?
0 helpful
0 replies
0 helpful
1 reply
1 helpful
3 replies
Discussion Locked
What Makes a Business Website Effective in 2026
2 helpful
10 replies