Forum Replies Created

Viewing 15 posts - 39,121 through 39,135 (of 49,552 total)

  • RE: Are the posted questions getting worse?

    Florian Reischl (5/13/2009)

    Since Klingons have their own Google...

    http://www.google.com/intl/xx-klingon/

    Awesome. I know what google I'm going to use when I have to do a search for someone here now.

    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

    May 13, 2009 at 2:53 pm

    #994112

  • RE: Are the posted questions getting worse?

    Steve Jones - Editor (5/13/2009)

    I'd also suggest you go 64bit at this point on your machines. Especially with VMs.

    Agreed, and if you're going to be using VMs and SQL, get...

    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

    May 13, 2009 at 8:11 am

    #993753

  • RE: In what case do i need to run the DBCC CHECKDB?

    Run it often enough so that should it find corruption you can restore backups to fix it.

    Once a week is often a good place to start.

    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

    May 13, 2009 at 7:37 am

    #993708

  • RE: there is no sysadmin

    Can you stop the SQL Server for a short while?

    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

    May 13, 2009 at 7:28 am

    #993695

  • RE: Differing Execution Plans - parallel execution

    I'm guessing that SQL's making a bad estimate based on that top. Not sure why. Can you post the two execution plans? (Saved as .sqlplan files, zipped and attached)

    Suggestion on...

    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

    May 13, 2009 at 7:14 am

    #993673

  • RE: there is no sysadmin

    Is the BuiltIn\Administrators group there? Is it sysadmin?

    Are you a member of the Local Administrators group on that server?

    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

    May 13, 2009 at 6:12 am

    #993605

  • RE: Are the posted questions getting worse?

    Jeff Moden (5/12/2009)

    I'd prefer a 17" display but will go with a decent 15" display. Of course, it needs to be able to handle presentations and a couple of different...

    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

    May 13, 2009 at 3:53 am

    #993528

  • RE: Shrinking of log file not working even after backup

    Ok

    Someone started a transaction on the 7th May and hasn't committed or rolled it back. You can either kill session 66, or find out who's running it (using sys.dm_exec_sessions) 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

    May 13, 2009 at 3:45 am

    #993523

  • RE: SQL Server MS Certification

    Take a look at this url: http://www.microsoft.com/learning/mcp/certifications.mspx

    As for sample questions, most of the stuff that you'll find online (testking and the likes) are braindumps, questions taken from the actual exam...

    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

    May 12, 2009 at 10:31 pm

    #993436

  • RE: system databases on a mirror

    Yes.

    Mirroring is per database, not at a server level. The system databases on the two servers are completely independent.

    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

    May 12, 2009 at 10:29 pm

    #993434

  • RE: Advice on Fragmentation and Indexes

    John Najarian (5/12/2009)

    In a query it is better if the table with the least rows is to the right of the join than the left. The table scan...

    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

    May 12, 2009 at 10:27 pm

    #993432

  • RE: Understanding Execution Plans

    WayneS (5/12/2009)

    Most index scans that are still going on appear to be over a range of the index, not the entire index.

    Index scans always read the whole index. They...

    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

    May 12, 2009 at 10:25 pm

    #993429

  • RE: Log shipping Transaction

    May I suggest that you spend some time reading Books Online, especially the sections on backup and restore?

    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

    May 12, 2009 at 10:22 pm

    #993428

  • RE: Are the posted questions getting worse?

    Alvin Ramard (5/12/2009)

    And now, live from the Memphis PASS Chapter meeting, heeeeeeeeeeeere's Bob Hovious.

    Bob

    Bob .......

    Bob???

    BOB!!!!!

    Where are you Bob?

    Computer, locate Bob Hovious.

    <Computer voice>

    Bob Hovious is not within sensor range.

    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

    May 12, 2009 at 1:38 pm

    #993246

  • RE: Fatal error involving a specific table

    kwilthew (5/12/2009)

    I did find out that the DBA who set up this database was having frequent record locks, and he changed a setting that allowed "dirty reads." This may...

    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

    May 12, 2009 at 1:00 pm

    #993222

Viewing 15 posts - 39,121 through 39,135 (of 49,552 total)