Forum Replies Created

Viewing 15 posts - 1,306 through 1,320 (of 49,552 total)

  • RE: Locking behaviour

    vsamantha35 - Thursday, June 8, 2017 7:18 PM

    1) Why are SELECT is trying to acquire a SCH-S lock? why not Shared lock?
     As...

    Gail Shaw
    Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
    SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

    We walk in the dark places no others will enter
    We stand on the bridge and no one may pass

    June 9, 2017 at 3:52 am

    #1946115

  • RE: Is my database corrupted?

    prettsons - Thursday, June 8, 2017 10:52 PM

    Restore the database from updated and clean backup. Check the database snapshot and if it...

    Gail Shaw
    Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
    SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

    We walk in the dark places no others will enter
    We stand on the bridge and no one may pass

    June 9, 2017 at 2:26 am

    #1946108

  • RE: service packs an CU updates

    No, that CU is for instances that are running SP2, so service pack first, then CU

    Gail Shaw
    Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
    SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

    We walk in the dark places no others will enter
    We stand on the bridge and no one may pass

    June 8, 2017 at 2:10 pm

    #1946066

  • RE: Batches and Transactions

    User B starts the update immediately, but will probably be blocked until User A's session releases locks, which will be when the transaction commits.

    Gail Shaw
    Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
    SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

    We walk in the dark places no others will enter
    We stand on the bridge and no one may pass

    June 8, 2017 at 1:57 pm

    #1946064

  • RE: Missing SYS.DM_DB_INDEX_PHYSICAL_STATS in SQL 2014?

    Yup, case-sensitive is the cause (and that's why I'm allergic to case-sensitive databases).

    The name of the dmv is sys.dm_db_index_physical_stats, all lowercase. You'll have to fix the casing of...

    Gail Shaw
    Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
    SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

    We walk in the dark places no others will enter
    We stand on the bridge and no one may pass

    June 8, 2017 at 1:56 pm

    #1946063

  • RE: Clear all caches for index performance testing, every time?

    I never clear caches, and run queries twice before measuring to ensure caches are hot.
    Reason: my application doesn't run with cold caches.

    Gail Shaw
    Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
    SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

    We walk in the dark places no others will enter
    We stand on the bridge and no one may pass

    June 8, 2017 at 7:42 am

    #1945994

  • RE: Index seek and index scan

    DimPerson - Thursday, June 8, 2017 5:53 AM

    also, I believe there is a "threshold" in terms of number of rows, below which the...

    Gail Shaw
    Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
    SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

    We walk in the dark places no others will enter
    We stand on the bridge and no one may pass

    June 8, 2017 at 6:07 am

    #1945976

  • RE: REPLACE not effective ?!?

    Ah, I just noticed what you're doing.

    You're never updating that long column name, you update NbCum, then try to alter the long column name, and it still has the char(160)...

    Gail Shaw
    Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
    SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

    We walk in the dark places no others will enter
    We stand on the bridge and no one may pass

    June 8, 2017 at 4:21 am

    #1945964

  • RE: REPLACE not effective ?!?

    You're not running in a transaction, so no, you don't need a COMMIT (and you wouldn't even if this was in a transaction)

    It's possible that the whitespace character...

    Gail Shaw
    Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
    SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

    We walk in the dark places no others will enter
    We stand on the bridge and no one may pass

    June 8, 2017 at 3:59 am

    #1945960

  • RE: some indexes got fragmented quickly

    John Mitchell-245523 - Thursday, June 8, 2017 2:59 AM

    GilaMonster - Thursday, June 8, 2017 1:15 AM

    Gail Shaw
    Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
    SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

    We walk in the dark places no others will enter
    We stand on the bridge and no one may pass

    June 8, 2017 at 3:30 am

    #1945956

  • RE: Is my database corrupted?

    Could be that the full backup file was damaged in some way. Do you take your backups WITH CHECKSUM? Can you try a fresh backup?

    Gail Shaw
    Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
    SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

    We walk in the dark places no others will enter
    We stand on the bridge and no one may pass

    June 8, 2017 at 2:52 am

    #1945946

  • RE: DBCC SQLPREF

    Stewart "Arturius" Campbell - Wednesday, June 7, 2017 11:16 PM

    I presume you meant DBCC SQLPERF and not SQLPREF (which is...

    Gail Shaw
    Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
    SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

    We walk in the dark places no others will enter
    We stand on the bridge and no one may pass

    June 8, 2017 at 1:36 am

    #1945936

  • RE: some indexes got fragmented quickly

    WhiteLotus - Thursday, June 8, 2017 1:03 AM

    lower down the fill factor

    Fragmentation is not typically a huge problem,...

    Gail Shaw
    Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
    SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

    We walk in the dark places no others will enter
    We stand on the bridge and no one may pass

    June 8, 2017 at 1:15 am

    #1945935

  • RE: SQl Login Accounts Hashed??

    Ed Wagner - Wednesday, June 7, 2017 4:41 PM

    To expand on what Gail said, the sys.server_principals is the one to query for...

    Gail Shaw
    Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
    SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

    We walk in the dark places no others will enter
    We stand on the bridge and no one may pass

    June 7, 2017 at 4:42 pm

    #1945915

  • RE: Are the posted questions getting worse?

    Hugo Kornelis - Wednesday, June 7, 2017 1:17 PM

    Lynn Pettis - Wednesday, June 7, 2017 12:32 PM

    Gail Shaw
    Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
    SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

    We walk in the dark places no others will enter
    We stand on the bridge and no one may pass

    June 7, 2017 at 1:51 pm

    #1945893

Viewing 15 posts - 1,306 through 1,320 (of 49,552 total)