---

Filter by type:

• All
• Articles
• Blog Posts
• QotD Questions

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)

65,071 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,983 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,581 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

10,702 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,212 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,273 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,283 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

815 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

3,118 reads

Lessons Learned from a Poor-performing VIEW

• by Dwain Camps

• DwainCSQL

It is a “common knowledge” among SQL practitioners that VIEWs don’t perform well. Recently during an application’s development I put...

2015-03-20 (first published: 2015-03-12)

8,906 reads

Filter by type:

• All
• Articles
• Blog Posts
• QotD Questions