Efficient SQL

by Mike Y

            The article goes into how to better optimally use SQL Server because as technology advances and becomes more complex, it becomes increasingly harder to find the most efficient method. The authors go into improving the performance of SQL Server instances, queries, and optimization features in SQL Server 2008. The ways of running efficiently are further explored by going into more detail in having efficient data schema, indexes, avoiding recompiling of execution plans, among other things.

            Running an efficient database translates to better performance and lower costs in the long term. It is why many tech companies value efficiency. Having a smooth running server translates to a better customer experience for business that have some operations done online which is most companies today. I feel that most companies do not yet realize the importance of a good system like the tech companies such as Google does.

            A well planned and executed server should not only perform better but also be more secure. It is impossible to safeguard versus everything since new technology keeps emerging creating more chances of vulnerabilities. It would be disastrous to a company’s reputation if security was breached due to incompetence of an employee instead of a hacker’s malicious intent.

Mercioiu, N. (2010). Improving sql server performance. Informatica Economica, 55-60. Retrieved from http://0-search.proquest.com.opac.library.csupomona.edu/docview/613368167?accountid=10357

6 thoughts on “Efficient SQL”

  1. Good article. I agree that as technology advances there will be new and more efficient ways of doing things. This article brings to light the fact that in this industry we need ot stay up on the most current ways of doing things or we will outdate ourselves.

  2. Good article. I agree that in order to have server run efficiently we need to have good data schema and index. thank you for posting this article

  3. With the way the world is heading, efficiency is the best policy. People want things done fast and correct and securely and if you hope to succeed in this ever changing economy then you have to give people what they want. Like Daniel said, we need to stay updated before we outdate ourselves.

  4. Good article. I agree that in order to have server run efficiently we need to have good data schema and index. thank you for posting this article.

Comments are closed.