Instant File Initialisation
I have been reading up on instant file initialization and I have read a couple of good blog posts by...
2010-01-21
1,452 reads
I have been reading up on instant file initialization and I have read a couple of good blog posts by...
2010-01-21
1,452 reads
We had a request from a developer who wanted to access data from a source database and another database on...
2010-01-20
1,038 reads
SQL Server 2008 R2 now has a release date...May 2010.
Check out the microsoft site for more details...link to follow
2010-01-20
561 reads
I didn’t know this bit Resource Governor in SQL Server 2008 is only available in Enterprise edition
2010-01-20
1,096 reads
I have just put together the January newsletter for www.gre-sqlserver-solutions.com and scheduled it to run Sunday night/Monday morning. It is...
2010-01-16
710 reads
The locks configuration option for SQL Server controls the number of locks available in SQL Server. You can view this...
2010-01-11
756 reads
For reasons beyond the scope of this post I have an environment where I have Windows 2003 R2 64 bit...
2010-01-11
767 reads
I'm having a day off tomorrow, got some nice things planned including a trip to the beach with the puppies....
2009-12-10
500 reads
Well my theory on posting every week has been tested to the limit somewhat and I didn’t get anything written...
2009-12-08
455 reads
Well I said that I would try to post regularly and seeing as its Sunday and I haven’t posted for...
2009-11-29
602 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