Forum Replies Created

Viewing 15 posts - 451 through 465 (of 49,552 total)

  • RE: Are the posted questions getting worse?

    Sergiy - Friday, January 19, 2018 11:42 PM

    Do roads in Michigan look like this one?https://youtu.be/-mqZ_OZVx7I

    That looks like a pretty decent road....

    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 22, 2018 at 1:01 am

    #1976674

  • RE: Are the posted questions getting worse?

    DesNorton - Sunday, January 21, 2018 9:26 PM

    jasona.work - Sunday, January 21, 2018 7:31 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

    January 22, 2018 at 12:58 am

    #1976673

  • RE: View query was fast with literal in WHERE clause, but super-slow using a variable

    Optimise for XX doesn't have to be the exact value that the query will be called for, just one with around the same number of rows.

    And if 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 17, 2018 at 3:06 pm

    #1976233

  • RE: Can't rollback transaction

    RandomStream - Wednesday, January 17, 2018 9:49 AM

     It will require additional log space as well. If the transaction log disk partition 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 17, 2018 at 2:45 pm

    #1976227

  • RE: Can't rollback transaction

    John Mitchell-245523 - Wednesday, January 17, 2018 9:58 AM

    RandomStream - Wednesday, January 17, 2018 9:49 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 17, 2018 at 2:42 pm

    #1976225

  • RE: Update Statistics : _WA_Sys_0000000 ... Type

    No, it does not mean any of those.
    Update statistics absolutely must run against column statistics. More so than against the stats associated with indexes, since they also get updated...

    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 17, 2018 at 2:42 pm

    #1976224

  • RE: View query was fast with literal in WHERE clause, but super-slow using a variable

    Table-valued functions are not pre-compiled

    The problem is a lack of parameter sniffing. The optimiser can sniff a parameter or literal value, not a variable. It's not due to...

    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 17, 2018 at 2:39 pm

    #1976222

  • RE: SQL Azure - What next

    xsevensinzx - Thursday, January 11, 2018 7:21 PM

    Lynn Pettis - Thursday, January 11, 2018 4:58 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

    January 11, 2018 at 10:27 pm

    #1975671

  • RE: Are the posted questions getting worse?

    Luis Cazares - Thursday, January 11, 2018 9:06 AM

    Sean Lange - Thursday, January 11, 2018 8:16 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 11, 2018 at 9:10 am

    #1975534

  • RE: migrating SQL Enterprise 2008 SP 2 to SQL 2014 Developer

    For that you'll need to uninstall 2008 and then install 2014.

    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 11, 2018 at 9:09 am

    #1975532

  • RE: Error 17054 severity 16 state 1- SQL Server Automatically Restarts

    It's possible.

    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 10, 2018 at 10:33 am

    #1975345

  • RE: T-SQL Question: Stored Procedure with variables and exec statements

    IN (@Variable) is equivalent to = @Variable.
    If you want multiple values in a string, you need dynamic SQL (strongly not recommended due to the security implications) or a string...

    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 10, 2018 at 8:48 am

    #1975304

  • RE: Are the posted questions getting worse?

    "Hello random problem, please try this hammer."

    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 10, 2018 at 7:49 am

    #1975285

  • RE: Need table partitioning implementation guidance for real scenario

    shamshad.ali - Wednesday, January 10, 2018 7:22 AM

    What do you mean by enable archival?

    Presumably adding a scheduled job to...

    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 10, 2018 at 7:30 am

    #1975277

  • RE: Need table partitioning implementation guidance for real scenario

    In most cases partitioning will not help with query performance.
    It's there for data management. Switching sets of data in and out of the table, moving rows to archive, index...

    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 10, 2018 at 5:15 am

    #1975251

Viewing 15 posts - 451 through 465 (of 49,552 total)