If you have a record locked, the READPAST table hint in another query will make the query skip the locked records.

This is typically a bad approach to record locking as...

Typically, updating records in fact table involves adding a reversal record for the original and then adding a new record. This way, an incremental process will cancel out the...

First, for the lookup. By default, a lookup component will be in full cache mode. This means that during the pre-execute phase, it will cache all of the...

You have a couple of options. One is to add a dimension and hierarchy that has the NT User name of each of your users associated with the data...

MS SQL Server does not perform well doing row-by-row operations. By putting the cursor within your trigger, you have essentially serialized any set-based operation you could have had. ...

Click on the "Event Handlers" tab.

Be aware that if you put something in the OnError event handler for a package that it will be fired multiple times if something within...

It's pretty amazing how often an idiot will find a clever way around your safeguards.

The other result will probably be you spending four hours wondering why you cannot restore the...

Ganesh - verify that when you try to query another table that your process is actually blocked (check sp_who2 for a blocked process). If it is not being blocked,...

Right-click in the control flow of your packages and turn on logging. You need to log the errors in both the parent and child packages to really determine what...

You cannot restore to a database if there is an open connection to it. You could simply create a job that executes when the SQL Agent starts. Put...

I completely agree that calling any kind of activeX object from a trigger is probably a risky proposition.

The logging table / job method should really be done via service broker...

These issues are usually permissions problems.

Make sure the SQL Agent service account can access the shared folder.

If you do not delete data from the table, and the order in which the data is inserted cannot be anticipated, a heap like this will allow data to be...

SSIS does not like changing schema.

You could stabilize the schema by using a second workbook that consists of a bunch of formulas that link it to the actual data you...

What is the point? A failover cluster is for hardware redundancy. Are you trying to ensure you don't have a "virtual hardware failure" on just one of the...