Either by using replication; one-way transactional will provide you with real-time data on the report systems

or by using SSIS, this will work for near-real time data or data util...

winston Smith (4/21/2011)

---

I have been offered a position of working with a small SQL focused consulting agency .

The owner is gifted, has worked on systems in my current company and...

I don't think that index maintainence is needed after a restore, sure it wouldn't hurt. But Wouldn't the index fragmentation remain the same as it was on the first server...

What is the problem with having multiple measures per cube? surely you would not build a cube per measure.

As you have outlined one cube makes more sense, because then...

amartha_dutta (4/20/2011)

---

Hi Raunak ...

I have just started learning SSAS as I am working in SSIS, SSRS and SQL Server.

However I don't consider myself worthy enough to give any kind of...

I would setup a staging table and then read all the data from the spreadsheet into it,

then delete the neccesary data from the table and then setup another data flow...

you could possibly use a Script task and use the office connectivity to delete data from your spreadsheet.

However if would be far easier to use John's suggestion as setup excel...

Without knowing more about the business it is difficult to say for sure.

But I would always favour One cube and one datawarhouse to power the cube, unless there is a...

1) R2 is release 2 , the latest released version of SQL Server

2) do a google search on SQL 2008 editions, the differences are too many to list here

Developer edition is the equivalent of Enterprise edition not Standard.

There should not be any issues with the upgrade to 2008R2, especially since you are keeping the same editions

I also understand...

In the control flow use the Execute SQL task.

I way I would do it would be to convert the statement into a strored proc with One parameter.

then in SSIS use...

To what level is it normalised?

Also i see that you have a...

it sounds like a job suited for Merge Replication, this will allow you to work locally and then push the changes back to the server when required.

As mentioned you can not get this info from the trace,

I would take a 'softer' approach and look at which users have the neccesary permissions to perfrom this operation -...

Raunak Jhawar (4/13/2011)

---

steveb. (4/13/2011)

---

100,000

from the Indian numbering system, quite common depending on where and who you work with...

http://en.wikipedia.org/wiki/Indian_numbering_system

As for...