Thank you guys. i'll certainly take help of his proc. Also I've till now worked on OLAP environment and this will be first time i'll be working on OLTP. Is there any documentation on t-sql best practices for OLTP environment. I burned my midnight oil to search a lot but couldn't get any.