2020-09-22
900 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
17,962 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,794 reads
Performing a Right and Comprehensive Age Calculation
Age calculation based on the right method used in real life.
2017-03-28
4,166 reads
2017-03-09 (first published: 2017-02-16)
1,933 reads
2016-11-16
1,254 reads
2013-06-24
2,878 reads
2013-05-24
2,354 reads
2013-04-30
2,253 reads
2008-09-04
5,236 reads
Blogs
Choosing to not drive the Tesla
By Steve Jones
I started a short thread on Twitter/X and Bluesky recently after leaving the Tesla...
Advice I Like: Transactions and Relationships
By Steve Jones
Life gets better as you replace transactions with relationships. – from Excellent Advice for...
Free PostgreSQL Performance Monitoring with pgNow
I’ve been putting together a new PostgreSQL session called “Performance Monitoring for the Absolute...
Forums
Understanding Bit Manipulation Functions: BIT_COUNT, GET_BIT, and SET_BIT in SQL Server 2022
Comments posted to this topic are about the item Understanding Bit Manipulation Functions: BIT_COUNT,...
Mixed Backups
Comments posted to this topic are about the item Mixed Backups
Or condition in where clause works differently in MS SQL comparing with Sybase
Hello, I ran below statements in MS SQL, and got error, but fine in...
Question of the Day
Mixed Backups
I have a complex database with a few filegroups and files. Can I run a backup command like this? (assume file/filegroup names are valid).
BACKUP DATABASE [complex]
FILE = N'thirdone'
, FILE = N'thirdtwo'
, FILEGROUP = N'second'
TO DISK = N'C:\Program Files\Microsoft SQL Server\MSSQL16.SQL2022\MSSQL\Backup\complex.bak'
WITH NOFORMAT, NOINIT, NAME = N'complex-Full Database Backup', SKIP, NOREWIND, NOUNLOAD, STATS = 10
GO
See possible answers