SQLBits 2013
Database Design: Size Does Matter!
Great database performance starts with great database design. During the design process it is important to select your SQL Server datatypes wisely. Failure to do so will result in wasted disk space, additional I/O overhead, and decreased performance.
Great database performance starts with great database design. During the design process it is important to select your SQL Server datatypes wisely. Failure to do so will result in wasted disk space, additional I/O overhead, and decreased performance. There is also the risk that your design will not scale as well as it should. Unless you have unlimited hardware purchasing power, size matters.
Attend this session and learn how smart, effective database design will ensure your databases perform at their peak efficiency. You will learn how to choose the best performing datatypes, how to measure their effectiveness, and how to correct bad datatypes decisions (decision that were not, of course, made by you.)
Attend this session and learn how smart, effective database design will ensure your databases perform at their peak efficiency. You will learn how to choose the best performing datatypes, how to measure their effectiveness, and how to correct bad datatypes decisions (decision that were not, of course, made by you.)
Speakers
Thomas LaRock's previous sessions
From Here to Azure
Attend this interactive session and learn how to create, deploy, and migrate data from your on-premises instance of SQL Server to Microsoft Azure Virtual Machines and Microsoft Azure SQL Database.
Database Design: Size DOES Matter
Great database performance starts with great database design.
Cardinality Estimates in Microsoft SQL Server 2014
Attend this session and understand how, why, and when SQL Server uses statistics and how this new feature will help improve performance.
Monitoring Databases in a Virtual Environment
This session will help DBAs to understand what changes they need to make in their performance and monitoring practices for virtualized database servers.
Database Design: Size Does Matter!
Great database performance starts with great database design. During the design process it is important to select your SQL Server datatypes wisely. Failure to do so will result in wasted disk space, additional I/O overhead, and decreased performance.