It is on the SQL Editor toolbar. I think it is hidden by default. Look at the Add Remove Buttons menu.

Rather than checking if something is running, you should lock a resource. If your procedure can take an exclusive lock on a table or row, it will automatically wait...

In the script transformation editor dialog, there is a connection managers section that you will have to add your connection manager to.

You must use a .Net connection manager, not an...

If you run the system stored procedure sp_Who2 you will see a LastBatch column indicating the last time a batch was executed by the spid. This is probably your...

Actually, 3 is the slowest once you have indexes on the table. Since you are using a function against your table column, SQL cannot use an index and it...

You need to tun on logging to get the actual error messages from your SSIS package.

As an alternative, log into the server that is executing the package with the login...

Again, if you are really stuck and have a query being executed from some code that you cannot get to, you can use a plan guide to add the MAXDOP...

The document is rather rough, but I hope it helps. This is getting into some advanced SSIS concepts so without any experience it may be hard to follow.

Take note...

The server on which you scheduled the packages needs to have the SSIS services installed, needs to have the backward compatibility pack installed, and really should have the same service...

It has to do with the way SQL 2000 and SQL 2005 handled parallel processing.

In SQL 2000, the database engine did not use multiple threads very efficiently. Because of...

If you know the number of groups you have at design-time, you can use a conditional split into one data flow per group and create one "table" per data flow...

I believe on the advanced tab of that same dialog, you could write some custom MDX that does what you are suggesting.

However, I have never tired to ue it in...

Configure your users grouped into roles that define the data they can access. I have attached a screen print from Management Studio that shows where you should be when...

How is your cube security currently configured in Analysis Services? Do you have just a single role with everyone having access to everything at the moment?

If you include a dimension that contains members describing the data individual users should be able to access, you can specify by user or group in the cube security that...