Something Cool We Learned Today!
We have many customers, and we work on lots of projects. Each project is different in so many ways: the...
2017-11-16
434 reads
We have many customers, and we work on lots of projects. Each project is different in so many ways: the...
2017-11-16
434 reads
One of the cool new features in SQL Server 2017 (and currently also in public preview in Azure SQL Database)...
2017-11-16
1,018 reads
When I was writing my post Capture the most expensive queries across your SQL Server using Query Store a question crossed...
2017-11-16
662 reads
It’s good to be proactive and one way is to setup alerts and it is no different when using Azure...
2017-11-16
521 reads
I had someone ask me about this the other day. Specifically getting variable data out of a dynamic SQL statement....
2017-11-16
1,508 reads
Ladies and Gentlemen, welcome to the main event of the evening. The SQL Undercover Smackdown Heavy Weight Championship of the...
2017-11-16
2,582 reads
I was in Glasgow this Friday enjoying the fantastic hospitality of the Glasgow SQL User Group@SQLGlasgow and presenting sessions with Andre...
2017-11-16
457 reads
This post is for a specific type of person if you are:
New to source controlAre getting started on your path...
2017-11-16
368 reads
This post is for a specific type of person if you are:
New to source control Are getting started on your path to the continuous delivery nirvana Have been...
2017-11-16
15 reads
This post is for a specific type of person if you are:
New to source control Are getting started on...
2017-11-16
47 reads
This is my late response to T-SQL Tuesday #204. I almost always forget about...
By Steve Jones
I was experimenting with CHOOSE() recently after I was asked a question. In a...
By DesertDBA
I did not expect 27 responses to my T-SQL Tuesday #204 invitation, but it...
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