We Don’t Trust This Data
“Learning to trust is one of life’s most difficult tasks.” – Isaac Watts
As data professionals, there are times when our jobs...
2015-08-19 (first published: 2015-08-14)
2,996 reads
“Learning to trust is one of life’s most difficult tasks.” – Isaac Watts
As data professionals, there are times when our jobs...
2015-08-19 (first published: 2015-08-14)
2,996 reads
Without a doubt, the most versatile data flow tool in the SSIS arsenal is the script component. This control grants...
2015-08-05 (first published: 2015-07-29)
2,910 reads
If you’ve used SSIS for any significant amount of time, you’ve almost certainly run into this roadblock: You need to...
2015-08-03
7,883 reads
The key to successful analysis is to ask enough good questions.
How do you know that you’ve asked enough questions? When...
2015-06-12 (first published: 2015-06-03)
2,117 reads
Earlier this week, I confirmed two full-day seminars I’ll be delivering in conjunction with SQL Saturday events this fall. I’ve...
2015-06-05
699 reads
I’m a fixer. A tinkerer. As a kid, I would take my toys apart just to see how they worked,...
2015-06-01
1,555 reads
During data load or transformation processes, capturing a distinct row number for incoming data can be beneficial for the ETL...
2015-05-26
3,336 reads
Now that the details have been finalized, I can announce that a new SSIS class coming up this fall. My Linchpin...
2015-05-21
604 reads
If you’ve read my blog or attended one of my presentations before, you almost certainly know that I’m a huge...
2015-05-21 (first published: 2015-05-12)
4,376 reads
This is a temporary post that was not deleted. Please delete this manually. (af8cc091-a628-437f-8918-348486ad1d80 – 3bfe001a-32de-4114-a6b4-4005b770f6d7)
The post Temporary Post Used For...
2015-05-20
427 reads
Recently, in an attempt to thwart leechers (1990s kids will know), I added some...
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