The Birthday Problem – with T-SQL and R
When I was on SQLCruise recently – Buck Woody (b|t) made a interesting statement – that in a room of 23 people,...
2017-05-03 (first published: 2017-04-24)
1,947 reads
When I was on SQLCruise recently – Buck Woody (b|t) made a interesting statement – that in a room of 23 people,...
2017-05-03 (first published: 2017-04-24)
1,947 reads
In the previous post I demonstrated the use of binomial formula to calculate probabilities of events occurring in certain situations....
2017-04-17
1,479 reads
In a previous post I explained the basics of probability. In this post I will use some of those principles to...
2017-04-17 (first published: 2017-04-10)
1,944 reads
In this post am going to explain (in highly simplified terms) two very important statistical concepts – the sampling distribution and central...
2017-04-03
720 reads
In this post am going to introduce into some of the basic principles of probability – and use it in other posts...
2017-03-30 (first published: 2017-03-20)
4,535 reads
This month’s TSQL Tuesday is organized by Kennie T Pontoppidan(t) – the topic is ‘Daily Database WTF‘ – or a horror story...
2017-03-12
462 reads
This week’s blog post is rather simple. One of the main characteristics of a data set involving classes, or discrete...
2017-03-20 (first published: 2017-03-06)
8,557 reads
I am resuming technical blogging after a gap of nearly a month. I will continue to blog my re learning...
2017-03-02 (first published: 2017-02-27)
2,587 reads
As some readers may know, I am a regular attendee on SQL Cruise s for 8 years now. SQLCruise is...
2017-02-19
635 reads
I have always maintained a private bucket list. I have not had the courage to actually put it down in...
2017-01-13 (first published: 2017-01-02)
1,932 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