Forum Replies Created

Viewing 15 posts - 24,316 through 24,330 (of 49,552 total)

  • RE: Frequently used DMV's & DBCC commands.....

    Subjective Adapts (8/9/2011)

    2.DBCC CHECKCATALOG

    This command checks for consistency in and between system tables. This command is not executed within the DBCC CHECKDB command, so running this command weekly is recommended.

    CheckDB...

    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

    August 9, 2011 at 6:17 am

    #1365822

  • RE: Can REBUILDING the index cause deadlock?

    Those are both on by default. If they're both off, SQL can only take table-level locks. Not good for concurrency.

    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

    August 9, 2011 at 6:08 am

    #1365816

  • RE: how to audit: interview question

    colin.Leversuch-Roberts (8/9/2011)

    one might observe that not knowing the answer led to the correct decision!

    And I like to ask one question that I know the candidate cannot answer (eg...

    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

    August 9, 2011 at 6:07 am

    #1365814

  • RE: How will you write a query for this scenario

    Jeff Moden (8/9/2011)

    Yowch! 2 WEEKS for the original code? Heh... talk about your basic long running queries. That really does fall in the category of "What were...

    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

    August 9, 2011 at 6:05 am

    #1365811

  • RE: SQL DATABASE IN RECOVERY MODE

    srinath.vanama (8/9/2011)

    if Log size is huge simply shrink log files. and then restart services.

    Nope. Bad advice and may in fact cause the problem you say it will prevent if 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

    August 9, 2011 at 6:03 am

    #1365809

  • RE: how to audit: interview question

    Ask the user (or check the application logs) for what the error was.

    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

    August 9, 2011 at 4:22 am

    #1365731

  • RE: How to free space on a disk??

    Jayanth_Kurup (8/9/2011)

    e,g simply backing up a db will free space .

    It does not.

    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

    August 9, 2011 at 3:43 am

    #1365718

  • RE: best procedure to "shut down" a database/sql instance?

    No. Both stop the service.

    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

    August 9, 2011 at 3:29 am

    #1365711

  • RE: SQL DATABASE IN RECOVERY MODE

    Wait.

    Recovery is a necessary process to bring the DB up clean. Wait it out, it will finish. Anything you do (like restart SQL) will just start it over again from...

    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

    August 9, 2011 at 3:28 am

    #1365710

  • RE: How will you write a query for this scenario

    Jeff Moden (8/8/2011)

    Since I was operating under what you said ("had to do something like that") and the QU greatly simplified this problem, I was (still) trying to sway 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

    August 9, 2011 at 3:27 am

    #1365709

  • RE: Simplify Large Queries with Temporary Tables, Table Variables and CTEs

    Josh Ashwood (8/9/2011)

    However the more relevant question we are often faced with is what performs better - table variables, temp tables, or CTE's or leave the damn thing in one...

    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

    August 9, 2011 at 3:20 am

    #1365699

  • RE: Frequently used DMV's & DBCC commands.....

    I could list a hundred or so... (and a read through Books Online would give you the same)

    What are you specifically looking for?

    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

    August 9, 2011 at 3:15 am

    #1365695

  • RE: best procedure to "shut down" a database/sql instance?

    SQL config manager (or services manager, or cluster admin) stop service.

    Or you can just reboot, that will stop the service during the shutdown

    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

    August 9, 2011 at 3:13 am

    #1365693

  • RE: pages and extent information combined

    Remember an extent is just a contiguous set of 8 pages aligned on a 64kb boundary. Hence if you have a way to identify the pages (like DBCC IND) 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

    August 9, 2011 at 3:11 am

    #1365690

  • RE: How to Become MVP?

    Fal (8/8/2011)

    Just to bring this thread back on topic, I was told by an MVP that a few years ago Microsoft awarded MVP status to anyone who was running a...

    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

    August 9, 2011 at 2:50 am

    #1365678

Viewing 15 posts - 24,316 through 24,330 (of 49,552 total)