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)
23,062 reads
This article shows different options to use the rounding functions in SQL Server.
2020-04-17 (first published: 2016-09-20)
23,062 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)
10,113 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)
18,827 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)
23,947 reads
2015-11-18 (first published: 2015-10-29)
889 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,693 reads
In a previous blog post we went through how to build a Docker container...
Businesses are drowning in data, but starving for insights. That's where SQL experts swoop...
By Brian Kelley
The bottom line here is this: the idea that a CSP takes care of...
I have joined a new project, where the business uses Azure SQL Hyperscale for...
Dears, Hope this message finds you well I did not see in this foruns...
The below code works for backup files only from local drives. When replaced with...
What are the initial config sizes for the tempdb primary data files, secondary data files, and log files in SQL Server 2022?
See possible answers