SQLBits XI recently announced
When I saw an email from SQLBits announcing SQLBits XI in East Midlands in my inbox this morning, it simply...
2012-11-14
838 reads
When I saw an email from SQLBits announcing SQLBits XI in East Midlands in my inbox this morning, it simply...
2012-11-14
838 reads
Over the weekend I received an email supposedly from Microsoft Live wanting me to verify my account and provided a...
2012-10-26 (first published: 2012-10-24)
1,669 reads
I’ve been aware of this clause in TSQL for a long time, but I’ve never really used it. Mainly because...
2012-09-26
1,110 reads
I was helping out on the forums the other day with a user who had stumbled across the quirk of...
2012-08-28
6,918 reads
SQL jobs are great as the SQL agent job engine allows for very granular control over jobs that are created...
2012-08-23
2,643 reads
Not another comma separated string blog post I hear you say! I know that this topic has probably been done...
2012-07-13
6,851 reads
I haven’t been able to do much XQuery development recently which is a shame as I love developing with the...
2012-07-09
4,555 reads
Ok, so this is not strictly a post about SQL itself (and it's about a fairly old OS), but I...
2012-06-25
2,744 reads
I was helping out a user on the forums the other day where they were asking questions about shredding an...
2012-05-22 (first published: 2012-05-16)
5,401 reads
I regularly deploy SQL Server to new Windows Server 2008 hosts and one thing that I find quite a chore...
2012-05-10
3,976 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