TSQL Tuesday Misconceptions in SQL Server
I haven’t written a post for a TSQL Tuesday for a little while and I know that I’m late getting...
2010-10-12
1,081 reads
I haven’t written a post for a TSQL Tuesday for a little while and I know that I’m late getting...
2010-10-12
1,081 reads
I have posted a short note on instant file initialization previously, that post can be found here. The crux of...
2010-09-21
1,743 reads
I posted recently about my run-in with autoclose and my online friend Jorge Segarra (Blog|@SQLCHICKEN) left a great comment on...
2010-09-15
1,642 reads
Someone who I follow on twitter posted a tweet recently with a link to a free eBook on PowerShell. I...
2010-09-10
2,596 reads
This a short post looking at the Dedicated Administrator Connection or DAC for short. In extreme circumstances, when there is...
2010-09-09
8,257 reads
I ran into an issue recently where I had a third party supplied database set to auto close. I couldn't...
2010-09-07
3,004 reads
For my first technical post in a short while I thought I would look at something I have worked on...
2010-08-23
11,051 reads
I haven’t posted on my SQL Server blog for a few weeks, I missed the August T-SQL Tuesday which I’m...
2010-08-14
530 reads
Its been a busy week this week. From troubleshooting several production issues to writing some incremental load SSIS scripts, the...
2010-07-23
522 reads
Well this was going to be replication post, but I have read it, re-written it, read it, re-written and it...
2010-07-20
673 reads
By Steve Jones
semaphorism – n. a conversational hint that you have something personal to say on...
This week I was at PASS Data Community Summit in Seattle, and I attended...
By James Serra
(This is the third post in a three-part series on how AI is changing...
Comments posted to this topic are about the item Pay for Performance, which is...
Comments posted to this topic are about the item Helping an English Student with...
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