Free SQL tuning tool: How’s My Database?
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
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 case you aren’t familiar with #MSIgnite, it’s a huge event where Microsoft debuts all the new shiny software that...
2018-09-24
275 reads
I’ve read a lot of things lately pointing to scalar functions as if they were the devil. In this blog...
2018-09-18 (first published: 2018-09-10)
4,057 reads
For those of you in the Denver area, SQL Saturday is this weekend! I’m speaking and hope to see you...
2018-09-11
233 reads
Hello Louisiana! It’s that time of year again. I’ll be speaking on Saturday August 11th in Baton Rouge with many...
2018-07-27
519 reads
I’m speaking along with many other amazingly talented professionals, including Adam from Guy In A Cube. If you’re in the...
2018-06-19
325 reads
SQL is a stout language and SQL Server has so many features that it’s impossible to be an expert in...
2018-06-01 (first published: 2018-05-25)
5,859 reads
It always seems that when I give a talk on performance there are 100+ people packed in the room but...
2018-05-28
277 reads
Understanding the fundamentals is key for success, with everything you do. These days SQL Server has expanded into much more...
2018-05-24 (first published: 2018-05-16)
5,785 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