T-SQL calculations can get tricky at times, and since you often work with multiple rows, it's good to be exact in your data manipulation. New author Lynn Pettis brings us an article about calculating ages.
2009-03-13 (first published: 2008-06-30)
25,983 reads
2008-06-27
5,092 reads
2008-06-23
4,639 reads
This article from new author Peter Kierstead shows us how to implement your own "fuzzy" dedup/merge logic without resorting to RBAR in T-SQL.
2008-06-23
8,013 reads
Searches for actual and potential foreign key columns for a given primary key reference.
2009-10-12 (first published: 2008-06-20)
2,517 reads
2008-06-20
4,353 reads
2008-06-18
4,360 reads
2008-08-08 (first published: 2008-06-16)
927 reads
Discusses the use of the newly introduced APPLY Statement in SQL Server 2005
2009-02-27 (first published: 2008-06-16)
24,982 reads
MAK illustrates the use of Compound Assignment Operator that is introduced in SQL Server 2008.
2008-06-13
1,978 reads
By Steve Jones
dolorblindness – n. the frustration that you’ll never be able to understand another person’s...
By Steve Jones
I had a customer ask about analyzing their Test Data Manager (TDM) usage to...
By Steve Jones
I had an idea for an animated view of a sales tool, and started...
Comments posted to this topic are about the item GPX distance and time analysis...
Comments posted to this topic are about the item The DBA is Dead; Long...
Comments posted to this topic are about the item Changing the AG Listener
In SQL Server 2025, if I want to remove an IP from a listener, what do I do?
See possible answers