Banker’s Rounding. What is it good for?
An in depth look at the implications of using Banker's Rounding.
2020-06-15
6,407 reads
round
Round Natural Numbers to the nearest Power of 10
An ITVF function that rounds a number to the nearest Power of 10
2017-05-15 (first published: 2017-05-05)
263 reads
Blogs
When do Statistics get updated?
Statistics objects are important for allowing the SQL Server Optimizer to make good estimates...
Power BI: Making Date & Time Keys
By DataOnWheels
Saving the Day from Delay Part 2 Creating DateKey and TimeKey columns can be...
Daily Coping 18 Jan 2021
By Steve Jones
I started to add a daily coping tip to the SQLServerCentral newsletter and to...
Forums
Intermittent "nesting level exceeded" error
We're having a very peculiar problem with the "Maximum stored procedure, function, trigger, or...
Nested loop/HashJoin and left/right/full join
1. What is the difference among nested loop?hash join and merge join? 2. what...
Ask SSC