SQL Server Rounding Tips and Tricks
This article shows different options to use the rounding functions in SQL Server.
2020-04-17 (first published: 2016-09-20)
15,897 reads
This article shows different options to use the rounding functions in SQL Server.
2020-04-17 (first published: 2016-09-20)
15,897 reads
Snippets will allow you to code faster by inserting chunks of code with few key strokes.
2018-08-17 (first published: 2016-04-07)
7,594 reads
Using wildcard to find patterns in strings going from the basics to some more complicated conditions.
2017-02-10 (first published: 2015-09-29)
16,711 reads
Set-based programming doesn’t mean “no loops” or a single statement. Finding out the best ways to traverse a full hierarchy.
2016-10-07 (first published: 2015-07-27)
21,724 reads
2015-11-18 (first published: 2015-10-29)
759 reads
Calculating working hours can be painful due to all the variances that they imply. This function will calculate working hours between 2 dates which might include time. There's an option to use a holidays table that will vary in each environment.
2015-10-22 (first published: 2014-05-22)
3,623 reads
System-versioned temporal tables were introduced in SQL Server 2016. They provide information about data...
By Steve Jones
Another post for me that is simple and hopefully serves as an example for...
Next week on Wednesday is the Calgary Data User Group’s second event for 2021,...
Hi all We've got an issue with a linked server to an Access...
I am becoming a little disconcerted by the lack of news about the next...
I have an existing SQL Server 2019 Standard installation that includes SSRS. The setup...