April 1, 2014 at 4:31 am
How easy is it configure and install a Data Warehouse in SQL Server 2008 R2?
May 2, 2014 at 11:59 am
Don't know that you install one, they are created within SQL Server. Start with planning what you expect the size to grow to in the future. For each potential table look at the data types and see how much each row will use up. How many users will connect and when? From there you can start to get a sense of the hardware required in terms of cpu power, RAM, permanent storage space, RAID type, etc.... This is a ambiguous question as there are many facets to building a warehouse. AS far as moving data, you can use SSIS or bulk inserts (I prefer SSIS)... etc...
----------------------------------------------------
May 2, 2014 at 12:42 pm
If you are talking about restoring from a backup or attaching a data warehouse, I would say its quite straight forward and simple... There is no such thing like installing it, but designing it.. If you have to design it, you need to know lot of other things...
Good Luck 🙂 .. Visit www.sqlsaga.com for more t-sql code snippets and BI related how to articles.
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply