Speaking at SQL Saturday Victoria
I am so excited to announce that I have been selected to speak at SQL Saturday Victoria on Saturday, March 16, 2019. I will be presenting my What is...
2019-02-13
30 reads
I am so excited to announce that I have been selected to speak at SQL Saturday Victoria on Saturday, March 16, 2019. I will be presenting my What is...
2019-02-13
30 reads
I am so excited to announce that I have been selected to speak at SQL Saturday Victoria on Saturday, March...
2019-02-13
126 reads
It’s taken longer than I thought it may and I’ve run into several problems along the way but had a...
2019-02-13
234 reads
Before you read too far, this is going to be a deeply personal post.Where do I begin? As many of...
2019-02-13
156 reads
In my last post, I started out with a new SCA project, getting a connection to my database up and...
2019-03-08 (first published: 2019-02-13)
2,699 reads
A few months ago I suggested that the following settings should be the default for most SQL Server instances: Set...
2019-02-13
204 reads
I am very excited and lucky to be speaking at my very first international conference, SQLBits. SQLBits, the largest SQL...
2019-02-13
194 reads
In Partitioning 1, my query searched through all 1-12 partitions. Let’s see if we can reduce that number.
Adding the partitioning...
2019-02-13
1,734 reads
Checking out the transaction log in Azure SQL Database. If you are curious like me, you will want to know...
2019-02-13
197 reads
I recently wanted a script to tell me that for every database on a given server
What levels of backups I...
2019-02-28 (first published: 2019-02-13)
3,348 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