Forum Replies Created

Viewing 15 posts - 11,791 through 11,805 (of 49,552 total)

  • RE: Logical Backup Maintenance Plan

    What exactly do you mean by 'logical' backup and why do you want 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

    September 4, 2013 at 4:57 pm

    #1647538

  • RE: Clustered indexes

    You tried to insert into a page that did not have enough space. Can't fit. So SQL allocates a new page, moves half (or other fraction) of the rows 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

    September 4, 2013 at 4:56 pm

    #1647537

  • RE: Clustered Indexes on Identity columns

    Did you read the article I referenced?

    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

    September 4, 2013 at 3:08 pm

    #1647507

  • RE: Clustered Indexes on Identity columns

    Clustered indexes don't have to be unique, though it is recommended.

    Discussion on clustered indexes

    http://www.sqlservercentral.com/articles/Indexing/68563/

    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

    September 4, 2013 at 2:42 pm

    #1647502

  • RE: It's not you; it's us

    patrickmcginnis59 10839 (9/4/2013)

    GilaMonster (9/4/2013)

    How would they go about that?

    I'd love the lower-level certs to be respected. I'd love to be able to interview someone with a lower-level MS cert 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

    September 4, 2013 at 2:23 pm

    #1647495

  • RE: what is the best way to copy database from 2012 to 2008r2

    rajborntodare (9/4/2013)

    I generated the scripts along with schema and Data by changing it in the options.

    That works OK for tiny databases. Over a couple hundred MB, that generally crashes Management...

    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

    September 4, 2013 at 1:27 pm

    #1647469

  • RE: It's not you; it's us

    patrickmcginnis59 10839 (9/4/2013)

    Maybe I should be asking whats wrong with the lower level certs?

    Braindumps, bootcamps, not technically rigorous. For example, there's only one exam to test a candidate's ability...

    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

    September 4, 2013 at 1:21 pm

    #1647464

  • RE: what is the best way to copy database from 2012 to 2008r2

    Script all objects (not the data, just the objects)

    Create the new database

    Use import/export, SSIS or bcp to move the data

    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

    September 4, 2013 at 12:46 pm

    #1647453

  • RE: Blocking Chain - Spackle

    'k. The earliest I could get started is after PASS. Too much happening before that.

    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

    September 4, 2013 at 11:02 am

    #1647417

  • RE: Blocking Chain - Spackle

    If you don't mind waiting a few months, I can pick this one up.

    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

    September 4, 2013 at 10:31 am

    #1647403

  • RE: Update on differences in table types (temp/var/user)

    If you don't mind waiting a few months, I can pick this one up.

    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

    September 4, 2013 at 10:29 am

    #1647402

  • RE: database in simple mode with growing log file into the GBytes

    If the log needs to be 30GB to accommodate the daily activity (probably lots of inserts/deletes in single statements), then leave the log file at 30GB. It needs to be...

    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

    September 4, 2013 at 9:12 am

    #1647364

  • RE: It's not you; it's us

    Abu Dina (9/4/2013)

    You'll still be earning plenty of $$$$$ 😉

    Really? Why didn't anyone tell me that?

    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

    September 4, 2013 at 8:57 am

    #1647354

  • RE: It's not you; it's us

    patrickmcginnis59 10839 (9/4/2013)

    At the same time, Gail offers that some of these barriers are falling, but I'm not able to find any details on that, anybody know what the actual...

    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

    September 4, 2013 at 8:53 am

    #1647352

  • RE: Path to a Database Architect

    I would disagree. The MCM is not an architectural certification (that's the MCA, which required a significant amount of architectural experience). The MCM was a technical certification, implementation, not architecture.

    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

    September 4, 2013 at 8:50 am

    #1647348

Viewing 15 posts - 11,791 through 11,805 (of 49,552 total)