Forum Replies Created

Viewing 15 posts - 13,456 through 13,470 (of 49,552 total)

  • RE: SQL Server service account locked

    No, you can't access the Active Directory list of logins and users via T-SQL.

    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

    April 17, 2013 at 12:38 am

    #1607131

  • RE: Restore Transactional Log Backup

    pm.praveen.mehta89 (4/17/2013)

    Hi,

    For restoring a db from transactional backup first u need to restore latest full backup with 'RESTORE WITH RECOVERY' option then transactional log backups(except latest transactional backup) in sequence...

    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

    April 17, 2013 at 12:14 am

    #1607122

  • RE: SQL Server service account locked

    Speak to your AD team, ask them to set the account to not allow interactive logins (users should not be using the service account) and ask them if they can...

    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

    April 17, 2013 at 12:10 am

    #1607120

  • RE: view more efficient than before or not?

    sqlfriends (4/16/2013)

    I have a view, if we runs it individually in SSMS, it runs ok, but we have a batch process at night that uses it for each individual. so...

    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

    April 16, 2013 at 11:59 pm

    #1607118

  • RE: performance benefit of separating LOG and DATA path

    Recovery model has nothing to do with it, the log is used almost the same (baring only minimally logged operations) in all three recovery models.

    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

    April 16, 2013 at 3:21 pm

    #1607062

  • RE: performance benefit of separating LOG and DATA path

    Maybe. Depends whether those are separate IO paths or not, whether the DB is IO bottlenecked or 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

    April 16, 2013 at 3:08 pm

    #1607057

  • RE: Are the posted questions getting worse?

    GilaMonster (4/16/2013)

    SQLRNNR (4/16/2013)

    Did it come with the NOS tanks?

    Nosferatu? Don't think the car has energy vamps fitted. Will have to check the manual.

    Or wrong game slang?

    I'll pass thanks, petrol's fine.

    Oh,...

    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

    April 16, 2013 at 1:35 pm

    #1607019

  • RE: Are the posted questions getting worse?

    SQLRNNR (4/16/2013)

    Did it come with the NOS tanks?

    Nosferatu? Don't think the car has energy vamps fitted. Will have to check the manual.

    Or wrong game slang?

    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

    April 16, 2013 at 12:56 pm

    #1607004

  • RE: Fatal error 824

    If you need specific advice, please start a new thread in the appropriate forum (based on SQL version) and post the output of the 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

    April 16, 2013 at 12:48 pm

    #1606996

  • RE: Are the posted questions getting worse?

    Lynn Pettis (4/16/2013)

    jasona.work (4/16/2013)

    Three days of nothing...

    It's quiet...

    TOO quiet...

    Either nobody has had any complaints, nor needed someone to jump into an issue, or else everyone is just to darn busy...

    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

    April 16, 2013 at 12:16 pm

    #1606974

  • RE: Small doubt

    http://sqlinthewild.co.za/index.php/2009/02/19/estimated-and-actual-execution-plan-revisited/

    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

    April 16, 2013 at 11:56 am

    #1606958

  • RE: What does "SET XACT_ABORT ON" mean?

    http://sqlinthewild.co.za/index.php/2011/05/17/on-transactions-errors-and-rollbacks/

    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

    April 16, 2013 at 11:22 am

    #1606940

  • RE: What does "SET XACT_ABORT ON" mean?

    adonetok (4/16/2013)

    So, in my understading that "SET XACT_ABORT ON" should add all time.

    If you want SQL to automatically roll back transactions in case of an error. Personally it's a setting...

    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

    April 16, 2013 at 9:58 am

    #1606892

  • RE: No of rows in Temporary Table

    Exactly the same answer.

    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

    April 16, 2013 at 12:37 am

    #1606709

  • RE: No of rows in Temporary Table

    The only limit is the size of your storage, or the maximum database size (524,272 TB, which is beyond any storage you're likely to have)

    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

    April 16, 2013 at 12:04 am

    #1606699

Viewing 15 posts - 13,456 through 13,470 (of 49,552 total)