In AS 2000 (not sure about AS 2005), when you right click on a cube and select process, the next screen has three radio buttons: incremental update; refresh data; full...

I had this situation before and it was caused by parameter sniffing.

Imagine a table of everybody in the world:

select *

from world

where country = 'Belgium'

Assuming an (non clustered) index on country,...

Instead of using # temp tables or ## temp tables, why not create a table in tempdb, insert the data, process from it and then drop the table at the...

I think that your problem is trying to use the results of the substring in the join rather than then substring itself:

Try this:

SELECT SUBSTRING (A.A_id, 1,...

I always prefer a star schema design. However, the actual practice varies.

Technically, you have facts at diffferent levels of granularity and they should go into separate fact...

What's the point of having an ID column on a fact table?

I have an identity column on each dimension table which I use as a surrogate key in...

We use this:

CREATE procedure sp_who3

(

@SPID smallint

)

AS

BEGIN

-- Code obtained from http://sqlblogcasts.com/blogs/antxxxx/archive/2006/11/30/script-to-find-out-what-a-spid-is-doing.aspx

SET NOCOUNT ON

DECLARE @sql_handle-2 binary(20), @handle_found bit

DECLARE @stmt_start int, @stmt_end...

The IN operator with a list is a short hand for a series of OR statements with =.

using a wildcard with an IN operator is like specifying a where COL1...

isNumeric returns True (1) when the string can be converted into a number.

'1111D1' can be converted into a number 1111 - D for decimal

'11E2' can also be converted into a...

You could also use an ActiveX task within DTS to access the File System Object to rename the file.

Jez

sam,

If you want to do this all in DTS then you will need an ActiveX task that checks for the file. If it does not find the the file...

Simon,

I think the remote server is running Windows Server 2003 (Windows NT 5.0 (2195)). Both SQL Servers are enterprise edition.

jez

Lucky,

In my scenario, all I am doing on the remote server is a select - there is no insert or update or delete statement on the remote server so there...

They are both NT 5 and SQL 2000 (SP4).

Jez

Thanks.

I suspect I am running into parameter sniffing - I seem to have overcome this by having variables defined within the procedure which are set to the same as the...