Selecting inappropriate data types, especially on large tables with millions or billions of rows, can have significant performance implications. Recently I found an article that discusses data type performance to a decent depth. I believe this article would be very beneficial for starters who are new to SQL Server 2005 / 2008. This article can also be a very handy reference for SQL Server Interview questions for data types.
Reference: PASS Performance SIG
Article 
No comments:
Post a Comment