Browse by Tags

All Tags » ssis (RSS)
Sun, Nov 16 2008 22:05

Ordered data requires ORDER BY

When you select data out of a database table, it might seem as if the system will give you data in the order of the clustered index that is on that table (assuming it has one), but this isn't quite right. I showed this in the fifth of my T-SQL tips...
Posted by Rob Farley | with no comments
Filed under: , ,
Thu, Jul 3 2008 19:28

Design Query in Editor bug

Ok, so real database developers don't use the graphical "Design Query in Editor"... yeah, I know. Sure, there's the odd time when you're typing a query and you don't have an Object Explorer (eg, in SSIS) and a moment of weakness...
Posted by Rob Farley | 1 comment(s)
Filed under: , ,
Thu, Jun 12 2008 14:50

"No Match Output" in SSIS 2008

The hairy Irishman (his description - I just call him Sacha) is presenting to the Adelaide SQL Server User Group today, talking about improvements in SQL Server 2008 Integration Services. Right now he's talking about the No Match output of the Lookup...
Posted by Rob Farley | 1 comment(s)
Filed under: , ,