How is data stored and retrieved in a warehouse system?
Sep 29 '12 at 05:18 PM
Sep 29 '12 at 05:21 PM
I think you need to detail the question better. Data storage and retrieval within a SQL Server instance is the same, regardless of the design of the database.
Do you mean how are data warehouse databases designed differently?
Up to 2 attachments (including images) can be used with a maximum of 524.3 kB each and 1.0 MB total.
Once you sign in you will be able to subscribe for any updates here
Answers and Comments
asked: Sep 29 '12 at 05:18 PM
Seen: 248 times
Last Updated: Oct 02 '12 at 11:36 AM
ssrs connection string update dymically to point to the correct snapshot(database)
Warehouse Generation Table Clustered Index
SQL 2008 Data Warehousing
Do small tables need indexes
Data vaults: new datawarehouse approach
star schema in ms sql server
Effect of Truncate table on a Clustered Index
What are the differences between snowflake and star schemas?
Fact and Dimension Tables Usage in Datawarehouse
Copyright © 2002-2012 Simple Talk Publishing. All Rights Reserved. If you have any queries, please contact the site administrators.Ask SQL Server Central is a community service provided by Red Gate.