Forum Replies Created

Viewing 15 posts - 24,391 through 24,405 (of 49,552 total)

  • RE: How to Become MVP?

    Oh, to give you a rough idea, this is what my activity the last 12 months looks like.

    25 blog posts, thousands of views per month

    3 published articles

    Tech-Editor on a book

    Chapter...

    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
  • RE: How to Become MVP?

    @SQLFRNDZ (8/5/2011)


    Do Microsoft recongnizes at some point if we are active or do we have to apply or register some where?

    If you're active enough to be a likely candidate, someone...

    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
  • RE: How to Become MVP?

    I've posted all there really is publicly known.

    It's a reward for helping out in the community, valid for 12 months based on the previous 12 month's activity.

    It's not 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
  • RE: Using SQL Server 2005 for 2008 exams

    Steve Jones - SSC Editor (8/5/2011)


    I tend to agree with Gail, though you could just install 2008 as a named instance, set both instances to manual, and only run 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
  • RE: How to Become MVP?

    Be active in the community (very active) and help people. Presentations, books, articles, blogs, forums, formal classes, etc all count in some way. The actual criteria are secret (as 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
  • RE: exam 70-432

    geuncho6 (8/5/2011)


    Can anyone help me with links to free sample questions to 70-432. When you google it, it will find many sites, but a lot of questions are identical...

    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
  • RE: Transaction log full by rebuilding index

    Ninja's_RGR'us (8/5/2011)


    Absolutely agree on the rebuild part... except when you're out of room :-).

    Bulk-logged recovery model (unless there really are 0 dataloss requirements, no exceptions, which the OP has 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
  • RE: MERGE statement to include new column that is an identity column. Don't know how to populate.

    hxkresl (8/5/2011)


    Well, as I said, those tables are just quick mock ups to illustrate my issue, and do not reflect the naming convention or design practices of the development team...

    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
  • RE: Transaction log full by rebuilding index

    Ninja's_RGR'us (8/5/2011)


    I'm now trying to see if I can regorg and take log backups at the same time.

    Sure you can, and reorg runs as lots of little transactions, hence...

    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
  • RE: Using SQL Server 2005 for 2008 exams

    Or uninstall 2005 and install 2008. 2008 doesn't use more memory or CPU than 2005. Trying to run them both at the same time on that laptop would be 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
  • RE: Are the posted questions getting worse?

    Stefan Krzywicki (8/5/2011)


    That's where the "as we know it" comes in. We're getting there, but it is a slow process.

    Maybe in your neck of the woods. Down here I think...

    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
  • RE: Are the posted questions getting worse?

    Jack Corbett (8/5/2011)


    Just so you all know, you can't, at least not without nolock, query a table for row you just deleted within the same transaction. Not saying 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
  • RE: checkdb running on it's own?

    Anytime a database starts SQL logs when the last checkDB completed without error. It's an aid for if you find corruption, you can check and see at what point 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
  • RE: Deadlock question

    Sure, but what do you need from extended events that you can't get from profiler?

    p.s. Not really relevant to OP's question.

    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
  • RE: Deadlock question

    Extended events are a SQL 2008 feature.

    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

Viewing 15 posts - 24,391 through 24,405 (of 49,552 total)