Forum Replies Created

Viewing 15 posts - 23,281 through 23,295 (of 49,552 total)

  • RE: What threshold value is optimal for index rebuild ?

    SQL Guy 1 (9/26/2011)

    I am creating a script to rebuild/reorganize all indexes in our database

    Why are you re-inventing the wheel?

    http://www.sqlfool.com

    http://ola.hallengren.com/

    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

    September 26, 2011 at 11:37 am

    #1386696

  • RE: Probabilities and Disaster Recovery

    Eric M Russell (9/26/2011)

    GilaMonster (9/26/2011)

    Eric M Russell (9/26/2011)

    ...

    That alone won't do anything other than raise an error that says something untrue. It's not rolling back the transaction. That transaction committed.

    ...

    Probably...

    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

    September 26, 2011 at 11:33 am

    #1386695

  • RE: Two Node Cluster Performance Improvement over single server ?

    Try some temp tables. Rather than a CTE for the Resumes, insert that into a temp table, index it and then select out just the ones you want. Also try...

    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

    September 26, 2011 at 10:50 am

    #1386669

  • RE: How are views stored in SQL Server?

    Yup. Absolutely.

    On a tiny resultset like that, it probably will. Get larger and more complex and the bets are off.

    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

    September 26, 2011 at 9:38 am

    #1386603

  • RE: Need verification on this matter

    InfiniteError (9/26/2011)

    thanks guys for all the answers.

    Sorry if my example is not that clear. My example assume that all are the same (same number of records, indexes, where clause). Honeslty...

    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

    September 26, 2011 at 9:30 am

    #1386594

  • RE: How are views stored in SQL Server?

    jared-709193 (9/26/2011)

    Maybe a better way for me to phrase the question is this: "Is the ORDER BY clause ignored in the ORDER of the result set of a view 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

    September 26, 2011 at 9:27 am

    #1386591

  • RE: How are views stored in SQL Server?

    jared-709193 (9/26/2011)

    And you use it this way:

    select Col1

    from dbo.MyView

    where Col2 = 'apple';

    Is NOT the same as

    select Col1

    from

    (select Col1, Col2

    from dbo.Table1

    inner join dbo.Table2

    ...

    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

    September 26, 2011 at 9:26 am

    #1386588

  • RE: How are views stored in SQL Server?

    jared-709193 (9/26/2011)

    It is "as if" the view executes its saved query, but temporarily stores that result set in the same way it stores data in a table such that when...

    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

    September 26, 2011 at 9:20 am

    #1386583

  • RE: How are views stored in SQL Server?

    jared-709193 (9/26/2011)

    Can anybody explain this or point me to an article that really gets into how SQL Server stores this data?

    It doesn't store it.

    All that's saved for a view...

    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

    September 26, 2011 at 9:19 am

    #1386581

  • RE: Need verification on this matter

    Revenant (9/26/2011)

    Also, it is safer to allow user code access only views and sprocs. Sprocs are usually a bit faster because they are pre-compiled while passed SQL has 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

    September 26, 2011 at 8:52 am

    #1386562

  • RE: Need verification on this matter

    Sean Lange (9/26/2011)

    Generally speaking you could have a slight improvement from a stored procedure over dynamic sql. This performance will increase if it is executed frequently due to plan caching.

    Ad-hoc...

    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

    September 26, 2011 at 8:51 am

    #1386561

  • RE: Probabilities and Disaster Recovery

    Eric M Russell (9/26/2011)

    declare @product_category int = 7;

    -- Oops! This update has a bug in the WHERE clause...

    update product

    set price = price * 1.10

    ...

    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

    September 26, 2011 at 8:26 am

    #1386533

  • RE: Two Node Cluster Performance Improvement over single server ?

    Hardware is the last thing that you should consider when trying to fix performance. It often has the least effects and I've seen a couple of cases where the hardware...

    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

    September 26, 2011 at 8:17 am

    #1386523

  • RE: Two Node Cluster Performance Improvement over single server ?

    None whatsoever.

    Clustering is a high-availability solution, it's not for performance and it's no scale-out. With a 2-node cluster, SQL will be running on one of the cluster nodes and 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

    September 26, 2011 at 7:21 am

    #1386469

  • RE: Getting Truncated data back

    prakash 67108 (9/26/2011)

    its like stop operating the database...or broken up..

    "My car's like broken, how do I fix it?"

    Is that really an answerable questions?

    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

    September 26, 2011 at 6:29 am

    #1386419

Viewing 15 posts - 23,281 through 23,295 (of 49,552 total)