[SQL server issues] Created Issue: AdventureWorksDW2012 Download file corrupt [19063]

There seams to be an issue with the AdventureWorksDW2012 Data file download. When I try to run this SQL statement:

CREATE DATABASE AdventureWorksDW2012 ON (FILENAME = 'E:\MSSQL11.SQL02\MSSQL\DATA\AdventureWorksDW2012_Data.mdf') FOR ATTACH_REBUILD_LOG;

This is the error I get:

Msg 5172, Level 16, State 15, Line 1
The header for file 'E:\MSSQL11.SQL02\MSSQL\DATA\AdventureWorksDW2012_Data.mdf' is not a valid database file header. The FILE SIZE property is incorrect.

Thanks,Dan

.

sqlserversamples.codeplex.com

[SQL Server Data Warehousing] DW Newbie Question - Updating fact table when have type 2 dimension

I'd suggest instead of updating the fact table and throwing away the natural partitioning you get with the historical surrogate key, you can add the dimension's durable key (non-changing natural key) to the fact table in addition to the existing dimension surrogate key.  With this design, you can slice the facts both ways: according to dimension's historical values (join to dim on surrogate key) and according to current values (join to current view of dim on durable key).

There's a good Kimball Design Tip on this topic here:

http://www.kimballgroup.com/2012/07/10/design-tip-147-durable-super-natural-keys/

Let me know if that helps.

---

Brent Greenwood, MS, MCITP, CBIP // Please mark correct answers and helpful posts // http://brentgreenwood.blogspot.com

.

social.technet.microsoft.com/Forums

[SQL Server Data Warehousing] Hai all,

Manish,Thank you so much.

I have one more question,

how do we refresh a database? is it that at once we refresh only one db at a time or we can refresh multiple db's at once?

so can u plz explain the process of refreshing database?

 

Raj,

You are welcome and thanks for visiting MSDN forum,

how do we refresh a database.

This following thread discussed about the same http://social.msdn.microsoft.com/Forums/en-US/sqlgetstarted/thread/d8b6990f-e851-4015-90a4-7b751d6b80a6

Its up to you, if you want to refresh occasionally you can do it manually for a single DB by following certain steps, else you can have automated scripts for multiple DBs too.

Please refer http://weblogs.sqlteam.com/tarad/archive/2009/02/25/How-to-refresh-a-SQL-Server-database-automatically.aspx

---

Thanks
Manish

Please use Marked as Answer if my post solved your problem and use Vote As Helpful if a post was useful.

.

social.technet.microsoft.com/Forums

[SQL Server Data Warehousing] Ms-Sql-Server 2012 asp.net web application licence suggestions (best pract.)

Look at the feature level support at each edition of SQL Server 2012 and map that with your requirements. Depending on your need you may choose the version.

I dont understand what you mean by each user wants to store database in his own machine. Why is it so?

You need to look at the following:

1. Volume of data


2. Availability and performance requirements


3. Data growth projects


4. Which features are required to address the current requirements?


5. What are the possible future requirements that could come up?

This is what I can think of but I am sure this is not complete list.

Regards,

---

Phaneendra Note: Please vote/mark the post as answered if it answers your question/helps to solve your problem.

.

social.technet.microsoft.com/Forums

[SQL Server Data Warehousing] How to create factless fact table?

I had a similar table in a transaction system that eventually the users wanted to measure time between events.

I create a Fact table that has Date and Time dimension tables linked to it as well as Minute Difference columns in the fact table. The ETL handled the calculations and 5-6 rows in the Registration transaction table became one row in the RegFact table.

CREATE TABLE (fact.Registration)

( RegID int, EnterQueueDateID int, EnteredQueueTimeID int, MarkAtDeskDateID int, MarkAtDeskTimeID int, EnteredQueueMarkAtDeskMinutes int...)

)

Instead of a factless fact, we had minute difs in the table. If i had other columns for the fact table, they became dimensions like Office, Recruiter, etc.

Thomas

---

TheSmilingDBA Thomas LeBlanc MCITP 2008 DBA

.

social.technet.microsoft.com/Forums

[SQL Server Data Warehousing] How to make sure that Reporting services can access data during ETL of database

We have SQL Server 2008R2, SSRS and SharePoint 2010. We don't have OLAP cube for reportings.

We have need to Truncate all tables and import all data every night. We are doing this during night, but SSIS tasks takes about 2h.  We do lot of calculations in SSIS and we have milions of rows in tables.

What is simple way to make sure that Reporting Services can get data 24/7?

Analyses Services OLAP is not available for us.

Ken

---

Kenny_I

.

social.technet.microsoft.com/Forums

[SQL Server Data Warehousing] How do delete a part data from partition

We want to delete data (switch partitions) older than 2006 from a partitioned table. There is 2003, 2004, 2005 data that we want to switch, this comes to about 1.5 Billion rows.

While working on switching partitions, found out that up until 20071229, all the data is in one partition,

select @partition.TF_TBL_Fact_Store_Satles_trans(20071229) is 1. and switching partition, will switchout data up until this point.  I need to retain 2006 and 2007 data.

What is the best approach to this?

2006 and 2007 data is about 1.05 billion rows and older than 2006 is about 1.4 billiion rows(need to get rid of this 1.4B data and keep 2006/7).

How best can I handle this situation? Any inputs is much appreciated.

Thanks,

Suresh.

---

Suresh Channamraju

.

social.technet.microsoft.com/Forums