Forum Replies Created

Viewing 15 posts - 25,621 through 25,635 (of 49,552 total)

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

    Does the file exist? Does SQL have permission to that folder?

    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:34 am

    #1336289

  • RE: SQL Server has encountered 16 occurrence(s) of cachestore flush

    Restores, including log restores, clear the plan cache.

    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:10 am

    #1336257

  • RE: need to learn how to be a DBA

    mike.mcquillan (6/9/2011)

    PS You have to pass 70-432 before you can take 70-450.

    You can write them in any order (I wrote 450 before 432) but you'll only get the ITP cert...

    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:09 am

    #1336254

  • RE: Changing recovery model

    What do you gain by that? Other than ensuring that if the full backup is damaged you have NO recovery path.

    Please read through this - Managing Transaction Logs[/url]

    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:08 am

    #1336252

  • RE: Are the posted questions getting worse?

    Gianluca Sartori (6/9/2011)

    GilaMonster (6/9/2011)

    Is this person irritating anyone else, or am I just in low-tolerance mode at the moment?

    http://www.sqlservercentral.com/Forums/UserInfo635080.aspx

    Not yet, really.

    Is there a particular thread where he crossed 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 3:43 am

    #1336124

  • RE: Changing recovery model

    muthukkumaran Kaliyamoorthy (6/9/2011)

    In bulk logged PTR is not possible.

    Not true.

    In bulk-logged recovery point in time recovery is possible unless there is a minimally logged operation within the log backup 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

    June 9, 2011 at 3:43 am

    #1336122

  • RE: Changing recovery model

    Probably not. In simple and bulk-logged, some operations are minimally logged. In full recovery they are fully logged.

    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 3:08 am

    #1336105

  • RE: Are the posted questions getting worse?

    Is this person irritating anyone else, or am I just in low-tolerance mode at the moment?

    http://www.sqlservercentral.com/Forums/UserInfo635080.aspx

    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 3:07 am

    #1336104

  • RE: I have a stored procedure that I need to pass a parameter into a case statement with IN in the the where

    Dynamic 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

    June 9, 2011 at 3:00 am

    #1336098

  • RE: Changing recovery model

    No testing, just make sure you manage the 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

    June 9, 2011 at 2:59 am

    #1336097

  • RE: Full or Simple mode SQL backup

    Please read through this - Managing Transaction Logs[/url]

    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 2:59 am

    #1336096

  • RE: What is WOW64

    You know, you'd likely learn a lot faster if you research first and ask later.

    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 1:33 am

    #1336067

  • RE: Why compatibilty level is important

    http://www.google.com/search?q=%22compatibility+level%22

    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 1:31 am

    #1336066

  • RE: Are the posted questions getting worse?

    Stefan Krzywicki (6/8/2011)

    Kit G (6/8/2011)

    Wearing boots with a kilt isn't a problem (as long as we have socks). But sandals and a kilt? Perhaps... maybe... in a Roman...

    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 1:29 am

    #1336065

  • RE: How does setting databaseproperty 'isbulkcopy' to 'TRUE' work in simple recovery model

    As per Books Online:

    select into/bulkcopy

    Starting with Microsoft SQL Server 2000, if the recovery model of the database is currently set to FULL, using the select into/bulkcopy option resets...

    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 8, 2011 at 10:55 am

    #1335820

Viewing 15 posts - 25,621 through 25,635 (of 49,552 total)