Last Week Reading (2020-02-02)
Hello. We have a beautiful date today, haven’t we? And LWR posts are coming back after a long one-month break. Press Columnstore Indexes – part 130 (“Columnstore Indexes on...
2020-02-02
10 reads
Hello. We have a beautiful date today, haven’t we? And LWR posts are coming back after a long one-month break. Press Columnstore Indexes – part 130 (“Columnstore Indexes on...
2020-02-02
10 reads
Introduction Uwe Ricken is working with IT systems since the 90’s. He found the way to the technology of Microsoft SQL Server with the assignment for the development of...
2020-01-31
15 reads
Introduction Uwe Ricken is working with IT systems since the 90’s. He found the way to the technology of Microsoft SQL Server with the assignment for the development of...
2020-01-31
19 reads
Good morning girls and boys, ladies and gentlemen, in the new year 2020! I recently thought that we had started a new decade. But that’s not true. The new...
2020-01-10
24 reads
Good morning girls and boys, ladies and gentlemen, in the new year 2020! I recently thought that we had started a new decade. But that’s not true. The new...
2020-01-10
20 reads
Hello boys & girls! This is the last post in “Last Week Reading” series in this decade. Can you believe that? Have you had a good Christmas time? Have...
2019-12-30
29 reads
Hello boys & girls! This is the last post in “Last Week Reading” series in this decade. Can you believe that? Have you had a good Christmas time? Have...
2019-12-30
21 reads
Hello. It’s been a while since the last post of this series appeared. I will do my best to keep this going. So, without unnecessary introductions – let’s move...
2019-12-22
25 reads
Hello. It’s been a while since the last post of this series appeared. I will do my best to keep this going. So, without unnecessary introductions – let’s move...
2019-12-22
18 reads
Hello, data folks! I have published several articles about databases and their maintenance in SSDT project on the blog. One of the posts explained step by step how to...
2019-12-12
51 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