Capture the Flag – The Trace Flag
Many people work in a tightly controlled environment. Every change requires a change control form and approval to make a...
2018-12-25 (first published: 2018-12-06)
2,536 reads
Many people work in a tightly controlled environment. Every change requires a change control form and approval to make a...
2018-12-25 (first published: 2018-12-06)
2,536 reads
In coming weekend I will be speaking at SQL Saturday in Ljubljana, Slovenia. I’m extra happy because I do it...
2018-12-06
241 reads
On Monday I wrote about journaling and while any pen will do, I think having a pen dedicated (as it...
2018-12-06
266 reads
You know that old SQL Server you’ve left running the last 5 years and had numerous databases dropped and restored...
2018-12-06
711 reads
I would like to share a link to my Azure SQL Database Stairway series hosted over at SQLServerCentral. As stated...
2018-12-06
470 reads
This post is about some queries and scripts that I use in my daily work on SQL Server. Some of them are self-explanatory, i.e. the name of the query/script...
2018-12-05
108 reads
This post is about some queries and scripts that I use in my daily work on SQL Server. Some of them are self-explanatory, i.e. the name of the query/script...
2018-12-05
488 reads
This post is about some queries and scripts that I use in my daily work on SQL Server. Some of...
2018-12-26 (first published: 2018-12-05)
7,372 reads
A T-SQL approach to solving the 2018 "Advent of Code" programming challenge. This solution includes a recursive case-sensitive string replacement.
The post Advent of Code 2018 – Day 5 (Alchemical...
2018-12-05
48 reads
Advent of Code 2018 – Day 5
As I explained in a recent post, I’m participating in this year’s Advent of Code...
2018-12-05
872 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