Forum Replies Created

Viewing 15 posts - 19,621 through 19,635 (of 49,552 total)

  • RE: sargability, optimized execution plans, their caching, dynamic sql, and or highly modularized stored procedures.

    TheSQLGuru (3/23/2012)

    Snargables (3/22/2012)

    If parametized dynamic sql will result in more cache hits then why would anyone write non parameterized dynamic sql?

    There are MANY times where you don't WANT the engine...

    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

    March 23, 2012 at 7:56 am

    #1463403

  • RE: Are the posted questions getting worse?

    Koen Verbeeck (3/23/2012)

    Brandie Tarvin (3/23/2012)

    anthony.green (3/23/2012)

    sorry, i think the sarcasum of the post was lost, few posts this morning which where so very very simple which could of been found...

    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

    March 23, 2012 at 7:14 am

    #1463361

  • RE: How much memory should be allocated to SQL Server 2008 R2 64 Bit Enterprise

    For 10GB of memory on a dedicated SQL Server, I'd probably set max memory to 7 or 8 GB.

    See chapter 4 http://www.simple-talk.com/books/sql-books/troubleshooting-sql-server-a-guide-for-the-accidental-dba/

    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

    March 23, 2012 at 6:38 am

    #1463314

  • RE: clustered index internals

    Never has been. Indexes enforce the logical order, not the physical. An index build or rebuild will try to put the pages down in physical order matching logical, but that's...

    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

    March 23, 2012 at 6:30 am

    #1463308

  • RE: Index Fragmentation

    derekr 43208 (3/23/2012)

    The performance degradation only comes in where SQL needs to perform a large range scan, something like select some_column from some_table where some_column between two or more values...

    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

    March 23, 2012 at 5:25 am

    #1463283

  • RE: Index Fragmentation

    No, the nonclustered indexes always contain the clustered index key.

    So your nonclustered index on Col2 will actually be Col2, Col1 or Col2 inlcude Col1, depending whether the nonclustered 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

    March 23, 2012 at 4:56 am

    #1463271

  • RE: Dead Lock Victim

    anthony.green (3/23/2012)

    each action has a cost against it, its the SPID with the lowest cost which is the deadlock victim

    It's not the cost of the action, it's the cost 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

    March 23, 2012 at 4:17 am

    #1463254

  • RE: Dead Lock Victim

    mc2601 (3/23/2012)

    THnaks

    what about if they also has the same "log Used"?

    Then, assuming they deadlock priorities are the same and they are both user processes, one will be picked at random.

    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

    March 23, 2012 at 4:15 am

    #1463252

  • RE: error plz solve its urgent

    Lynn Pettis (3/22/2012)

    For an urgent error sure not getting any response from the OP and it has been almost 2 hours.

    Urgent = 'My problem's more important than any other here'

    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

    March 22, 2012 at 5:23 pm

    #1463107

  • RE: Is there any option to reduce the size of the log resulting from a reindex/reorg operation? Affecting mirroring to DR env

    Reorganise instead of rebuilding and run small iterations.

    Rebuild just what needs rebuilding and not everything and spread it out over several days

    Set the mirroring to high performance for the rebuild...

    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

    March 22, 2012 at 4:06 pm

    #1463076

  • RE: error plz solve its urgent

    That actually looks like a custom exception (so one intentionally raised by the code) in a CLR function

    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

    March 22, 2012 at 4:03 pm

    #1463073

  • RE: How table look like 3 day ago...

    Restore a backup from 3 days ago as a new database and look at the table in there.

    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

    March 22, 2012 at 10:02 am

    #1462854

  • RE: Update Trigger

    One important point... Do not assume the inserted table contains a single row. It may not. It will contain all the rows affected by the update.

    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

    March 22, 2012 at 9:12 am

    #1462801

  • RE: Need to add a user to a read only database

    Windows accounts get the SID from AD, so it'll be the same on both servers hence the users can't be orphaned because the SIDs match on the two servers.

    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

    March 22, 2012 at 9:04 am

    #1462791

  • RE: Need to add a user to a read only database

    If it's a log shipping secondary, add the user to the primary DB and make sure that the SIDs of the logins are the same on both servers.

    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

    March 22, 2012 at 9:02 am

    #1462786

Viewing 15 posts - 19,621 through 19,635 (of 49,552 total)