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
1 helpful
3 replies
Discussion Locked
What Makes a Business Website Effective in 2026
2 helpful
10 replies
0 helpful
1 reply
Question
Windows and macOS computers becoming slow or unstable after updates - what should I check first
0 helpful
1 reply
Discussion
Optimizing WordPress widgets and DOM size
0 helpful
3 replies