SQL Server 2014 CTP1 Released
It is here! the first CTP for SQL 2014 is available for download from the Technet evaluation centre... Just downloaded...
2013-06-25
607 reads
It is here! the first CTP for SQL 2014 is available for download from the Technet evaluation centre... Just downloaded...
2013-06-25
607 reads
I’ve been using the backup to azure feature for a short while now and I really like it. Shows I...
2013-06-01
885 reads
I’ve been using the backup to Azure feature that shipped with SQL2012 SP1 CU2 and generally it works really well,...
2013-05-21
5,961 reads
It has been a little while since I posted something and I’ve been meaning to finish off this blog for...
2013-04-24
1,945 reads
It’s been a little while since I wrote a blog post on my favourite subject but this is from a...
2013-03-20 (first published: 2013-03-13)
5,337 reads
The agenda for the SQLBits event in May was announced today and after a quick look earlier today, it looks...
2013-02-13
640 reads
There is a new CU update for SQL 2012 SP1 and I noticed a very interesting new feature described in...
2013-01-25
1,536 reads
I bet you are half wondering what is the first? Well that would be the birth of my second child...
2013-01-17
804 reads
Sometimes we need to retrieve a list distinct values from within an xml instance or even distinct nodes and this...
2012-12-20 (first published: 2012-12-13)
19,574 reads
I read a blog a few months ago by Ramkumar Gopal (blog) in which he had setup a Facebook page...
2012-11-22
703 reads
By Steve Jones
“Most overnight successes – in fact any significant successes – take at least 5...
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...
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