How to Avoid Conditional JOINs in T-SQL

Relational databases go out of their way to execute SQL, however bad the crimes against Codd and relational theory within...

07 September 2015 14 min read

Dwain Camps

Software Engineering: Just How Immature is it?

"Facts and Fallacies of Software Engineering" by Robert L. Glass has become a classic of Software Engineering as cherished as...

12 June 2015 19 min read

Dwain Camps

Using the T-SQL PERCENTILE Analytic Functions in SQL Server 2000, 2005 and 2008

Percentiles give meaning to measurements by telling you the percentage of the population being measured who get higher or lower...

18 May 2015 27 min read

Dwain Camps

Time Slots – An Essential Extension to Calendar Tables

After answering many forum entries from developers asking for help with dealing with SQL that involved time intervals and ranges,...

22 April 2015 24 min read

Dwain Camps

Self-maintaining, Contiguous Effective Dates in Temporal Tables

'Temporal' tables contain facts that are valid for a period of time. When they are used for financial information they...

10 March 2015 38 min read

Dwain Camps

Bowled Over by SQL Window Functions

What better way to learn how to construct complex CHECK CONSTRAINTs, use the SQL 2012 window frame capability of the...

26 January 2015 27 min read

Dwain Camps

Archiving Hierarchical, Deleted Transactions Using XML

When you delete a business transaction from the database, there are times when you might want to keep a record...

30 December 2014 18 min read

Dwain Camps

Using Stored Procedures to Provide an Application’s Business-Logic Layer

When faced with a complex business application that had to be delivered with minimum staffing, on-time and within budget, Dwain's...

14 November 2014 44 min read

Dwain Camps

Filling In Missing Values Using the T-SQL Window Frame

Since SQL Server delivered the entire range of window functions, there has been far less justification for using the non-standard...

18 September 2014 18 min read

Dwain Camps

Calculating and Verifying Check Digits in T-SQL

A lot of numbers that we use everyday such as Bank Card numbers, Identification numbers, and ISBN codes, have check...

11 July 2014 24 min read

Dwain Camps

Writing Outstanding Proposals

Oftentimes you will be forced to learn how to write proposals without a whole lot of help. You can learn,...

20 May 2014 16 min read

Dwain Camps

The Performance of Traversing a SQL Hierarchy

Dwain Camps show that, depending on the size and characteristics of some hierarchical data, six different methods of traversal can...

28 April 2014 16 min read

Dwain Camps

High Performance Relational Division in SQL Server

Relational division is used in SQL to select rows that conform to a number of different criteria. It is a...

24 March 2014 28 min read

Dwain Camps

Calculating Gaps Between Overlapping Time Intervals in SQL

There are a number of real-life reporting tasks in SQL that require a 'gaps and islands' analysis. There are a...

14 February 2014 21 min read

Dwain Camps

The Performance of the T-SQL Window Functions

Window Functions in SQL greatly simplify a whole range of financial and statistical aggregations on sets of data. Because there...

17 January 2014 16 min read

Dwain Camps

Calculating the Median Value within a Partitioned Set Using T-SQL

It is ironic that one of the most essential of statistical aggregations, the median, has been so difficult in the...

17 December 2013 12 min read

Dwain Camps

Fundamentals of Vendor Management

Creating and maintaining mutually beneficial relationships with external vendors is one of the pillars of good project management. Dwain Camps...

28 October 2013 15 min read

Dwain Camps

Calculating Values within a Rolling Window in Transact SQL

Before the SQL Window functions were implemented, it was tricky to calculate rolling totals or moving averages efficiently in SQL...

17 October 2013 19 min read

Dwain Camps

The Proposals Conundrum

When you work for a small software development (or any services) company, one of the major challenges is to make...

19 September 2013 11 min read

Dwain Camps

Condensing a Delimited List of Integers in SQL Server

In real-world applications, it often makes sense to show denormalized data such as delimited lists within the application's user interface....

28 August 2013 16 min read

Register for Simple Talk

Dwain Camps

Dwain Camps's content

How to Avoid Conditional JOINs in T-SQL

Software Engineering: Just How Immature is it?

Using the T-SQL PERCENTILE Analytic Functions in SQL Server 2000, 2005 and 2008

Time Slots – An Essential Extension to Calendar Tables

Self-maintaining, Contiguous Effective Dates in Temporal Tables

Bowled Over by SQL Window Functions

Archiving Hierarchical, Deleted Transactions Using XML

Using Stored Procedures to Provide an Application’s Business-Logic Layer

Filling In Missing Values Using the T-SQL Window Frame

Calculating and Verifying Check Digits in T-SQL

Writing Outstanding Proposals

The Performance of Traversing a SQL Hierarchy

High Performance Relational Division in SQL Server

Calculating Gaps Between Overlapping Time Intervals in SQL

The Performance of the T-SQL Window Functions

Calculating the Median Value within a Partitioned Set Using T-SQL

Fundamentals of Vendor Management

Calculating Values within a Rolling Window in Transact SQL

The Proposals Conundrum

Condensing a Delimited List of Integers in SQL Server