Viewing 15 posts - 31 through 45 (of 53 total)
More questions?
Then you might consider buying this book:
SQL Server 200 DTS, Wrox editions
The tip comes from this book.
November 12, 2003 at 6:19 am
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...
November 12, 2003 at 6:17 am
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...
November 10, 2003 at 7:01 am
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...
October 22, 2003 at 8:34 am
Excellent!!
Concise and clear article about how to return the executing statement from the db system!
October 15, 2003 at 1:32 am
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...
October 14, 2003 at 1:49 am
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
October 10, 2003 at 1:17 am
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.
August 19, 2003 at 3:23 am
When packages are stored on the SQL server (standard option), they are stored in the msdb database.
August 19, 2003 at 3:21 am
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.
August 14, 2003 at 1:49 am
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.
July 30, 2003 at 1:23 am
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...
July 29, 2003 at 7:51 am
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,...
July 24, 2003 at 1:41 am
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...
July 14, 2003 at 5:34 am
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...
June 18, 2003 at 3:11 am
Viewing 15 posts - 31 through 45 (of 53 total)