Monday, June 15, 2009

SQL Server Optimization tips

Nice article on SQL Server Optimization tips and performance consideration for selecting SQL Server data types.

Most of the content of this article would have been greek and latin to me had I not been working in Lumenos.

I still remember those days when I used to write "Extravaganza Report" in one single stored procedure spanning 2000 lines. I have moved more toward ORM based architecture these days in my current company, but I still think a report as complex (it really was) as extravaganza needs stored procedure for the kind of SLA that was expected out it..

No comments: