2007-07-10
1,039 reads
2007-07-10
1,039 reads
Next Tuesday, support for SQL Server 2000 servers on Service Pack 3a ends, so be sure you are moving to SP4.
2007-07-05
3,426 reads
Congratulations to two new members of the SQLServerCentral.com 3000 club: Jeff Moden and Noeld.
2007-07-03
1,446 reads
It's coming to Denver in September and there's still time to save. And attend the SQLServerCentral.com Reception.
2007-06-20
1,029 reads
2007-05-23
3,529 reads
Longtime author here, Michael Coles, has written a new book on SQL Server 2005 Programming and has sent us a sample chapter on SQLCLR programming. Download the chapter and source code and grab this great book from your favorite bookseller.
2007-05-03
4,297 reads
If you haven't seen it, I highly recommend all SQL Server administrators check out the post from Microsoft detailing the post-SP2 fixes.
2007-04-16
3,970 reads
We're opening the newsletter up to advertising for everyone. Get the news here.
2007-04-11
1,205 reads
SQLMaestro has a new version and is offering a discount to SQLServerCentral.com members.
2007-03-22
2,069 reads
2007-03-21
1,105 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