VS 2005 with SQL Server advantages

Source: Internet
Author: User
Tags dba sql server management oracle developer

Microsoft's consolidation of SQL Server 2005 and Visual Studio 2005 is not a new initiative, Oracle pioneered the Oracle Developer Tools for Visual Studio 2003 at the end of 2004 Visual Studio. NET is intended to provide. NET platform, integrated with Visual Studio's database design and management tools, and even available. NET development stored Procedure (stored procedure). It is believed that Oracle will also launch an updated development version of the. NET Framework 2.0 in the near future.

Stored procedure efficient, but tightly tied to manufacturers

Standing in the position of the program developer, the database is separated from the commercial logic, the database simply stores the data, and the program development is handled by the application. But from the DBA's point of view, the system belongs to the system and the data is handled by the database is better. Although the two views are divided, however, Stored procedure close to the database engine, performance is better, and the data does have the need to deal with the process, remote processing is not only time-consuming, and network disconnection caused the risk of execution failure, therefore, in practice Stored Procedure there is a need for existence.

Stored procedure has the following benefits:

1. Modular program writing: Just create a stored Procedure, stored in the database, you can get different programs to call.

2. Efficient execution: Stored procedure executes faster than a batch of T-SQL program code if a large or repetitive process is required. Because the Stored Procedure is analyzed and optimized when it is established, it is executed once in memory. The program code is repeatedly uploaded from the client to the server every time it executes.

3. Reduce network traffic: Even a good hundreds of of lines of T-SQL program code, as long as through a single instruction can execute stored procedure program code, without having to transfer hundreds of lines of program code on the network.

Although Microsoft's T-SQL or Oracle's PL/SQL, are compatible with Ansi-sql, but after all is not the standard, both are vendor-specific database program language, so as long as the choice of writing stored Procedure, is the beginning of a tight bundle. However, unless there is a major reason for the use of the enterprise selected applications to match the database, there is little replacement, so the performance and bundling measurement, depending on the application.

Stored procedure with T-SQL or. NET development pros and cons

In the case of SQL Server, Visual Studio 2005 is integrated with SQL Server 2005, and the obvious benefit is in developing database programs, such as stored procedure or trigger can be satisfied. In the past, Stored procedure had to be deployed to the database "perform a look" to know if there was a problem, and Stored procedure like a general procedure, files could be modified or accidentally overwritten by others, so there was a need for management. The control of Visual Studio has a positive effect on SQL Server management.

If an enterprise uses T-SQL authoring stored Procedure,sql Server 2005 has been presented with a compact version of Visual Studio,dba no longer requires the use of an Yangchun text editor to compose stored Procedure, you can enjoy development, The benefits of test and version management.

If you are paired with Visual Studio 2005, you can use C # and Visual Basic to compose stored Procedure. In fact, the use of universal programming language to write stored Procedure, Microsoft is not original, Java SQLJ is also a peer-to-peer design.

Related Article

Contact Us

The content source of this page is from Internet, which doesn't represent Alibaba Cloud's opinion; products and services mentioned on that page don't have any relationship with Alibaba Cloud. If the content of the page makes you feel confusing, please write us an email, we will handle the problem within 5 days after receiving your email.

If you find any instances of plagiarism from the community, please send an email to: info-contact@alibabacloud.com and provide relevant evidence. A staff member will contact you within 5 working days.

A Free Trial That Lets You Build Big!

Start building with 50+ products and up to 12 months usage for Elastic Compute Service

  • Sales Support

    1 on 1 presale consultation

  • After-Sales Support

    24/7 Technical Support 6 Free Tickets per Quarter Faster Response

  • Alibaba Cloud offers highly flexible support services tailored to meet your exact needs.