Done or Not Done
One of the things I hear a lot relating to work big and small is that it is “almost done”,...
2012-03-12
589 reads
One of the things I hear a lot relating to work big and small is that it is “almost done”,...
2012-03-12
589 reads
It’s surprisingly easy to set up the new AlwaysOn features. I’ve done it on VMs running on my laptop, from...
2012-03-14 (first published: 2012-03-12)
3,174 reads
While writing my last post on cleaning up old maintenance plans, I was reminded of something I heard in a...
2012-03-12
2,592 reads
On many forums I have found a very basic yet important query - “How can I know when was my Stored...
2012-03-12
21,950 reads
This is something I trip over every now and then on systems we inherit from our clients, and I thought...
2012-03-12
696 reads
As you probably know by now SQL Server 2012 was launched last week, Microsoft had an online launch event that...
2012-03-12
3,495 reads
I was recently asked about synchronizing a Merge pull subscription in SQL Server Express using RMO, the lack of a...
2012-03-13 (first published: 2012-03-12)
4,347 reads
Here’s a story from a recent meeting. We were discussing some problems and the team was talking through some options...
2012-03-12
804 reads
When log records remain active for a long time – truncation can be delayed. The delays can cause the transaction logs...
2012-03-12
1,292 reads
This month, the #meme15 post will fall on March 15th, often referred to as the Ides of March. This date...
2012-03-11
667 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