It’s T-SQL Tuesday time again, and this month’s honor to host the blog party goes to Brent Ozar. The topic is data types:
Mad about money? Feverish about float? Tell us what you use your favorite data type for, and what people need to know before they get started using it. Data types have so many interesting edge cases, like when Aaron Bertrand taught us to use lower case for our data types. (I still don’t do that, but for the record, I do feel guilty.)
I’m going to write about the data types date and time. When I started working with SQL Server, there was only the datetime data type, which usually covered our needs. Unless you needed precision smaller than 3ms that is. In SQL Server 2008, a new set of data types for handling time information was introduced. I’m singling out date and time, because they are very useful in a data warehousing context. A couple of reasons:
Overall, having separate date and time columns expresses your intent better, in my opinion. What do you think? Let me know in the comments!
I’m doing a little series on some of the nice features/capabilities in Snowflake (the cloud data warehouse).…
I recently took and passed the DP-700 exam, which is required for the Microsoft Certified:…
When you create an item in Microsoft Fabric (a notebook, a lakehouse, a warehouse, a…
I recently read the book Agile Data Warehouse Design - Collaborative Dimensional Modeling, from Whiteboard…
You can find the slides for the session Building the €100 data warehouse with the…
I was asked to do a review of the book Microsoft Power BI Performance Best…