Back to the future
It’s January 2019 as I write this. I realized that I started on my journey with SQL Server in 1998,...
2019-01-09
244 reads
It’s January 2019 as I write this. I realized that I started on my journey with SQL Server in 1998,...
2019-01-09
244 reads
You can maintain and deploy code easilySource control is a vital part of IT work, since it is used to...
2019-01-09
3,513 reads
Why the heck did we make all our columns varchar? That’s a hypothetical question, please.
But now we have to pay...
2019-01-09
151 reads
I’m always a fan of tools that can make my life easier.
One tool that I’ve recently come across is...
2019-01-09
185 reads
I’ve done a few posts on Clustered and Non-Clustered indexes before, what I’ve not however covered and something that is...
2019-01-09
262 reads
Azure Key Vault is a service which allows you to keep and manage passwords, certificates and other sensitive information securely....
2019-01-09
296 reads
Please Vote for my article "SQL Triggers - An Introduction" on CodeProject.One of my Code Project article on SQL Trigger has been selected as entry in this contest. I...
2019-01-09
37 reads
Please Vote for my article "SQL Triggers - An Introduction" on CodeProject.
One of my Code Project article on SQL Trigger has...
2019-01-09
302 reads
Performance is always a most prioritized task for any DBA and every DBA always prefer to go for a proactive...
2019-01-09
1,567 reads
In my previous post, I outlined the preparations we undertook to migrate a large SQL Server 2008R2 instance to SQL Server 2016. This post details migration day.
Final Prep We...
2019-01-09
27 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