Forum Replies Created

Viewing 15 posts - 3,961 through 3,975 (of 49,552 total)

  • RE: Please Suggest Partition boundaries

    MadAdmin (12/22/2015)

    So far, it has only helped me rebuild index partitions on the last changing partition, reducing the maintainance window, giving me extreme savings in my rebuild window, but no...

    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

    December 22, 2015 at 5:27 am

    #1847395

  • RE: Please Suggest Partition boundaries

    Narendra-274001 (12/22/2015)

    I believe partitioning the table will boost up the performance for reporting purposes.

    Very unlikely. Partitioning is not for performance. It's for data management.

    Will partition gain performance for data...

    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

    December 22, 2015 at 3:42 am

    #1847376

  • RE: Please Suggest Partition boundaries

    Ok, so why are you looking at partitioning?

    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

    December 22, 2015 at 1:57 am

    #1847358

  • RE: Running as SysAdmin

    Adrian Chapman (12/22/2015)

    Ivanova (12/21/2015)

    Slightly off-topic; while working for a large financial institution, I was approached by one of the security team. He was a highly-paid and allegedly very security-savvy contractor....

    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

    December 22, 2015 at 1:22 am

    #1847352

  • RE: Please Suggest Partition boundaries

    Why are you partitioning?

    If you're partitioning for data loads and data archives, then the granularity of the data imports will determine what you want to partition 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

    December 22, 2015 at 1:12 am

    #1847350

  • RE: SQL Order By

    Edit: nm

    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

    December 22, 2015 at 1:08 am

    #1847349

  • RE: SQL Order By

    Let's turn this into something more readable first and take out the invalid quotes.

    SELECT Supplier_Details_tbl.Supplier_Name,

    Documents_tbl.Document_Type,

    ...

    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

    December 22, 2015 at 1:06 am

    #1847348

  • RE: Problem: DELETE table_or_view FROM table_sources removes all rows

    Yes, the behaviour's correct. There's no predicate comparing a to b, and the predicate on b cannot filter the rows in a, therefore all rows qualify for the delete and...

    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

    December 22, 2015 at 1:03 am

    #1847347

  • RE: Query performance

    Eric M Russell (12/21/2015)

    Try unit testing using (MAXDOP 1) query hint.

    Why? Parallel execution is good, it means SQL's using resources effectively to return results quickly. A parallel query is no...

    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

    December 22, 2015 at 12:59 am

    #1847346

  • RE: Query performance

    T2512 (12/21/2015)

    That's what i always thought, from a users perspective speed is the only factor.

    From a *user's* perspective all that's important is speed, but you're not a user. 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

    December 22, 2015 at 12:56 am

    #1847345

  • RE: Apply case per row or use simple query

    James Goodwin (12/21/2015)

    I doubt that there is a major difference in execution plan between these.

    You would be wrong.

    The first is a guaranteed table scan every time. The second is far...

    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

    December 22, 2015 at 12:50 am

    #1847344

  • RE: Are the posted questions getting worse?

    I'm pretty sure mall security would have objected to a sabre with light-up blade.

    I don't have one that's just the hilt yet.

    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

    December 21, 2015 at 6:59 am

    #1847110

  • RE: Multiple parameter function !

    If you mean a function that takes an undisclosed number of parameters, you can't create such a function. You have to define the parameters exactly when the function is created...

    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

    December 21, 2015 at 6:25 am

    #1847089

  • RE: Are the posted questions getting worse?

    Scene from Friday evening

    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

    December 21, 2015 at 6:07 am

    #1847082

  • RE: Apply case per row or use simple query

    They've both got inherent performance problems. Take a read through https://www.simple-talk.com/content/article.aspx?article=2280

    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

    December 21, 2015 at 3:34 am

    #1847055

Viewing 15 posts - 3,961 through 3,975 (of 49,552 total)