Thanks for ALL i got the point

no

if you see my first mail

it includes ::::::::::

SET @ParamDef = N'

@acct_id int,

@tblRules table (

idx int,

thank_you_page_rule_stub uniqueidentifier,

trigger_value_filter_id smallint,

trigger_all_true_flag smallint

),

@thank_you_page_stub ut_stub'

it contains "@tblRules table...

no its not working in the either ways

according to query

the value for page_detail_id = 202 is 1 which is correct , but we apply same logic iin UPDATE query

the answer is NULL but i need 1

now check with this data,

i think there is some problem with join

---------------------------------------

DECLARE @Survey_Thank_You_Page_Config TABLE (

acct_id int,

...

My bad 🙁

i gave wrong data

here is the second table's data

INSERT INTO @Survey_Page_Detail (acct_id, survey_stub, page_detail_value, page_detail_id) SELECT

1, '57F2E213-BC6B-48CA-B025-1597688A8F96', 1, 202 UNION SELECT

1, '2091B6B5-CE91-4110-93D7-311FF642731F', 5, 203 UNION SELECT

1, '57F2E213-BC6B-48CA-B025-1597688A8F96',...

can u please describe your thought ?

thanks

i wil try

this is a new server

but can u please tell me the steps to regster it ? and also how can i verify whther it is still exist...

thanks

it worked for me 🙂

Setting FIXED MEMORY to instance will increase the CPU usage or decrease it ?

Yes , i tried by setting memory to 256mb on one of least used instance but

as when checked the sql jobs on that instance, i found that some...

sorry buddy , i couldnt get ur explaination 🙁

just explain me one thing as u know i have fixed the RAM to all 4 instances , will...

I am sorry buddy , but i couldnt get you explaination ( as i am new in adminstration field)

can u please explain whether fixing memory increase the CPU...

Thanks for immediate response

there are no extra app or services running.

i will assign more memory to pronicipal server then mirrored

but just tell me fixing memory can decrease...