Ouch! Our Data Type Choices Did THAT?
It’s an all too common occurrence to have table columns or variables that have been assigned less than ideal data types. Join this session and learn the importance of choosing the proper data type, the guidelines in determining what an appropriate data type would be, and, once chosen, some tools for its usage and management. There will be several demonstrations on performance and accuracy issues, along with their possible solutions, caused by either the assignment of inappropriate data types or improper usage of them.
In addition, we will cover several data type related functions, and the caveats in their usage. Even advanced T-SQL developers and DBAs will walk away with a useful nugget or two.