- It’s an all too common occurrence to have table columns or variables that have been assigned less than ideal data types. My goal in this presentation is to convince you of 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.
Simplifying Data Import
- Andre (Blog | LinkedIn | Twitter) is an accomplished team leader, having worked with both informal teams and formal management roles. As a consultant, he is prepared to use the tool sets and resources available on site, and as experienced technologist, he is adept at using available tools to solve problems. Andre’s primary focus in on the Microsoft stack and pc technologies -but he has also worked with mainframe systems. He enjoys many creative pursuits, such as cooking, playing music and photography.
- The SQL Server related job market is still vibrant, and there are several open positions (Admins, Developers, BI -from entry to advanced skills) in the Oregon/SW Washington region. Check out the Oregon SQL Jobs page. Tell your friends and colleagues to regularly visit the Jobs page.
- For over two decades, VHA has been a premier staffing provider of technology professionals in the Pacific Northwest. We have since expanded to provide professional accounting placement services. While it might seem unusual for a rapid-deploy, results-driven business like ours to take that responsibility personally, we do. Our President’s work ethic not only serves as the foundation of our company, but drives the commitment to individual attention which infuses our culture. We are dedicated to the satisfaction and success of our clients and consultants. We are committed to providing outstanding service to a uniquely demanding industry in a straightforward, ethical, highly personal, and always-responsive manner.
View our website for more details.