2024-12-18
1,403 reads
2024-12-18
1,403 reads
2024-12-16
1,784 reads
2024-12-09
639 reads
2024-12-06
647 reads
Learn how to create a moving average in SQL Server using older and less performant T-SQL and a modern way using windowing functions.
2024-12-06
2024-12-04
658 reads
2024-12-03 (first published: 2024-12-02)
702 reads
This article looks at how to use SQL IS NULL and SQL IS NOT NULL operations in SQL Server along with use cases and working with NULL values.
2024-12-02
2024-11-29
533 reads
2024-11-22
503 reads
Once upon a time I had a series about some cool stuff in Snowflake:...
By Steve Jones
“Most overnight successes – in fact any significant successes – take at least 5...
Comments posted to this topic are about the item Why Successful SQL Server Backups...
Comments posted to this topic are about the item Adding Bits II
Comments posted to this topic are about the item An Unlimited Token Budget
I have a table, dbo.bittest, where I am testing an application response. This has this structure:
CREATE TABLE [dbo].[BitTest] ( [insertdate] [datetime] NULL CONSTRAINT [DF__BitTest__insertd__300F11AC] DEFAULT (getdate()), [a] [bit] NULL ) ON [PRIMARY] GOMy application runs this code:
INSERT dbo.BitTest
(
insertdate,
a
)
VALUES
(DEFAULT, true)
GO
See possible answers