No More Bad Dates: Best Practices for Working With Dates and Times


Presenter: Kendra Little

Session Details


Dates and times can be tricky. SQL Server provides six temporal datatypes with a host of differences in terms of storage and behavior. We'll cover five best practices that will help you select the right temporal data type, avoid common issues, and use the most effective techniques to aggregate data. We'll also take a look at common problems with query performance and how to avoid them. Choose wisely: the correct types and high performing data access logic will scale well and save development and administrative time.


About the Speaker


Kendra Little is a Senior Database Administrator at WildTangent Games who has spent ten years nerding out on SQL Server. She likes performance tuning, automating processes, building SQL Reports, and (secretly) writing documentation. Kendra has a Masters in Philosophy and a salt shaker full of certifications, but all the best stuff she's learned lately has come from her smarty-pants colleagues and the SQL Server community. Read her blog at







Copyright 2013 by PASS | Terms of Use | Privacy | Login