Forum Replies Created

Viewing 15 posts - 14,836 through 14,850 (of 49,552 total)

  • RE: 70-467 BI exam - how do I prepare for this?

    Nasreenm (1/12/2013)

    Hi

    Plan is to take the 70-467 bi solutions exam.

    But very disappointing to see that no official guides

    or kits for this exam and very little info on the web. 🙁

    Books...

    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 12, 2013 at 5:57 am

    #1576563

  • RE: sql server 2005 memrry on 32 bit systems

    From Books Online:

    If there is more than 16 GB of physical memory available on a computer, the operating system requires 2 GB of virtual address space for system purposes 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

    January 12, 2013 at 5:47 am

    #1576562

  • RE: how much time re-indexing of non-clustered index would take in sql server 2000 with huge amount of data

    No way to answer that. Depends on IO throughput, concurrent load and a few other things.

    Restore a backup to a dev server, try an index rebuild there. That gives 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 12, 2013 at 1:01 am

    #1576547

  • RE: TRUNCATE TABLE and ROLLBACK TRAN

    Page splits don't roll back.

    Also, while table variables ignore user transaction rollbacks, statements will still automatically roll back in the case of an error

    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 12, 2013 at 12:59 am

    #1576546

  • RE: Reversed In?

    raohtheconquerer (1/11/2013)

    It seems that the compilier just boils INs to ORs?

    Yup, and it does that whether it's column IN (1,2,3) or 1 IN (Col1, Col2, Col3)

    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, 2013 at 2:53 pm

    #1576518

  • RE: All server trigger creates virtual paging file?

    Lowell (1/11/2013)

    maybe he's confusing a virtual page with a server side trace and the possibility of a log file that has no limitations on the size or number 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

    January 11, 2013 at 2:24 pm

    #1576509

  • RE: Question on Index with Included columns

    For table ABC, probably. Not going to do much for the operations against XYZ of course.

    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, 2013 at 10:34 am

    #1576434

  • RE: All server trigger creates virtual paging file?

    Ask him for a reference or article on this 'virtual file' so that you can learn more about it, seeing as you'd never heard of such a thing. Or straight...

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

    #1576419

  • RE: Question on Index with Included columns

    You can't have a column in the key and include. One or the other.

    Given the predicates, switch the order of the key columns, it's not efficient for that query as...

    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, 2013 at 10:14 am

    #1576418

  • RE: Has to Be a Better Way

    AndrewSQLDBA (1/11/2013)

    I would like to get suggestions or advice on how I can re-write this to be so much better performing. Not having to seek the entire table all those...

    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, 2013 at 9:26 am

    #1576395

  • RE: Restore db with standby

    zi (1/11/2013)

    Thank you very much, I got it mostly

    If I want to stop restoring at a certain log file. what should I do to finish

    what I mean is to change...

    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, 2013 at 7:53 am

    #1576312

  • RE: Are the posted questions getting worse?

    Grant Fritchey (1/11/2013)

    I think Gail would spontaneously combust over a few of the statements I saw.

    Almost, on a few occasions. I've had cases where people quote that site to prove...

    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, 2013 at 7:53 am

    #1576310

  • RE: All server trigger creates virtual paging file?

    Indianrock (1/10/2013)

    The concern expressed to me was that "all server" triggers create a virtual paging file that can fill up a disk.

    Triggers don't create any form of file, virtual...

    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, 2013 at 6:21 am

    #1576246

  • RE: sql server 2005 memrry on 32 bit systems

    Oracle_91 (1/10/2013)

    1. /3GB + AWE

    This would allow SQL to use no more than 3GB of memory, as enabling AWE required the PAE switch to be on

    3. /PAE + /3GB...

    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, 2013 at 5:46 am

    #1576225

  • RE: CXPACKET wait types...

    Please note: year old thread.

    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, 2013 at 5:26 am

    #1576212

Viewing 15 posts - 14,836 through 14,850 (of 49,552 total)