Sorting a String as a Number with T-SQL and SSIS
I was working on a Cube in Analysis Services for a client recently and needed to sort on a field...
2012-01-23
3,867 reads
I was working on a Cube in Analysis Services for a client recently and needed to sort on a field...
2012-01-23
3,867 reads
With some calculated members in MDX it only makes sense to see the calculation if a certain Hierarchy is used....
2011-10-28
2,543 reads
Auditing in SSIS can be a real headache. In this two part series blog I am going to try to...
2011-10-20
3,610 reads
Auditing in SSIS can be a real headache. In this two part series blog I am going to try to...
2011-10-16
1,751 reads
SSIS packages are great ETL tools and can do just about anything you need in terms of ETL. Most organizations...
2011-10-03
1,285 reads
Data mining is a great way to help your company make decisions and predict future values. The Data Mining Algorithms...
2011-09-30
8,719 reads
Previously I wrote a blog on how to do a for each loop to look through each col in an...
2011-09-29
1,264 reads
There is no native function built in to SSIS to get the previous row in the data flow. But with...
2011-09-29
1,786 reads
The Merge component in SSIS will take two sorted sources and union them while maintaining the original sort order. The...
2011-09-28
1,342 reads
If you have a parent package that is looping through a set of files and calling child packages and want...
2011-09-27
2,756 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