Database Design Guidelines For Developers
One of the developers that I work with asked me to write a “brief” (really brief) guide on database design....
2014-04-07 (first published: 2014-04-03)
25,890 reads
One of the developers that I work with asked me to write a “brief” (really brief) guide on database design....
2014-04-07 (first published: 2014-04-03)
25,890 reads
I’m excited to present two different sessions in April at DC SQL Server User Group and at Baltimore SQL Server User Group. I...
2014-04-03
573 reads
Yesterday I passed 300,000 views on the blog. Recently I went over 1,000 comments. My little joke on Tuesday garnered...
2014-04-03
652 reads
As a managed services DBA, I frequently have to clean up after other people's mistakes. (Come to think of it,...
2014-04-03
2,003 reads
The first version of the tool was developed by Amandhally and it can be found in the below path. Thanks...
2014-04-02
552 reads
The first version of the tool was developed by Amandhally and it can be found in the below path. Thanks...
2014-04-02
1,628 reads
After power surge last night, I realized few availability databases (also known as a “database replica”) have an unhealthy data...
2014-04-02
4,473 reads
It’s three days to the first SQL Saturday in Nevada, taking place this Saturday in Las Vegas. I’m looking forward...
2014-04-02
660 reads
I was looking at a product recently and came across a rather unpleasant surprise: the install instructions specified that I...
2014-04-02
3,489 reads
Saw the announcement in the Connector today that the process of selecting the Nominating Committee (which vets applications for the...
2014-04-02
537 reads
By James Serra
(This is the third post in a three-part series on how AI is changing...
Continuing with my takeaways from SQLCon and FabCon Europe in Barcelona, let’s talk about...
By Steve Jones
Next year the PASS Data Community Summit is in DENVER! and London, but Denver...
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...
Comments posted to this topic are about the item Adding Bits I
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