The Fastest Way to Combine DATE and TIME Data Types to a DATETIME
Recently while working with a table where there were two columns, one a DATE datatype and a second TIME datatype,...
2015-09-08 (first published: 2015-08-28)
47,181 reads
Recently while working with a table where there were two columns, one a DATE datatype and a second TIME datatype,...
2015-09-08 (first published: 2015-08-28)
47,181 reads
What exactly does this mean? We’ve heard of “code patterns” in other programming languages, but what does it mean to...
2015-06-04 (first published: 2015-05-27)
8,780 reads
There is one software tool that should be in every software developer’s tool chest. That is knowledge of the platform...
2015-05-26 (first published: 2015-05-21)
7,566 reads
Today’s blog will be the second in a multi-part series on replicating Excel functions in T-SQL, continuing with Excel’s NORM.DIST...
2015-05-14
9,836 reads
Today’s blog will be the first in a multi-part series on replicating Excel functions in T-SQL, starting with HARMEAN, GEOMEAN...
2015-04-29
2,262 reads
Today we’re going to try to extend some advice that I once heard from SQL MVP Jeff Moden, which I...
2015-05-04 (first published: 2015-04-23)
9,207 reads
Today we’ll learn how you can use T-SQL to calculate your zodiac sign from your birthdate.
“Heeeeeere’s Johnny!” – Ed McMahon introducing...
2015-04-16
1,215 reads
Back in 2013 I wrote an article kindly accepted for publication on the Simple Talk web site called Calculating the...
2015-04-08
804 reads
Since Easter is nearly upon us, I got to thinking once again about how challenging it is to calculate the...
2015-03-31
2,761 reads
“Heeeeeere’s Johnny!” – Ed McMahon introducing Johnny Carson for the Tonight Show
If you’re old enough to remember the Tonight Show hosted...
2015-03-19
734 reads
By Arun Sirpal
Following on from a previous blog post (https://blobeater.blog/2021/01/15/sql-server-linux/) on installing SQL Linux, a common...
By HeyMo0sh
This post is about code which is an online editor you can use with...
By HeyMo0sh
This blog post is about a situation where you are capitalising an argument in...
I've been playing around wiht bcp out the data into csv file but been...
My goal is to have an FCI across 2 nodes with shared storage (node...
Comments posted to this topic are about the item Power Query or SQL Server?...