Viewing 6 posts - 31 through 36 (of 36 total)
To get data from 'n' number of tables you can use the JOIN predicate. But personally I feel joining more tables will always hinder the process and data fetching...
December 27, 2011 at 7:47 am
As I understand from your query , you want to create a SSAS cube from the excel data. If I am correct then the below link should help...
December 21, 2011 at 7:10 am
CDC in SQL Server 2008 would be a step to start for incremental load.
April 4, 2011 at 6:32 am
Good Question. Thought both would truncate to 'GIV' and 'GIV'. Should have been more thoughtful.:-)
August 4, 2010 at 2:02 am
Thanks for the info
August 3, 2010 at 1:44 am
By huge time I mean some queries take more time to execute on an average say 3 min and more.These are the queries which i need to update on...
July 29, 2010 at 9:53 am