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)
14,675 reads
This article shows different options to use the rounding functions in SQL Server.
2020-04-17 (first published: 2016-09-20)
14,675 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,341 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,374 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,432 reads
2015-11-18 (first published: 2015-10-29)
758 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
By Steve Jones
This series looks at the Advent of Code challenges. I started the Advent of...
By Kevin3NF
Welcome back to my Server Review Essentials for Accidental and Junior DBAs series. Last...
Jon Schwabish over at PolicyViz has created great initiative called the One Chart at...
Hi all, We have 2 DMV's: sys.dm_db_index_usage_stats sys.dm_exec_procedure_stats And they don't look they can...
This is kinda hard to explain, maybe I can make sense of it. So...
Dear friends, Please, could you give me some ideas, how to implement SELECT count(*)...