Forum Replies Created

Viewing 15 posts - 6,766 through 6,780 (of 49,552 total)

  • RE: job optimization

    http://www.sqlskills.com/blogs/paul/checkdb-from-every-angle-consistency-checking-options-for-a-vldb/

    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

    January 16, 2015 at 6:19 am

    #1770731

  • RE: Debugging SQL Server

    call.copse (1/16/2015)

    I'm still a PRINT and temp table guy I'm afraid :blush: feels quite stone age but you know where you stand.

    Stone age, but it works. I'm there too. Print,...

    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

    January 16, 2015 at 6:02 am

    #1770728

  • RE: Debugging SQL Server

    evgeny.marmalstein (1/16/2015)

    But. if log to temp table and rollback occurs, then you lost the log. And during rollbacks the most important logs.

    Log to a table variable and then, after any...

    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

    January 16, 2015 at 6:01 am

    #1770727

  • RE: Best training resource test preparation for Exam 70-461?

    Alternately, go to the MS web site, get the 'skills measured' list and use Books Online.

    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

    January 16, 2015 at 5:52 am

    #1770726

  • RE: Are the posted questions getting worse?

    Brandie Tarvin (1/16/2015)

    GilaMonster (1/15/2015)

    Sean Lange (1/15/2015)

    I am having a discussion with somebody who swears that using

    EXISTS(select 1

    is way faster than just select *. I know Gail has an article...

    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

    January 16, 2015 at 5:42 am

    #1770722

  • RE: Are the posted questions getting worse?

    Sean Lange (1/15/2015)

    I am having a discussion with somebody who swears that using

    EXISTS(select 1

    is way faster than just select *. I know Gail has an article on her blog...

    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

    January 15, 2015 at 11:43 pm

    #1770643

  • RE: Column not covered by index: new index or add to existing

    In this case, you want to find an existing index that has BUSINESS_PROCESS_STATUS as the leading key column and then add the new column as a key column.

    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

    January 15, 2015 at 11:46 am

    #1770531

  • RE: Can't start 2008R2 from command prompt

    Not the system event log. The application event log.

    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

    January 15, 2015 at 8:18 am

    #1770479

  • RE: Can't start 2008R2 from command prompt

    What does the application event 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

    January 15, 2015 at 8:02 am

    #1770469

  • RE: Can't start 2008R2 from command prompt

    Is the service named "Express2008"? That's not the default for Express.

    What are the command-line parameters for 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

    January 15, 2015 at 7:47 am

    #1770462

  • RE: Can't start 2008R2 from command prompt

    thedavegray (1/15/2015)

    Yes the service is still running.

    Well there's your problem.

    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

    January 15, 2015 at 7:35 am

    #1770458

  • RE: Can't start 2008R2 from command prompt

    Is the service still running at this point?

    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

    January 15, 2015 at 7:21 am

    #1770448

  • RE: Inconsistency error

    Please post the entire, unedited output of

    DBCC CheckDB(<database name>) with no_infomsgs, all_errormsgs

    If you restored and there's still corruption, it means that the database was corrupt at the time the backup...

    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

    January 15, 2015 at 6:15 am

    #1770434

  • RE: log shipping bandwith estimation and backup size estimation

    That'll work as an average, but only as an average. Different data, different types of data will compress differently.

    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

    January 15, 2015 at 3:51 am

    #1770376

  • RE: What are First Steps for a dba in new Office?

    The backups.

    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

    January 15, 2015 at 2:55 am

    #1770369

Viewing 15 posts - 6,766 through 6,780 (of 49,552 total)