Life as a SQL Swiss Army Knife

..or maybe I'm just the guy with the shovel behind the horses in the parade
posts - 5, comments - 0, trackbacks - 0

July 2013 Blog Posts

Fetching Partition Information

For a recent SSIS package at work I needed to determine the distinct values in a partition, the number of rows in each partition and the file group name on which each partition resided in order to come up with a grouping mechanism. Of course sys.partitions comes to mind for some of that but there are a few other tables you need to link to in order to grab the information required. The table I’m working on contains 8.8 billion rows. Finding the distinct partition keys from this table was not a fast operation. My original solution was to...

posted @ Sunday, July 14, 2013 5:38 PM | Feedback (0) | Filed Under [ SSIS SQL Server Partition ]

Powered by:
Powered By Subtext Powered By ASP.NET