No infact it has more memory allocated

@Grant and all

Thank you

@Grant/All,absolutely, the advise I have received from this community has been unparalleled.Learnt a lot from here and I rely more here than the web.

Initially the DB was not a true...

• This reply was modified 3 years, 5 months ago by  mtz676.
• This reply was modified 3 years, 5 months ago by  mtz676.
• This reply was modified 3 years, 5 months ago by  mtz676.
• This reply was modified 3 years, 5 months ago by  mtz676.

My bad ,I understand. Thanks again @Grant.

• This reply was modified 3 years, 5 months ago by  mtz676.

@scott,@Grant,@Steve, All

We have again done a straight back and restore across enterprise to standard.Under what circumstances can the execution plans be different.Both instances run on same windows and...

• This reply was modified 3 years, 5 months ago by  mtz676.
• This reply was modified 3 years, 5 months ago by  mtz676.
• This reply was modified 3 years, 5 months ago by  mtz676.
• This reply was modified 3 years, 5 months ago by  mtz676.
• This reply was modified 3 years, 5 months ago by  mtz676.
• This reply was modified 3 years, 5 months ago by  mtz676.
• This reply was modified 3 years, 5 months ago by  mtz676.
• This reply was modified 3 years, 5 months ago by  mtz676.
• This reply was modified 3 years, 5 months ago by  mtz676.

Stats were never updated on both the versions (standard and enterprise).Both stand 2 years old.Checked some tables which are referred in the stored proc.They stats are the same.

Looks like statistics...

• This reply was modified 3 years, 5 months ago by  mtz676.
• This reply was modified 3 years, 5 months ago by  mtz676.

@steve-2 Jones, @Grant and all,

Thank you.

I have saved the execution plans from enterprise and standard edition. How can I force the stored procedure to use the enterprise plan...

• This reply was modified 3 years, 5 months ago by  mtz676.
• This reply was modified 3 years, 5 months ago by  mtz676.
• This reply was modified 3 years, 5 months ago by  mtz676.

I did nothing.They just became readable.

Thanks

@Steve. Thanks

What settings/config values should be checking in Standard and enterprise (fyi:both on same machine)to troubleshoot this.A back and restore has been done from enterprise to standard, so...

• This reply was modified 3 years, 5 months ago by  mtz676.

Thank you @Grant and everybody else.

Can a Stored Procedure(has several parameters as input) run differently in standard or enterprise version when executed from SSMS when compared getting triggered from the...

No more an issue

Thank you everybody.

• This reply was modified 3 years, 5 months ago by  mtz676.

Thank you all for the responses.

And how do we draw a parallel between indexes and statistics(updated/not updated).

Ex: Something like a query which gives me an index and its statistics and...

• This reply was modified 3 years, 7 months ago by  mtz676.

Hello @Brian,

Method1 :This works:
Data is encrypted upon insert.
USE MyDB;
GO
OPEN SYMMETRIC KEY SK1
DECRYPTION BY CERTIFICATE C1;
GO

INSERT into 
[dbo].[SQLCredentials] 
([Server],
[Password], 
[Password_Encrypted]) 
VALUES 
(N'ABCXYZ ',N'sdf^jh&k*',ENCRYPTBYKEY(key_guid('SK1'),'sdf^jh&k*'))
GO
CLOSE SYMMETRIC KEY SK1;
GO

USE...

• This reply was modified 3 years, 8 months ago by  mtz676.

Thanks @Brian for the detailed explanation and your time.