I would highly recommend moving away from trying to modify the SQL sync procedures in Replication to load your data into a data warehouse. Instead I would create a...

Did the deployment fail or are you getting the error trying to connect to the cube after deployment? Need a little more information in order to be helpful. ...

Somehow you are trying to use SQL 2008 profiler to run a profile against SQL 2008 R2. If you upgrade your Profiler to R2, you will be able to...

Just use the "ROW_NUMBER() OVER" and partition by customer.

There is not really a best practice I am aware of in regards to using views/select statements vs. stored procedures to return the data. There are tradeoffs to both...

Another possibility (and it is a real long shot) is if the job has a very tight window on time between when it succeeded and when it failed and you...

I would try running DBCC CHECKTABLE ("MyTable");

If that returns an error with the current unique clustered index, I would restore the database from a backup. If that is not...