I can say, that we have four kinds of users:

1) number affine users that are happy with their static number graveyards, tables and diagrams etc.

2) users that like to "work"...

so I tried the AddEvent SP out. It works fine.

However I read somewhere that this undocumented procedure might be a deprecated feature of SQL Server. (still available in my SQL...

I see were you are going.

That is actually not bad 🙂

I will give it a try and will report back here, if it is working

Hi anthony,

This just seems to be the description of the user interface and how you can create/edit/delete cache-plans.

I didn't find anything here that tells you how to do it with...

Thx Steve,

I will give it a try.

I am little concerned that the developers confuse the "original" with the "live"-Solution and overwrite the cube with an old version.

I have to find...

no opinions?

The execution plan worried me enough so I will modify me SSIS Package to load the dynamicly in the right table and not in the view

I separated the data in different tables to be able to better handle recovery szenarios, rebuild index or anything else.

20 Mio rows * 365 = 7,3 billion every year.

I created...

over the last few years, you provided many good...

I got two answers with two totally different opinions 😉

Unless all those files are on different physical drives, fewer bigger files is better. There's no gain from having lots of...

I checked the first tool (SQL Sentry).

It is quite nice to see, what it automatically shows you about your servers but the function I am looking for are not implemented...

Thanks for your quick replies.

I am looking for coordinating jobs on one system.

However I have a few sytems but they are and will be independent from each other.

If I...

Roy Ernest (1/5/2012)

---

MysteryJimbo (1/5/2012)

---

Roy Ernest (1/5/2012)

---

You do not have to create / modify every object by hand on your subscribers when using Transactional replication. When creating a new table, just...

MysteryJimbo (1/4/2012)

---

Both of these suggestions will work with one caveat, the database will become unavailable when restoring fresh logs or dropping and regenerating the database snapshot. You basically have...

@benjamin: This database contains the Data for my reports and I want to transfer it from the main DWH to a server which is doing Reporting Service and...