Advent of Code 2018 – Day 4 (Repose Record)
Advent of Code 2018 – Day 4
As I explained in a recent post, I’m participating in this year’s Advent of Code...
2018-12-25 (first published: 2018-12-05)
2,460 reads
Advent of Code 2018 – Day 4
As I explained in a recent post, I’m participating in this year’s Advent of Code...
2018-12-25 (first published: 2018-12-05)
2,460 reads
Another post for me that is simple and hopefully serves as an example for people trying to get blogging as...
2018-12-27 (first published: 2018-12-05)
2,505 reads
My friend Michael J. Swart has a rule of thumb he calls Swart’s Ten Percent Rule. If you’re using over...
2018-12-05
227 reads
A co-worker showed me a really neat trick the other day. We deal with a lot of connection problems and...
2018-12-05
7,495 reads
Performance tuning in SQL Server is one of the main jobs a DBA has. Starting with SQL Sever 2016 a...
2018-12-05
1,259 reads
Data exploration and documentation can be cumbersome, classifying data can be one of those tedious but necessary things. With the...
2018-12-05
950 reads
What’s the deal with logins and availability groups?
I’m sure that we all, when creating a login that accesses a database...
2018-12-26 (first published: 2018-12-05)
2,304 reads
Yesterday I posted about journaling with my goal being to track the time I spend on SQLOrlando (I’ll exclude time...
2018-12-24 (first published: 2018-12-05)
1,646 reads
Many of you (including me) wonder about it. Namely: Is it possible to move my ETL process from SSIS to...
2018-12-05
240 reads
Advent of Code 2018 – Day 2
As I explained in yesterday’s post, I’m participating in this year’s Advent of Code challenge,...
2018-12-21 (first published: 2018-12-04)
1,860 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