Last time we looked at adding or subtracting date parts using the DATEADD() T-SQL system function. This week we see how to calculate the difference… Read More »Dates and Times in SQL Server: DATEDIFF() and DATEDIFF_BIG()
We are now in the home stretch of the long-running series about dates and times in SQL Server and Azure SQL Database. This week we… Read More »Dates and Times in SQL Server: DATEADD()
SQL Server 2019 Preview (CTP 2.0) introduced a long-awaited improvement to an error message that’s been around in SQL Server for many years, but was… Read More »String or binary data would be truncated: get the full picture in SQL Server 2017
Fellow Canadian Doran Douglas brought this issue to my attention recently, and I wanted to share it with you as well. Let’s say you have… Read More »Bulk insert issue with UTF-8 fixed-width file format
Continuing the series on dates and times in SQL Server and Azure SQL Database, this week we look at the hint AT TIME ZONE. In… Read More »Dates and Times in SQL Server: AT TIME ZONE
Content warning: This is the second (and final) rebuttal essay about why someone is wrong on the Internet. It is no doubt biased. It might… Read More »A software architect replaces a relational database with a relational database
Content warning: This is the first of two rebuttal essays, about why someone is wrong on the Internet. It is no doubt biased. It might… Read More »Relational databases aren’t the problem
A shorter post this week, but an important one. Last week, Erik Darling commented on my post saying that we shouldn’t use SELECT *, which… Read More »Why you should not use SELECT *
Recently Brent Ozar posted a link to the PostgreSQL “Don’t do this” page, which I am shamelessly reproducing below, re-tailored for a SQL Server audience.… Read More »Don’t do these things in SQL Server
Relational database management systems (RDBMS) like SQL Server and Azure SQL Database are very good at managing normalized data. Efficient storage and retrieval of data… Read More »Performance as a feature, software developer edition
Last time we looked at DATEPART(). This post is all about the DATENAME() function. So many similarities There are many similarities between DATEPART and DATENAME.… Read More »Dates and Times in SQL Server: DATENAME()
In my previous posts in this series we’ve seen reference to Transact-SQL (T-SQL) functions that are used to get the specific part of a date… Read More »Dates and Times in SQL Server: DATEPART()
I was minding my own business innocently reading a blog post by Erik Darling, when this tip smacked me in the proverbial forehead. I even… Read More »T-SQL aside: replace PRINT with RAISERROR
Recently I wrote a post about date and time functions you should never use, which contained an opinion I’ve expressed previously that some people have… Read More »Dates and Times in SQL Server: the problem with DATETIME
Previously we looked at four built-in functions to get the current date and time in SQL Server and Azure SQL Database using Transact-SQL (T-SQL). We… Read More »Dates and Times in SQL Server: more functions you should never use