We all know how to create database, how to create tables etc... But do we know how to improve query performance when your database growing. Imaging the situation when your table will have more than a million rows. Just think what will be the query output time??
I personally working on the application where there are daily around more than 5000 transactions happens. So you can imagine what will be my table size after a few months. When I was writing this article, my table already has around ½ million rows.
I personally feel that this kind of large database will teach you a lot about the real power of SQL Server and best practices.
In my case, the query which was giving me result in less than a second, now taking more than 30 seconds. It’s because of half a million rows in transaction table. That’s the worst thing in terms of performance.
Luckily, I got help from Mr. Pinal Dave, he is Most Valuable Person (MVP) , he is SQL Guru, he is founder of sqlauthority.com, he has written more than 900 blogs till now. He is lot more than that. He is well known personality in the IT world.
He taught me and my of my co-workers, how to use joins, indexes and many more SQL related things. He solved my problem efficiently and also explain me the things he has done on tables. I learn a lot from that and I am confident that I can improve performance of large database.
You can contact me for the SQL Query Optimization related issues.
No comments:
Post a Comment