Database Journal
MS SQL Oracle DB2 Access MySQL PostgreSQL Sybase PHP SQL Etc SQL Scripts & Samples Tips Database Forum

» Database Journal Home
» Database Articles
» Database Tutorials
MS Access
SQL Scripts & Samples
» Database Forum
» Slideshows
Free Newsletters:

News Via RSS Feed

Database Journal |DBA Support |SQLCourse |SQLCourse2

Featured Database Articles

Database News

Posted Dec 12, 2002

Best Practices to Enhance your SQL Server Applications

By DatabaseJournal.com Staff

[From Builder.com]

If you are developing a database application with SQL Server, you must take time to learn how SQL Server works (especially SQL-DMO and DTS). There are a lot of different techniques and solutions available and there is a lot of discussion about best practices. These practices look good on paper, but how to implement them or design them is often unclear. The hard work of getting the database server designed and implemented correctly will pay off in the future, so let's take a look at a few best practices for your SQL Server environment to set you on the right track.

Using SQL Server views is a good idea, but there are still some serious drawbacks. For the most part, they are slower than inline SQL Statements. But if you have an enterprise version of SQL Server 2000, you can add indexes to greatly improve view performance. However, the more common standard version of SQL Server 2000 doesn't support indexed views. If performance is not an issue, though, views are a good way to aggregate data and control permissions. But SQL Server must retrieve the view definition and compile it for every call.

The article continues at http://builder.com.com/article.jhtml?id=u00320021212RCH01.htm&page=1&vf=tt.

Back to Database Journal Home

Database News Archives

Comment and Contribute


(Maximum characters: 1200). You have characters left.



Latest Forum Threads
Database News Forum
Topic By Replies Updated
Efficient SQL Server Indexing by Design lcole 0 April 30th, 12:38 PM
Mine Oracle Database, SQL Server and Other Databases with Monarch Data Pump Pro V10.5 lcole 0 April 30th, 12:37 PM
Oracle Database and Oracle Fusion Middleware for Private Social Network Application lcole 0 April 30th, 12:31 PM
Oracle Database Maintains a Stronghold in the DBMS Market lcole 0 April 30th, 12:30 PM