Last week I spoke about a world wary data type for storing dates and times in a single column, with a granularity of three milliseconds,… Read More »Dates and Times in SQL Server: SMALLDATETIME
Last year I ran a series of posts about Database Fundamentals. Over the next few weeks, I will cover the basics of various date and… Read More »Dates and Times in SQL Server: DATETIME
Victoria is on an island off the coast of Vancouver, British Columbia. The island is wisely called Vancouver Island. It is beautiful there, and I… Read More »Speaking at SQLSaturday 725 in Victoria
Phew! There’s a lot to take in with data types, collation, precision, scale, length, and Unicode, and we’re just getting warmed up. This week’s post is over 2,000 words long!
Over the last three weeks, we’ve gone fairly deep into data types, and now we are going to see how they come into play with normalization.
If we go back to the first post in this series, I mentioned normalization, and then apparently I forgot about it in the next two posts. What you didn’t see is that I was talking about it all along.