Forum Replies Created

Viewing 15 posts - 481 through 495 (of 49,552 total)

  • RE: Splitting TempDB across multiple files

    PageIOLatch = contention on the IO subsystem. That won't be fixed by more files, unless the files are on separate IO subsystems.

    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

    January 5, 2018 at 1:23 pm

    #1974762

  • RE: It's Time to Patch and Upgrade

    chrisn-585491 - Friday, January 5, 2018 8:03 AM

    GilaMonster - Friday, January 5, 2018 7:31 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

    January 5, 2018 at 8:10 am

    #1974701

  • RE: It's Time to Patch and Upgrade

    Eric M Russell - Friday, January 5, 2018 7:23 AM

    Tuesday morning I discovered an overnight ETL process hosted on an Azure IaaS...

    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

    January 5, 2018 at 7:31 am

    #1974683

  • RE: It's Time to Patch and Upgrade

    chrisn-585491 - Friday, January 5, 2018 6:17 AM

    (As a side note, one of my main frame sysadmin buddies, is saying "I...

    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

    January 5, 2018 at 6:48 am

    #1974671

  • RE: Backup & Restore time

    Test if it's faster to move the databases by hand rather than over the network (copy to external drive, take to server room). Assuming not cloud, that 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

    January 5, 2018 at 6:30 am

    #1974665

  • RE: Temporary tables in TEMPDB

    It prevents performance problems. That's why SQL caches the shells of temp tables, to make the process of creating new temp tables faster.
    And you don't truncate them, because they're...

    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

    January 5, 2018 at 6:27 am

    #1974664

  • RE: Problem with Tuning of Delete Statement

    What is this query doing?
    Can the process of getting data into the tables be changed so that the delete is not necessary?

    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

    January 5, 2018 at 6:25 am

    #1974662

  • RE: Backup & Restore time

    It depends completely on the IO subsystem, how fast it can read and write the DB and, if there's a network copy involved, how long that will take.

    48...

    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

    January 5, 2018 at 5:49 am

    #1974649

  • RE: Only one expression can be specified in the select list when the subquery is not introduced with EXISTS

    Ok, the problem is that CASE (SELECT ...) must only return a single column and a single row, because it's part of a scalar expression.
    Multiple columns is easy, you...

    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

    January 5, 2018 at 3:21 am

    #1974630

  • RE: Only one expression can be specified in the select list when the subquery is not introduced with EXISTS

    Please post the entire query.
    The code you posted has no subqueries, and hence cannot throw that error. It does however fail to parse with

    Msg 102, Level...

    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

    January 5, 2018 at 3:02 am

    #1974628

  • RE: Splitting TempDB across multiple files

    Tava - Friday, January 5, 2018 2:46 AM

      Is it purely when you see lot of PageIO and CXpacket wait MS...

    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

    January 5, 2018 at 3:00 am

    #1974627

  • RE: Temporary tables in TEMPDB

    They're either table variables or the shells of temp tables which SQL caches so that it doesn't have to do so much work to create new ones.

    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

    January 5, 2018 at 12:43 am

    #1974616

  • RE: Are the posted questions getting worse?

    Steve Jones - SSC Editor - Thursday, January 4, 2018 1:27 PM

    GilaMonster - Thursday, January 4, 2018...

    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

    January 4, 2018 at 1:28 pm

    #1974528

  • RE: Are the posted questions getting worse?

    grant@scarydba.com - Thursday, January 4, 2018 1:18 PM

    Steve Jones - SSC Editor - Thursday, January 4, 2018...

    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

    January 4, 2018 at 1:25 pm

    #1974525

  • RE: Multiple Files in a FileGroup but still space issue error.

    GilaMonster - Thursday, January 4, 2018 1:06 PM

    Can you please either script out the CREATE DATABASE, or upload a screenshot 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

    January 4, 2018 at 1:22 pm

    #1974524

Viewing 15 posts - 481 through 495 (of 49,552 total)