Calculating Elapsed Times (SQL Spackle)
Calculating elapsed time between time values can be an interesting problem that is easily solved even when data anomalies are present.
2019-04-05 (first published: 2013-09-26)
12,892 reads
Calculating elapsed time between time values can be an interesting problem that is easily solved even when data anomalies are present.
2019-04-05 (first published: 2013-09-26)
12,892 reads
The SQL MERGE statement offers convenience, safety and elegance, but how does it perform compared to other methods?
2017-02-03 (first published: 2013-10-28)
89,207 reads
If you've ever wondered if you can do better than an INDEX SCAN when you do a LIKE "%string%" search, read on...
2016-02-12 (first published: 2014-04-07)
42,599 reads
Learn how to develop and test a template for logging and error handling in a multi-step SQL stored procedure
2015-09-18 (first published: 2014-01-20)
24,373 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)
50,741 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,833 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,567 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
10,093 reads
Did you know that scalar-valued, user-defined functions can be used in DEFAULT/CHECK CONSTRAINTs and computed columns? Learn about it...
2015-05-12
6,719 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
By Steve Jones
It’s actually my month to host T-SQL Tuesday, and I came up with the...
By Steve Jones
I started to add a daily coping tip to the SQLServerCentral newsletter and to...
Windows Subsystem for Linux is probably my favourite feature of Windows 10. It gives...
for installation sql server standard edition for instance id should I put server name?...
Hi all! I want to create a stored procedure that returns a result based...
Potentially dumb question. There is 1 x ldf & 1 x mdf for DB1. ...