Forum Replies Created

Viewing 15 posts - 661 through 675 (of 49,552 total)

  • RE: Slow performance - Using top 1 Order by Desc

    sgmunson - Monday, November 6, 2017 7:45 AM

      An ideal one would be on FK_UsageID and be a "filtered" index, using a...

    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

    November 6, 2017 at 8:06 am

    #1966795

  • RE: Question regarding query optimizer / query plan

    One fundamental requirement that the optimiser has is that plans must be safe for reuse, since plans are cached and reused. So any plan generated for that query MUST return...

    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

    November 5, 2017 at 6:45 pm

    #1966720

  • RE: Update query for 2 table

    Qualify the column name.

    UPDATE s
    SET ID_Request = r.ID_Request
    FROM Student s
    INNER JOIN Request r ON s.ID_Request = r.ID_Request
    WHERE...

    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

    November 3, 2017 at 3:26 pm

    #1966637

  • RE: Modifying my parameterized query to select * an entire column

    ???
    Don't understand the question

    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

    November 3, 2017 at 3:16 pm

    #1966636

  • RE: Changing NVARCHAR to VARCHAR...

    If you're designing a new table, yes. If you're considering altering an existing table, then, as I said earlier

    GilaMonster - Wednesday, November 1, 2017 1:06...

    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

    November 3, 2017 at 3:10 pm

    #1966634

  • RE: Are the posted questions getting worse?

    Ed Wagner - Friday, November 3, 2017 10:57 AM

    Luis Cazares - Friday, November 3, 2017 10:40 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

    November 3, 2017 at 3:07 pm

    #1966633

  • RE: Changing NVARCHAR to VARCHAR...

    Jeff Moden - Thursday, November 2, 2017 9:23 PM

    Yes.  If you oversize the columns and/or the parameters that you use in stored...

    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

    November 3, 2017 at 9:13 am

    #1966575

  • RE: Changing NVARCHAR to VARCHAR...

    Arsh - Thursday, November 2, 2017 7:43 PM

     No matter what one does,one is declared 'underperforming' if one doesn't have advanced coding expertise...

    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

    November 3, 2017 at 9:09 am

    #1966574

  • RE: Error while Storing Results of a stored procedure into a temp table -- Using SQL server 2016

    RkKar - Thursday, November 2, 2017 3:33 PM

    But the stored procedure got 500 columns in it.

    Doesn't change Sue's answer, just going...

    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

    November 2, 2017 at 3:38 pm

    #1966499

  • RE: Changing NVARCHAR to VARCHAR...

    Arsh - Thursday, November 2, 2017 12:31 AM

    So can we conclude that code improvement is the major , if not 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

    November 2, 2017 at 3:18 pm

    #1966491

  • RE: Are the posted questions getting worse?

    Sean Lange - Thursday, November 2, 2017 10:37 AM

    Not really sure why but the wikipedia page for Sargable has been deleted. This...

    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

    November 2, 2017 at 3:04 pm

    #1966487

  • RE: Changing NVARCHAR to VARCHAR...

    Arsh - Wednesday, November 1, 2017 9:16 PM

    . Will SQL not be forced to get that 40% empty spaces too into...

    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

    November 2, 2017 at 12:00 am

    #1966342

  • RE: HA and DR Solution

    ffarouqi - Wednesday, November 1, 2017 11:12 AM

    My question at this point is why we can't have a shared storage between 2...

    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

    November 1, 2017 at 1:15 pm

    #1966285

  • RE: Are the posted questions getting worse?

    Thom A - Wednesday, November 1, 2017 1:06 PM

    Edit; initial hyper done. Gail, any links to the announcement page?

    Other than the tweets...

    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

    November 1, 2017 at 1:11 pm

    #1966283

  • RE: Changing NVARCHAR to VARCHAR...

    Arsh - Wednesday, November 1, 2017 3:42 AM

    Now the real question is , can I hope to get any performance benefit by...

    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

    November 1, 2017 at 1:06 pm

    #1966279

Viewing 15 posts - 661 through 675 (of 49,552 total)