Optimizing SQL

by Brian B
The article I picked this week is titled “Improving SQL Server Performance” by Victor Vladucu and Nicolae Mercioiu. The article starts off by saying that in some cases efficiency and performance are neglected until the end of the development process. They only become important once the system starts being used in the real world. The article says that this could be caused by anything from the design of the database to bad management of the system. The author says that when trying to optimize performance you should aim for “good enough” instead of trying to aim for the theoretical maximum. In the second part of the article they talks about the importance of using indexed locations to speed up queries along with a few other measures to keep performance at its peak. The third part of the article talks about query optimization.  It gives some examples of how to structure queries and what to avoid.  The article offers a couple of different ways to change your queries to optimize them, but they removed the actual queries from the article. The fourth part of the article deals with what it calls “new optimizing options” for SQL server 2008. The article ends by rounding out the optimization process and that it is iterative in nature.

I picked this article because it talked about SQL and optimizing SQL queries. I thought it would be a good article to blog about because we just started to talk about SQL in class. However, the database that I pulled the article from removed some of the content which made the article significantly harder to read without all of the information that should have been there.

I thought it was an interesting article because it was related to the topic we started discussing it in class. However, because of the missing information I feel as though the article has lost some of the value it could have had if it had remained unchanged.

 

Mercioiu, N., & Vladucu, V. (2010). Improving SQL Server Performance. Informatica Economica, 55-60.

 

 

2 thoughts on “Optimizing SQL

  • November 4, 2012 at 10:05 pm
    Permalink

    I definitely agree that optimization is important when it comes to SQL and databases. Indexing will increase query speed and is, more likely than not, a sure good choice for most databases. Speed is especially important if you are using the database for a website. We learned earlier than Google takes speed into account when determining search result placement. Thanks for the post.

  • November 5, 2012 at 12:43 am
    Permalink

    It’s definitely critical to have both a flawless design and management. Without either, companies with big data will not last. I agree that efficiency and performance should be neglected until after the development process because it’s easier to find out what needs to be further improved after development.

Comments are closed.