If you have a shared lock on a resource, exclusive locks will not be allowed on it until your shared lock is released. You ca get this to happen...

Drag a Slowly Changing Dimension wizard into your data flow.

I am not going to explain it in detail here, but you specify a type of SCD (in your case it...

The "common" in "common sense" is apparently relative.

I'm afraid bad programming is still alive and kicking.

I guess I cannot say much, I ran a query just like that the other day because someone updated a bunch of...

Deleting and inserting the entire record is not as bad for replication as you think. If you update any field that has a unique index, replication calls it a...

If you ask for $250k in hardware and they jusy say "ok", please let me know and I will send you my resume.

If you have a network admin around, this is the time to discuss it with them. This gets into configuration of your NT domain or Active Directory.

You need to get the remaining information to take an accurate guess at hardware needs. Convincing someone of this can typically be easy. Price out something that could...

The volume of changes sounds like transactional replication would be a good choice. You have to make sure that the changes from the mainframe don't actually do more updating...

I hope I ready your post correctly - I looked quickly, you have a lot of parenthesis, it is friday, and I am hungry.

To simplify this, here is what you...

Yup - if your datasource is Oracle, it drills through to Oracle.

Drillthrough is touchy about data being changed. It uses the key values from the dimensions associated with the...

It returns 22 for me.

Check the function and make sure it really is what you sent me.

What is GETDATE() returning? Is your server date wrong?

Here is a good article:

http://www.databasejournal.com/features/mssql/article.php/10894_1963091_2

Drillthrough will - by default - drill into the data mart the cube is processed from. In you case, it sounds like you have an...

The craziness of right-clicking on a package to schedule it is a thing of the past.

Go to your job agent in Management Studio and create a new job. Add...

The SQLAgent does not use xp_Cmdshell to execute a command line step. You can actually see this in that it does not even connect to a SQL Server to...