THE SQL Server Blog Spot on the Web

Welcome to - The SQL Server blog spot on the web Sign in | |
in Search

Browse by Tags

All Tags » Best Practices » habits » data types   (RSS)
  • Bad habits to kick : using alias types

    In my last post in this series, I talked about using the visual designers in SSMS.  This time, I wanted to treat the use of alias types. To clarify what I am talking about here, alias types used to be called ''user-defined data types.''  Then, when CLR came around in SQL Server 2005, they gave us the ability to create our own CLR ...
    Posted to Aaron Bertrand (Weblog) by AaronBertrand on October 14, 2009
  • Bad habits to kick : choosing the wrong data type

    In my last post in this series, I talked about the assumptions many people make about IDENTITY columns.  In this post, I want to focus on choosing data types.  There are several areas where I see frequent mistakes in data type choice, and I'll mention a few here. Using CHAR / VARCHAR / INT for date / time values Countless times I have ...
    Posted to Aaron Bertrand (Weblog) by AaronBertrand on October 12, 2009
Privacy Statement