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)
14,558 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)
14,558 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)
115,127 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)
43,617 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)
27,849 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,913 reads
If you've never encountered this quirk of the SQL UPDATE statement, you should take a look and find a simple way around it.
2015-04-06 (first published: 2013-09-09)
26,873 reads
When effective end dates don't align properly with effective start dates for subsequent rows, what are you to do?
2015-03-24
9,707 reads
Triggers in T-SQL have many uses. There are right and wrong ways to write triggers. To learn the difference, read on...
2015-03-17
6,902 reads
Learn how to design, build and test a dynamic search SP in just a few simple but methodical steps.
2015-03-06 (first published: 2013-11-05)
23,270 reads
When undisciplined users access your search forms, you can control their behavior and limit the results they're presented with in various ways.
2014-12-15
4,043 reads
By Steve Jones
I don’t do a lot of work with disabled index, but I learned how...
By Steve Jones
I’m leaving again tomorrow for a trip. This time I head back to Boston...
By Tim Mitchell
Most of us who work with data have, at least a few times, been...
Comments posted to this topic are about the item 7 sept, scheduled book
Comments posted to this topic are about the item 7 sept, schedlued article
Comments posted to this topic are about the item 6 sept, published book
Azure Data Lake Storage Gen 2 is built on ...?
See possible answers