Terry-bites
A new technology could be a boon for database servers, dramatically increasing the amount of memory available for SQL Server.
2008-03-05
123 reads
A new technology could be a boon for database servers, dramatically increasing the amount of memory available for SQL Server.
2008-03-05
123 reads
SQL Server 2008 sets a TPC record. And it hasn't even been released. This editorial was originally published on Mar 4, 2008. It is being rerun as Steve is on vacation.
2008-03-04
180 reads
Anyone who inherits a database application dreads poorly laid-out SQL code. Development teams loathe it. Putting it right would be easier, if there was a common, agreed, standard in place, so why the difficulty?
2008-03-03
262 reads
How important is disk encryption to you? Do you think about all those replicated or copied databases on laptops? Let us know. This editorial was originally published on Feb 28, 2008. It is being re-run as Steve is on holiday.
2008-02-29
136 reads
Steve Jones takes a look at the world of energy news and a few projects out at the ranch.
2008-02-28
86 reads
SQL Server 2008 launches today and there's are additional events all across the country coming up.
2008-02-27
87 reads
2008-02-25
37 reads
Do you know how to suggest improvements or features for SQL Server? Or report bugs? You use Connect, but it needs some work before it will really help the product.
2008-02-25
88 reads
This Friday Steve Jones asks about capital at work and does it affect the way you do business.
2008-02-22
52 reads
2008-02-21
189 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...
Jl. Gajah Mada No.203 205, RW.207, Benua Melayu Darat, Kec. Pontianak Sel., Kota Pontianak,...
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
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