the procedure is a SQL query with sql server 2000 help it gets executed, which keeps a database of SQL Server. One thing that does not need to write a request, the front end code. Shop with procedures to improve performance now ask how to improve performance. Let’s assume that we have made some of the select query (SELECT * FROM dotnetquestion id1000 and id5000)
Here dotnetquestion table, and 1000 users use this query in the same time. So there are a lot of traffic and congested network. It lost some of us, because the traffic and recovery, and network traffic is transmitted twice. The question is really slow process.
Thus, for the release of network traffic around a small amount of information with sql server 2000 help transmitted over the network. Thus, all these things to do, if stored in a SQL Data Server. Store procedure to preserve the role there, we need ways to save only a small procedure team.
Another advantage of this method is the overhead of trade means that if we have a number of special surveys were carried out on, especially if they occur, but to save the compiled procedures are. Keep running when the collection plan is already in memory, compared with a plan SQL query based on the new shortcut, and if the situation. Thus, methods to save the post.
Another great advantage is that the database if changes in the query, we only need to query only one place to change the server. This DOT NET interview questions can be found dotnetquestion.info
But there are also situations where the store policy does not help, the request must be changed frequently. There are different procedures Store, some of these trade Folmer and can be understood with sql server 2000 help.
1. custom procedure to save
2. System Store procedure
3. Extended procedure Store
download sql server 2000 enterprise2job status sql server 2000 .net2sql 2000 backup to another server2sql server 2000 back up to network drive2sql server 2000 backup to other server2sql server 2000 downloads2sql server 2000 dts designer components2sql server 2000 enterprise manager free
