Alter Table Not Permitted
By David Postlethwaite
At my presentation on SQL Server Management Studio at SQL Saturday in Exeter I promised to write some...
2014-04-10
706 reads
By David Postlethwaite
At my presentation on SQL Server Management Studio at SQL Saturday in Exeter I promised to write some...
2014-04-10
706 reads
By David Postlethwaite
At my presentation on SQL Server Management Studio at SQL Saturday in Exeter I promised to write some...
2014-04-09
712 reads
A couple weeks back was the second SQL Saturday to be held in Exeter. Although I wasn’t speaking this time,...
2014-04-07
579 reads
Get an idea of how to handle the housekeeping tasks associated with backups, like removing old backup and log files.
2014-02-17 (first published: 2011-01-26)
14,779 reads
This post is written by David Postlethwaite
If you are using SQL Server 2012 you will probably have noticed that the...
2014-01-13
22,907 reads
If you are thinking of upgrading to SQL Server 2012 in the near future then why not join me in...
2013-12-09
534 reads
I’m writing this blog post to simply to vent some frustration. I live in Wales’ third largest city, Newport and...
2013-12-06
936 reads
I’m just testng out my new laptop making sure things are working as they should
2013-11-18
488 reads
I’m in New York City this week delivering a SQL Server Virtualization and Consolidation 3 days course for Learning Tree....
2013-10-29
723 reads
A client of mine are looking for a good SQL Server DBA on a permanent basis, the location is flexible...
2013-09-05
717 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