2020-09-22
906 reads
Sergiy Floka
Banker’s Rounding. What is it good for?
An in depth look at the implications of using Banker's Rounding.
2020-06-15
18,544 reads
Performing a Right and Comprehensive Age Calculation Part 2
Age Calculation gets implemented as an Inline table Valued function with a parameter defining which date parts must be counted.
2017-03-30
1,842 reads
Performing a Right and Comprehensive Age Calculation
Age calculation based on the right method used in real life.
2017-03-28
4,303 reads
2017-03-09 (first published: 2017-02-16)
1,982 reads
2016-11-16
1,259 reads
2013-06-24
2,883 reads
2013-05-24
2,362 reads
2013-04-30
2,260 reads
2008-09-04
5,242 reads
Blogs
Why Optimize CPU for RDS SQL Server is a game changer
One feature that I have been waiting for years! The new announcement around optimize...
Performance tuning KubeVirt for SQL Server
Following on from my last post about Getting Started With KubeVirt & SQL Server,...
T-SQL Tuesday #193 – A Note to Your Past, and a Warning from Your Future
By DesertDBA
I haven’t posted in a while (well, not here at least since I’ve been...
Forums
Change Tracking – Troubleshooting
I have change tracking configured in several databases, in QA and production environments, and...
is there a no code way to limit an ssis extract from excel to the 1st 21 rows?
is there a no code way to limit an ssis extract from excel to...
Pivot but preserve all rows on Aggregate column
Hello Need help in pivoting this data set, the Pivot takes MIN/MAX on a...
Question of the Day
What is the PRODUCT
In SQL Server 2025, what does this return?
CREATE TABLE Numbers ( n INT) GO INSERT dbo.Numbers ( n ) VALUES (1), (2), (3) GO SELECT PRODUCT(n) FROM dbo.NumbersSee possible answers