Make sure everything SQL Server related is uninstalled. Then install SQL Server again and do a repair afterwards.

Easy one for the Monday 😀

Especially easy because the way the answers were structured, you only had to calculate the last column 🙂

The more RAM, the better 🙂

CPU isn't that important, you will be doing pretty simple exercises, not calculating PI till the millionth digit. 🙂

Enough space on the hard disk is...

Great question Tom, thanks!

subbareddy542 (11/2/2012)

---

this error is version related problem....

pls try below steps...

(1) open your SSIS Package related solution explorer

next go to properties

next go to dedugging

next chage below mentioned property.

...

Check your "

There are a few missing and a few that don't belong.

You don't close your final " at the end. (that might be a copy pasting issue when you pasted the expression into the forum)

You have several line breaks, but...

Right click on the field and go to textbox properties.

There you can go to the number tab and specify the format for negative values.

The problem is that the OLE DB connection cannot convert unicode characters to non-unicode characters. (the error is quite self-explanatory)

What is the datatype of the source?

What is the datatype of...

If SSIS can't read the registry, it will think it is an evaluation edition.

http://stackoverflow.com/questions/527839/ssis-package-fails-on-execute-integration-services-evaluation-period-has-expire

Try running the package as administrator and see what happens.

ps: enterprise edition on a development server. Seems...

Great question! Easier than it first looks, if you take into account that a primary key has to be unique and that a clustered unique index needs to include the...

prakashsa2709 (11/1/2012)

---

Hi Paul,

I think that storing the value " amount of purchases last 12 Month" in the dimension table is valid.Let me explain one scenario where it would be usefull.Suppose...

Paul Hernández (10/31/2012)

---

Sorry for that, I realized that my question has a better forum category after I summited here. I don´t know how to erase the post from this forum...

There's a cleanup job that removes records from the change tables, so you might want to check into that.

Please do not crosspost. It wastes peoples time and fragments replies.

Original thread with replies can be found here:

http://www.sqlservercentral.com/Forums/Topic1379230-363-1.aspx