Can You Hear It Now?
Here is a quick blog to show you something I discovered that I didn’t know existed.
I was on a Skype...
2018-01-31
396 reads
Here is a quick blog to show you something I discovered that I didn’t know existed.
I was on a Skype...
2018-01-31
396 reads
A few weeks ago, I wrote Part 1 and 2 of this series, which was a beginner’s guide to Always...
2018-01-17
791 reads
Awhile back, if you are on Twitter, you can probably recall my ranting about the 949 indexes I was reviewing....
2018-01-10
1,729 reads
In this post we will pick up where we left off in Part 1, if you haven’t read that please...
2017-12-29 (first published: 2017-12-13)
1,761 reads
One of the hardest things you can do as a blogger is to come up with a post topic. Do...
2017-12-20
358 reads
Encryption has always been intriguing to me but seemed like it could be a very complex process to set up....
2017-11-29
1,328 reads
This week is Thanksgiving in the United States, so I thought it fitting to write a quick blog on what...
2017-11-22
416 reads
What is the GO statement and why is it so important to use? When do I have to use it?...
2017-11-15
1,148 reads
I ran across a client the other day that had these Backup and Recovery options set like the picture below...
2017-11-08
887 reads
One of the things I’ve been able to implement to help with performance is changing from Update Statistics Synchronous to...
2017-11-07 (first published: 2017-10-25)
2,049 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