Long Live OLE DB!
Back in August of 2011, an announcement from Microsoft started a wave of angst among those who build and support...
2017-11-20
365 reads
Back in August of 2011, an announcement from Microsoft started a wave of angst among those who build and support...
2017-11-20
365 reads
I am delighted to announce that I’ll be delivering my full-day course, Building Better SSIS Packages, at the SQLBits conference...
2017-11-17
370 reads
It’s day 2 of the PASS Summit. Yesterday was a whirlwind of a day, after my early-morning post-Halloween trip to...
2017-11-02
649 reads
It’s the first full day of the 2017 PASS Summit. As I write this, I am somewhere over the panhandle...
2017-11-01
337 reads
Temporal data storage, which was defined in the ANSI SQL:2011 standard, describes an architecture in which relational databases maintain row-level...
2017-10-19 (first published: 2017-10-11)
2,113 reads
The yearly PASS Summit is just around the corner, a little less than six weeks away. For those not familiar...
2017-09-22
356 reads
Is it possible to be an effective data professional without knowing anything about the domain of data you support? I...
2017-09-01
322 reads
One of the more common questions I find in SQL Server SSIS forums is how to split apart a single...
2017-08-22
493 reads
When designing the ETL architecture for new or changing systems, one of the more common needs is to create a...
2017-07-25 (first published: 2017-07-12)
1,340 reads
This year I’ve delivered my full-day Building Better SSIS Packages course a half dozen times across the country, but I...
2017-07-21
342 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