Time Off, Recharge, Rethink
Some of you may have noticed that I haven’t posted for a while. The 12th May was the date of...
2010-05-25
636 reads
Some of you may have noticed that I haven’t posted for a while. The 12th May was the date of...
2010-05-25
636 reads
Ever come across a scary error in the SQL Server log when running CHECKDB against your databases. The error looks...
2010-05-12
530 reads
I like to run integrity checks against my databases very regularly, sometimes daily if I can get away with it....
2010-05-05
2,187 reads
My first post in my replication series gave a brief overview of replication, before I dive into setting up and...
2010-05-04
7,432 reads
How do you tell when your SQL instance was lasted restarted?
I was reading a post by Joe Webb (Blog|Twitter) about...
2010-04-29
6,189 reads
The purpose of this short post is to demonstrate a simple method of generating an accurate SQL Server connection string...
2010-04-28
13,607 reads
For my next series of blog posts I intend to document and write about SQL Server replication. This is a...
2010-04-27
2,511 reads
Microsoft held a big teleconference today, which I unfortunately got called away from a minutes into it. The call was...
2010-04-21
599 reads
For the last two years or so, in one capacity or another I have been running SQL Server in virtual...
2010-04-21
670 reads
This is a very short post
I’m probably very late to this party but…SQL Server 2008 R2 is scheduled for release...
2010-04-15
520 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