Thx guys.

As I am looking for a more native way to handle this, so non so technical people can configure those Subscription I will wait for the R2, which...

hi again,

I guess I fixed it.

I gave the AD-Group "public"-rights on the Database, so no rights to select, update, delete.

In the report I call a stored prodecure with my sql-login...

There is just one table that needs to...

Hi Jeff,

I created an index to test it. I realised that I had to put the part_key_id in to the "sorted" columns, so it looks like that:

CREATE NONCLUSTERED INDEX [IX_ST_activity_valid_from_valid_to_customerno]...

Thanks Paul, I am open for constructive criticism though.

The idea for partitioning is that I have about 100 million users from different portals united in one dwh.

Load processes are...

Thanks for your advice.

I would like to read sth out of the execution plan, but I do not see anything out of the index creation index plan 🙁 or which...

So Many Hits no answer... Is that a Problem that no One has or no One knows an answer to? :w00t:

I looked it up.

There are just a few deletes < 10.000.

But for every row I update there will be an insert row to.

In one ETL there will be about 250.000...

The dataflow is working like this

SELECT --> conditional split --> Update --> union all --> insert

...

I know this post has not been updated for a while,

but wanted to know if there was an hotfix/workaround (not the docy-style :-))

I created a few of the IS NULL...

Do you have any recommendations for Monitoring? or just the Windows Perfmon?

If Perfmon any recons on the counters I should have a look at?

Thank you guys.

I will try it out.

Currently we don't have performance issues at all, at those systems are quite new (6 month) and we still have to migrate a lot...

Bru Medishetty (2/18/2010)

---

I would like to know, where have you seen that recommendation of disabling auto growth for database file.

It is suggested to have the files large enough that they...

Here I have some details for the databases:

Main-DB is the DWH-DB

with about 130 Million User. About 10 tables with non historizied data (so 130 Million rows) and 10 historized tables...

Thanks guys. That will help

Cheers,

Mitch