The importance of proper table design,especially when you dealing with big data, such as billions in rows and hundreds GB in size, cannot be underestimated. Misconception could lead into serious problems not only in terms of database performance, but also it can effect disk space management and interactivity of user interface as well. In this session audience will have a sensible walk-through database and table design in detail, encompassing a number of key areas of focus ranging from Data Types to FILESTREAM implementation. Discuss most common a table design mistakes. Find out efficiency of one type over another, IDENTETY vs. SEQUENCE vs. GUID to support PK uniqueness, pros and cons of using composite Primary Key and SPARCE column, and more.
Currently working in the Pennsylvania branch of Cox Automotive, headquartered in Atlanta, GA. His primary focus is with the latest Microsoft technologies
Alex has more than 20 years IT experience and currently working in the Pennsylvania branch of Cox Automotive, headquartered in Atlanta, GA. His primary focus is with the latest Microsoft technologies including .NET (VB and C#), SSRS, SSIS. He provides tuning, optimization, analysis and development service creating new applications, converting legacy technologies (SQL Server, VB.NET and C# ) and one site training. He has worked for the CSC, VerticalNet, IDP, LSAC, TMNAS to name a few and Alex is Data architect at HexaArt Inc. He provides consulting service from NYC, Philadelphia to Delaware. Alex published articles for SQLServerCentral.com and Simple-Talk. Author “XML and JSON Recipes for SQL Server” published by Apress.