2006-01-11
1,734 reads
2006-01-11
1,734 reads
2006-01-10
1,150 reads
2006-01-09
1,840 reads
Writing outer joins can be more difficult than it appears at first glance. Steve Jones examines this less often used query technique and brings to light a few places where you can lose data.
2006-01-05
18,685 reads
I'm getting ready to look for a new cell phone and I got lots of suggestions from my editorial on...
2006-01-05
1,538 reads
That's the decision to be made.
Apress contacted me about the update for my book. I wrote 1/2 of the Designing...
2006-01-05
1,510 reads
2006-01-04
1,225 reads
2006-01-03
1,734 reads
2006-01-02
1,062 reads
This is great, another rant from Joel, this time on the state of CS Degrees.
I didn't grow up in the...
2005-12-30
1,643 reads
Recently, in an attempt to thwart leechers (1990s kids will know), I added some...
Once upon a time I had a series about some cool stuff in Snowflake:...
By Steve Jones
“Most overnight successes – in fact any significant successes – take at least 5...
Comments posted to this topic are about the item Why Successful SQL Server Backups...
Comments posted to this topic are about the item Adding Bits II
Comments posted to this topic are about the item An Unlimited Token Budget
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