DwainCSQL

The Fastest Way to Combine DATE and TIME Data Types to a DATETIME

• by Dwain Camps

• DwainCSQL

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)

37,566 reads

High Performance T-SQL using Code Patterns

• by Dwain Camps

• DwainCSQL

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,650 reads

The Best Tool for Comparing Whether Two T-SQL Queries Produce Identical Results

• by Dwain Camps

• DwainCSQL

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,564 reads

Excel in T-SQL Part 2 – The Normal Distribution (NORM.DIST) Density Functions

• by Dwain Camps

• DwainCSQL

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,365 reads

Excel in T-SQL Part 1 – HARMEAN, GEOMEAN and FREQUENCY

• by Dwain Camps

• DwainCSQL

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,260 reads

Ruminations on Writing Great T-SQL

• by Dwain Camps

• DwainCSQL

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,204 reads

Stupid T-SQL Tricks – Part 3: A Zodiacal SQL

• by Dwain Camps

• DwainCSQL

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,178 reads

An Even Faster Method of Calculating the Median on a Partitioned Heap

• by Dwain Camps

• DwainCSQL

Back in 2013 I wrote an article kindly accepted for publication on the Simple Talk web site called Calculating the...

2015-04-08

801 reads

An Easter SQL

• by Dwain Camps

• DwainCSQL

Since Easter is nearly upon us, I got to thinking once again about how challenging it is to calculate the...

2015-03-31

2,550 reads

Stupid T-SQL Tricks – Part 2: Retrieving Columns Set to the Current DEFAULT CONSTRAINT Value

• by Dwain Camps

• DwainCSQL

“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