More questions?

Then you might consider buying this book:

SQL Server 200 DTS, Wrox editions

The tip comes from this book.

Hi,

Best is to work with the Step result constants, not the step Disable/Enable properties.

This proc resets the "to do" list of the DTS engine, making it jump back to the...

Instead of SendMail task, which is only cool on your personal computer, you can use a simple activeX script. It uses the CDONTS object listed in the reply above.

Prerequisite: install...

Just include the dimension "Company".

You have no security measures at all to prevent them from viewing all companies.

Only tell the users that this is a cube BEFORE consolidation i.e. you...

Excellent!!

Concise and clear article about how to return the executing statement from the db system!

For transaction systems, natural keys are very easy for referentials such as customer, vendor, account etc.

Surrogate keys may be easy when you need to join two tables with composed primary...

Staging tables without indexes.

After load, transfer data into permanent tables. Build indexes on staging tables AFTER load should you have performance problems with full table scans.

Regards,

Geert

Sometimes, a rollback needs to be done.

This may take some time.

Simply re-run sp_who2 after the KILL statement and check the status of the SPID.

When packages are stored on the SQL server (standard option), they are stored in the msdb database.

CXPacket locks occur when SPID is waiting for all threads to complete.

Reported as a bug in SQL Server 2000, SP1.

However, later SP's don't seem to solve this problem either.

The WHERE clause can be rewritten as:

...

WHERE CHECKSUM(o.data1,o.Data2,o.Data3)<>CHECKSUM(t.data1,t.Data2,t.Data3)

The CHECKSUM creates a CRC value.

When you have only a small portion of the remote table that you need in the linked server query (for example 2 columns out of 200) , use OPENQUERY([Server],'Select') to...

Unfortunately not.

The pk_value will be the same in the duplicate rows.

Because min(pk_value) will return the same value for each row in the duplicates, you'll end up deleting all the rows.

example:

Field1,...

Hi guys,

Just got this one solved too.

You'll need VB to place the results in the table.

A stored procedure may return multiple results. The .NextRecordset allows to jump to the next...

quote:

---

SQL does not support conditional joins.

Best is to work set-based

First SELECT returns records for billing address.

Second SELECT returns records where no billing...