Forum Replies Created

Viewing 15 posts - 7,186 through 7,200 (of 49,552 total)

  • RE: Problem in the differential backup

    cpd 60311 (11/26/2014)

    But can be specific.

    ??

    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

    November 27, 2014 at 1:19 am

    #1761213

  • RE: Shrinking Database for Dev Environment

    peteroc (11/26/2014)

    Hi Jeff,

    I'm with you regarding the adding more disk space but It's not my decision and I have to explore the options. I also think it's complicated by 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

    November 27, 2014 at 1:18 am

    #1761211

  • RE: Problem in the differential backup

    Just double-check quickly that your server admin doesn't have something set 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

    November 26, 2014 at 11:20 am

    #1761155

  • RE: timestamp - Paging

    Query Shepherd (11/26/2014)

    OK. Thanks Gail. And what about the explanation?

    Errr... what explanation?

    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

    November 26, 2014 at 9:00 am

    #1761127

  • RE: timestamp - Paging

    Order of columns doesn't matter in a table.

    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

    November 26, 2014 at 8:35 am

    #1761115

  • RE: Second Delimiter and converting

    You might want to post this in an Oracle forum. This site is for Microsoft SQL Server, while we'll be able to get you a T-SQL function to do what...

    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

    November 26, 2014 at 6:10 am

    #1761069

  • RE: bugs report on SQL2014 RTM

    Depends what index gets affected by this bug. Clustered = data.

    But it doesn't matter, because you're going to apply the CU and hence won't be at 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

    November 26, 2014 at 6:07 am

    #1761068

  • RE: Problem in the differential backup

    Are you using some other form of full backup as well? SAN Snapshot? BackupExec? Something else?

    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

    November 26, 2014 at 5:07 am

    #1761052

  • RE: database stages

    What exactly do you mean?

    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

    November 26, 2014 at 5:05 am

    #1761049

  • RE: Executing stored procedure as different user

    Adding WITH EXECUTE AS OWNER means the contents of that procedure (and only the contents of that procedure) runs as the procedure's owner, probably dbo.

    The permission missing is 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

    November 26, 2014 at 4:50 am

    #1761045

  • RE: Log corruption. Why?

    Yes, the messages saying what's wrong with the file and why SQL is marking the database suspect.

    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

    November 26, 2014 at 4:48 am

    #1761044

  • RE: Problem in the differential backup

    Any chance you could translate that error?

    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

    November 26, 2014 at 4:47 am

    #1761043

  • RE: Log corruption. Why?

    The error log is more likely to have useful information than the transaction log.

    Corruption is usually IO subsystem

    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

    November 26, 2014 at 3:27 am

    #1761025

  • RE: SQL Server Database Disaster Recovery

    Absolutely.

    1) Identify your SLAs

    2) Identify what needs to be included in the DR plan

    3) Craft a plan to meet the above requirements.

    If you're not comfortable putting something so critical together...

    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

    November 26, 2014 at 3:25 am

    #1761023

  • RE: tempDB queries

    Probably easier to look in the transaction and lock DMVs

    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

    November 26, 2014 at 2:31 am

    #1761008

Viewing 15 posts - 7,186 through 7,200 (of 49,552 total)