The CLR
The CLR was one of the highly touted additions to SQL Server 2005, and one of the reasons for its long development cycle. Steve Jones comments on why it hasn't been that widely used.
2008-05-13
621 reads
The CLR was one of the highly touted additions to SQL Server 2005, and one of the reasons for its long development cycle. Steve Jones comments on why it hasn't been that widely used.
2008-05-13
621 reads
Steve Jones asks for some opinions on how to approach the new timeframe of software releases.
2008-05-12
207 reads
New technologies often bring with them lots of new data. Steve Jones talks about some changes that we might see with new RFID technology being deployed in some industries.
2008-05-08
91 reads
Microsoft made a sizeable big for Yahoo and Steve Jones talks about one of the more interesting aspects of that bid that didn't receive much press.
2008-05-07
136 reads
As DBAs we should be very detail oriented, but Steve Jones talks about some challenges with keeping up with your tasks and projects and some software that might help.
2008-05-06
214 reads
A look back at the news of the past week dealing with SQL Injection, slow SQL Server growth and two level security.
2008-05-05
58 reads
How often do you worry about your database size and free space? Steve Jones asks how you administer your SQL Server database space this Friday.
2008-05-02
1,108 reads
Steve Jones examines what big is these days and a few examples of what the largest database people in the world deal with.
2008-05-01
349 reads
Steve Jones still thinks there is a lot of value in books, both fiction and non-fiction, but he's looking at e-Readers, specifically the Kindle from Amazon.
2008-04-30
268 reads
The DBA's Mantra: All data readers are evil. Steve Jones talks about a proposed corollary that might be appropriate to ensure security.
2008-04-29
191 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...
Komplek Ruko Roxy Mas, Jl. Kh Hasyim Ashari No.6 Blok C.5 No, RT.6/RW.8, Cideng,...
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...
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