It occurred to me that we haven’t covered the TIMESTAMP data type in this series about dates and times. TIMESTAMP is the Windows Millennium Edition… Read More »Dates and Times in SQL Server: What about TIMESTAMP?
We have come on quite a journey so far. SQL Server and Azure SQL Database provide date and time data types to help you design… Read More »Dates and Times in SQL Server: T-SQL functions to get the current date and time
This post continues our look at date and time data types in SQL Server. SQL Server 2008 introduced new data types to handle dates and… Read More »Dates and Times in SQL Server: DATETIMEOFFSET
This post continues our look at date and time data types in SQL Server. SQL Server 2008 introduced new data types to handle dates and… Read More »Dates and Times in SQL Server: DATETIME2
This post continues our look at date and time data types in SQL Server. SQL Server 2008 introduced new data types to handle dates and… Read More »Dates and Times in SQL Server: TIME
This post continues our look at date and time data types in SQL Server. SQL Server 2008 introduced new data types to handle dates and… Read More »Dates and Times in SQL Server: DATE
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
Nested views are bad. Let’s get that out of the way. What is a nested view anyway? Imagine that you have a SELECT statement you… Read More »Why nested views are bad
(Last edited on 9 January 2020) Note: This was originally written for the book SQL Server 2017 Administration Inside Out, but did not meet the… Read More »Introducing Azure Data Studio
For the last five months or so, I have been helping some really smart people put words on paper, both the physical and electronic kind,… Read More »SQL Server 2017 Administration Inside Out
In the #sqlhelp Slack channel on the SQL Server Community Slack workspace last month, Jemma Hooper asked: When trying to CAST or CONVERT a datetime2… Read More »Why is a value in DATETIME2 8 bytes, but in BINARY it is 9 bytes?
Last week we looked at ACID compliance. This week we dive a little deeper into the Isolation portion, and what it all means. Isolation levels… Read More »Locks, Blocks, and Isolation Levels
Today’s public service announcement is a reminder to be wary of date formatting in SQL Server. On a recent mailing list discussion, one person demonstrated… Read More »Be Wary of Date Formatting in T-SQL
We can easily spend tens of thousands of dollars on core licences for SQL Server, and then we go and install the product on an… Read More »Balanced Power Saving T-SQL script