Forum Replies Created

Viewing 15 posts - 25,606 through 25,620 (of 49,552 total)

  • RE: Are the posted questions getting worse?

    Tom.Thomson (6/9/2011)

    Gianluca Sartori (6/9/2011)

    Our alphabet soup friend gives weird recommendations on LinkedIN

    I'm starting to think he downloaded his certs from the pirate bay. 😀

    Is that our |MCITP|OCP|OCE|SCJP|IBMCDB| friend?

    I just...

    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

    June 9, 2011 at 12:54 pm

    #1336647

  • RE: Database stuck in recovery mode

    Not too bad.

    Either there was some incredibly long-running transaction that had to be rolled back, or there was some IO contention (or both)

    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

    June 9, 2011 at 12:29 pm

    #1336626

  • RE: PerfectDisk Vs DisKeeper

    If you get Diskeeper, patch it to the latest version immediately. Some of the older versions have nasty corruption- or error-causing bugs

    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

    June 9, 2011 at 11:19 am

    #1336559

  • RE: Are the posted questions getting worse?

    Brandie Tarvin (6/9/2011)

    SQLRNNR (6/9/2011)

    GilaMonster (6/9/2011)

    Jim Murphy (6/9/2011)

    The best part is that your posts are not useless point-getting restatements. Grrrr, I hate those.

    You mean the parrot effect? Someone posts 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

    June 9, 2011 at 10:28 am

    #1336486

  • RE: Are the posted questions getting worse?

    Jim Murphy (6/9/2011)

    The best part is that your posts are not useless point-getting restatements. Grrrr, I hate those.

    You mean the parrot effect? Someone posts a solution and suddenly three...

    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

    June 9, 2011 at 10:03 am

    #1336459

  • RE: Changing recovery model

    Totally depends on the requirements. If there's a no-data-loss requirement then I would switch to full recovery, use bulk-logged if necessary for bulk inserts.

    4GB is still a tiny DB. I...

    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

    June 9, 2011 at 9:19 am

    #1336414

  • RE: Database stuck in recovery mode

    Wait. If you restart it will start over from scratch.

    Check that something else (large disk copies, other database activity) isn't causing disk contention.

    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

    June 9, 2011 at 9:01 am

    #1336394

  • RE: Index REORGANIZE question

    SQL_Athmi (6/9/2011)

    First SHRINK and then REORGANIZE.

    SINGLE MODE is good.

    Rather don't shrink, just reorganise (or rebuild). No need for single user mode, both can be done without any risk...

    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

    June 9, 2011 at 8:59 am

    #1336389

  • RE: Changing recovery model

    river1 (6/9/2011)

    I will change the database to full recovery model but my log file will grow a lot.

    This will happen because Bulk inserts 70 MB of data to...

    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

    June 9, 2011 at 8:42 am

    #1336364

  • RE: Are the posted questions getting worse?

    Stefan Krzywicki (6/9/2011)

    I think I'd be more worried about someone with a gladius on a subway car. A claymore is a lot of steel in a confined space.

    It's more 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

    June 9, 2011 at 8:28 am

    #1336354

  • RE: Are the posted questions getting worse?

    Chad Crawford (6/9/2011)

    If I'm a "Database Engineer", it doesn't sound like I know anything.

    That was my title at the bank 3 or so years ago...

    Senior consultant?...

    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

    June 9, 2011 at 8:26 am

    #1336347

  • RE: Are the posted questions getting worse?

    I post too much.

    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

    June 9, 2011 at 8:24 am

    #1336345

  • RE: Where am I at in my SQL DBA Career?

    jarid.lawson (6/9/2011)

    Based on what all I read, it sounds like I would be rated an experienced Jr. DBA. Does that sound right? If so, what recommendations do you have to...

    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

    June 9, 2011 at 8:19 am

    #1336337

  • RE: Ideas on re writing the group by to reduce the cost of Sorting?

    Try this. It probably won't perform better, but it's easier to read and should be easier to figure out good indexes for.

    declare @fdwPeriod varchar(6)

    Set @fdwPeriod = '201104'

    select

    isnull(DRH.BusinessUnit,'[?]') as Branch

    ,isnull(DRH.UnitId,'[?]') 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

    June 9, 2011 at 8:17 am

    #1336333

  • RE: SQL Server service won't start due to the mssqlsystemresource database files not accessible

    You can't back it up or restore it anyway. It's a hidden DB.

    What does the SQL error log say?

    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

    June 9, 2011 at 7:57 am

    #1336312

Viewing 15 posts - 25,606 through 25,620 (of 49,552 total)