2005-07-13
1,275 reads
2005-07-13
1,275 reads
2005-07-12
1,929 reads
When I started working at JD Edwards, I was a corporate administrator
on the windows network. Since the DBAs were a...
2005-07-12
1,555 reads
2005-07-11
1,304 reads
As Phill posts in his blog, we've had a couple interesting threads in the forums where the respect and tolerance...
2005-07-11
1,463 reads
2005-07-08
1,462 reads
I got a note that someone thought they shouldn't have to register on
the site and get a newsletter to read...
2005-07-07
1,397 reads
When I wrote the editorial for today on A Humbling Experience,
I was sure that it would generate a bunch of...
2005-07-07
1,524 reads
Two in a month? Steve Jones brings us another mistake made by a DBA in SQL Server. Everyone makes them and we may not like to admit to them, everyone that we print hopefully helps a few other SQL Server DBAs avoid that particular mistake. This one looks at the dangers of sorting by aliases.
2005-07-06
13,523 reads
Andy and I had an interesting question on this today. He's trying to
hire a DBA and he had his first...
2005-07-05
1,601 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