Upcoming Speaking Engagements
For those who are interested, I've got a couple of speaking engagements coming up in the next two weeks. I'll be speaking...
2009-06-01
649 reads
For those who are interested, I've got a couple of speaking engagements coming up in the next two weeks. I'll be speaking...
2009-06-01
649 reads
I just finished reading Success Is A Choice: Ten Steps to Overachieving in Business and Life. Written by Rick Pitino,...
2009-05-28
2,201 reads
If you're like me, you've probably typed in LTRIM(RTRIM([value])) hundreds, if not thousands, of times during your travels through SQL...
2009-05-28
1,963 reads
... and other times, they are stop-you-in-your-tracks funny. Here's an example of the latter:
http://msmvps.com/blogs/brianmadsen/archive/2009/04/21/funniest-code-comment-ever.aspx
2009-05-19
721 reads
Over the past 2 days, I’ve gone full bore into Windows 7. I’ve installed RC0 on 2 of my laptops,...
2009-05-12
679 reads
I've got four new SSIS videos published on JumpstartTV.com:
Expression Language Basics
Secure FTP File Transfer in SSIS
SSIS Lookup Transformation Basics
SSIS...
2009-04-20
2,216 reads
The event schedule for SQL Saturday Pensacola has been published. This event will be held on Saturday, June 6 at...
2009-04-16
808 reads
This article demonstrates the use of the SSIS Script Component to create multiple outputs from unconventional data files.
2009-04-15
11,047 reads
Should you ever delete data? In a production environment, do the benefits of deleting old data outweigh the possible risks?
Data...
2009-04-07
1,741 reads
If you’re available and are (or can be) in the Jacksonville FL area the first weekend of next month, check...
2009-04-02
770 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