Forum Replies Created

Viewing 15 posts - 16 through 30 (of 267 total)

  • Reply To: SQL Servers query time differences

    @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 1 year, 1 month ago by  mtz676.
    • This reply was modified 1 year, 1 month ago by  mtz676.
    • This reply was modified 1 year, 1 month ago by  mtz676.
    • This reply was modified 1 year, 1 month ago by  mtz676.
  • Reply To: SQL Servers query time differences

    My bad ,I understand. Thanks again @Grant.

    • This reply was modified 1 year, 1 month ago by  mtz676.
  • Reply To: SQL Servers query time differences

    @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 1 year, 1 month ago by  mtz676.
    • This reply was modified 1 year, 1 month ago by  mtz676.
    • This reply was modified 1 year, 1 month ago by  mtz676.
    • This reply was modified 1 year, 1 month ago by  mtz676.
    • This reply was modified 1 year, 1 month ago by  mtz676.
    • This reply was modified 1 year, 1 month ago by  mtz676.
    • This reply was modified 1 year, 1 month ago by  mtz676.
    • This reply was modified 1 year, 1 month ago by  mtz676.
    • This reply was modified 1 year, 1 month ago by  mtz676.
  • Reply To: SQL Servers query time differences

    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 1 year, 1 month ago by  mtz676.
    • This reply was modified 1 year, 1 month ago by  mtz676.
  • Reply To: SQL Servers query time differences

    @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 1 year, 1 month ago by  mtz676.
    • This reply was modified 1 year, 1 month ago by  mtz676.
    • This reply was modified 1 year, 1 month ago by  mtz676.
  • Reply To: Reading multiple audit files

    I did nothing.They just became readable.

    Thanks

  • Reply To: SQL Servers query time differences

    @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 1 year, 1 month ago by  mtz676.
  • Reply To: SQL Servers query time differences

    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...

  • Reply To: Reading multiple audit files

    No more an issue

  • Reply To: SQL Servers query time differences

    Thank you everybody.

    • This reply was modified 1 year, 2 months ago by  mtz676.
  • Reply To: Identify Indexes hurting performance

    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 1 year, 3 months ago by  mtz676.
  • Reply To: Encrypt/Decrypt issue

    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 1 year, 5 months ago by  mtz676.
  • Reply To: Most accessed tables/indexes

    Thanks @Brian for the detailed explanation and your time.

  • Reply To: Server identification

    Hello @jeff,

    We use MAPS to collect SQL inventory from all servers, but MAPS cannot be automated.Are there any other free tools which can scan our network periodicaly and...

    • This reply was modified 1 year, 5 months ago by  mtz676.
  • Reply To: Server identification

    Thanks @jeff for your time and the elaborate answer.

    • This reply was modified 1 year, 5 months ago by  mtz676.

Viewing 15 posts - 16 through 30 (of 267 total)