SSIS Fuzzy Lookup Error
A Fuzzy Lookup Task in SSIS that I was working on was bombing out, and I had a heck of...
2011-06-13
1,694 reads
A Fuzzy Lookup Task in SSIS that I was working on was bombing out, and I had a heck of...
2011-06-13
1,694 reads
Ever get a timeout error when using the “View History” for a SQL Server Agent job? I find this happens...
2011-06-10
4,403 reads
BIDS helper is Visual Studio add-in with features that extend and enhance the functionality of the SQL Server 2005 and SQL Server...
2011-06-09
783 reads
Virtualization is becoming a hot topic lately, and there is no doubt it provides a ton of benefits. But you...
2011-06-08
1,128 reads
Interesting video on eWeek.com called Business Intelligence Takes Higher Education Students to the Head of the Class that talks about...
2011-06-07
1,236 reads
A fantastic white paper just released: Microsoft EDW Architecture, Guidance and Deployment Best Practices.
It’s a must read if you are...
2011-06-06
1,120 reads
While there is no way to use a source control system such as Team Foundation Server (TFS) or Subversion with PerformancePoint...
2011-06-03
928 reads
A Windows 8 demo was just released. Looks really cool. Check it out at Previewing ‘Windows 8’ as well as Microsoft’s...
2011-06-02
681 reads
One item on my PerformancePoint wish list is the ability to change a datasource for an Analytic Chart/Grid. There is...
2011-06-01
829 reads
I have been compiling a list of what things a person can do to become an expert, or guru, in...
2011-05-30
5,114 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