Proper DataType Usage=Guaranteed Better Performance and Accuracy
Application & Database Development
It’s an all too common occurrence to have table columns or variables that have been assigned less than ideal data types.
In this demo-heavy presentation I will show you the importance of choosing the proper data type; show you some guidelines in determining what an appropriate data type would be; and once chosen, give you some tools for its usage and management. I will demonstrate several 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 I will cover several data type related functions, and point out caveats in their usage. I expect even advanced T-SQL developers and DBAs to walk away with a useful nugget or two.
Basic understanding of table design. T-SQL query writing.