In my opinion, you should keep the payment related info only in the fact, not in the dimension. And you should create a dimension for all the entities(dimensions for client,...

Hi,

Thank you for the replies. Our workflows are made in informatica, but for the lineage info they ask for extra money, so we need to do it ourselves :-).

We will...

The issue appears with reports more simple that have cascaded parameters if the values from the parameters are changed randomly. Though the report has default parameters which should be used...

I just needed an idea on how should I approach differently the query, more optimized. I will try it with your suggestion.

Thank you

Thanks.

We did that and it seems like there is a Citrix server connection who seems to be the blocker. We will try to stop that connection when possible an give...

sorry for the posts

I was receiving this error : Sorry the application encountered an unexpected error. Information about this error has been logged. If you continue to receive this message...

Thanks man

That's exactly the answer I needed.

Unfortunately the pk is a uniqueidentifier...but I asked you before about this and we agree that is better to put on the uniqueidentifier than...

I found the solution :

create table #temp

(

a int,

b int,

c int,

d int

)

insert into #temp

values(1,0,1,1)

insert into #temp

values(1,0,1,2)

insert into #temp

values(2,0,1,1)

insert into #temp

values(2,0,1,3);

--

select *

from #temp

where a in

...

I want this to be returned

a b c d

1011

1012

2013

In first row c = d

I...

I only need the idea, how to make this happen.Because the query is pretty big and ugly, and I posted before some big scripts and I didn't receive an answer.

....I'll...

You say that procedures age out of cache as they are not accessed. But how often? because in the case I mentioned they aren't kept in the cache even 2...

Of course...I wait for your suggestions....

The sp lists some 'activities' from Wf_Activity table and receives from the UI a whereClause that filters by an organization, workdate, etc.After this the records...

Yes , I used your suggestions , and the sp I just posted is recompiled 40 000 times a day. And I think this is a problem. I know that...

this is a pretty big one too

ALTER PROCEDURE [dbo].[List_ByPages]

(

@User_Id uniqueidentifier,

@Id_Organizationunit uniqueidentifier,

@whereClause Nvarchar(3000),

@PageIndex int,

@PageSize int,

@orderClause nvarchar(50),

@work_Date bit

)

AS

CREATE TABLE #temp_tab

(

[Activity_Id] uniqueidentifier,

[Nome] varchar(255),

[Id_Function]...

I'm using profiler to dig into this and I used OPTION (KEEP PLAN) to "eliminate" the temporary table recompile but no success. It shows me that the next statement...