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)
21,218 reads
Luis Cazares
Using Code Snippets in SSMS
Snippets will allow you to code faster by inserting chunks of code with few key strokes.
2018-08-17 (first published: 2016-04-07)
9,466 reads
Wildcard Searches
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,545 reads
Introducing the Set-based Loop
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,490 reads
2015-11-18 (first published: 2015-10-29)
814 reads
Calculating Working Hours
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,674 reads
Blogs
Create and Verify Microsoft Fabric Capacity
From June 1, 2023, Microsoft Fabric (preview) capacities are available via the Azure portal....
What is Always Encrypted and how does it work?
Always Encrypted was a new encryption feature added to SQL Server with the 2016...
Power BI – Empowering Users to Disable Tooltips
By DataOnWheels
Let’s set the scene. You’ve built a wonderful, useful, and descriptive report for your...
Forums
M & C CONSTRUCTION SERVICES @0810757135 IN JOHANNESBURG,TEMBISA,SOWETO,ALEXANDRA
M & C Construction Services +27810757135 has been providing construction services to a long...
Efficient Airport Transfer in Mauritius - Reach Your Destination with Ease!
Make your arrival in Mauritius hassle-free with our efficient airport transfer service. Our experienced...
how to determine if we can delete the index can be removed
In SQL Server database, there is a table InventDim with two indexes: Idx1 with...
Ask SSC