Forum Replies Created

Viewing 15 posts - 33,406 through 33,420 (of 49,552 total)

  • RE: Unable to open 2008 file in 2005

    dean gross (3/18/2010)

    Thanks, the backup/restore worked.

    Could you explain more what you did? A backup of a 2008 database cannot be restored on a 2005 server.

    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

    March 18, 2010 at 2:40 pm

    #1136312

  • RE: Disable foreign keys

    Nik Desai (3/18/2010)

    you can disable the constraint

    ALTER TABLE 'table name' NOCHECK CONSTRAINT all

    ALTER TABLE 'table name' DISABLE TRIGGER all

    Disabling the constraint is 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

    March 18, 2010 at 1:41 pm

    #1136266

  • RE: transaction log restore question

    Lynn Pettis (3/18/2010)

    The only other question then would be how long do you retain the snap shots? If you keep them too long, you will mostly start to experience...

    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

    March 18, 2010 at 1:37 pm

    #1136262

  • RE: transaction log restore question

    GTR (3/18/2010)

    Snapshot is good only is you know which table\data is modified. What If two or more DDL\DML changes were made during time frame (5:00 and 5:05) and you want...

    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

    March 18, 2010 at 1:32 pm

    #1136259

  • RE: date

    DECLARE @StartDate DATETIME

    SET @StartDate = '2010/03/01'

    SELECT DATEADD(dd,-1,DATEADD(mm,1,@StartDate))

    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

    March 18, 2010 at 1:12 pm

    #1136240

  • RE: Refusal to perform a log backup

    It is due to the read-only mode. The info on whether there has been a backup since the last break in the log chain is stored in the database header...

    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

    March 18, 2010 at 1:02 pm

    #1136234

  • RE: Are the posted questions getting worse?

    Grant Fritchey (3/18/2010)

    Remember, MVP is about service to the community. Some, like Gail or Jeff, have near encyclopedic knowledge of SQL Server. Others don't. Just because an MVP says something...

    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

    March 18, 2010 at 12:41 pm

    #1136218

  • RE: Hourly backups + Weekly full = Overlap = problems???

    No, bulk-logged retains tran log chain. That's why you can switch from full to bulk and back and the log's intact.

    Full recovery = log retained, all operations fully logged

    Bulk 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

    March 18, 2010 at 11:30 am

    #1136181

  • RE: Hourly backups + Weekly full = Overlap = problems???

    jpSQLDude (3/18/2010)

    Do you think it makes any difference if you switch to Simple, then take a Full backup, then switch to Full Recovery Model; or switch from Full 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

    March 18, 2010 at 11:23 am

    #1136177

  • RE: Are the posted questions getting worse?

    It's only teaching if the other person is willing to learn. At the moment he doesn't appear to be. Same person who spent 4 pages justifying why posting a solution...

    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

    March 18, 2010 at 9:42 am

    #1136078

  • RE: Hourly backups + Weekly full = Overlap = problems???

    jpSQLDude (3/18/2010)

    So is there any way to tell SQL, "Yo. Ignore all backups that have ever happened, reset to 0, all backups have been deleted, so this next Full...

    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

    March 18, 2010 at 9:19 am

    #1136049

  • RE: TSQL using parameters does not use the index

    Sorry Tom, one question.

    You say there'll be 800 000 rows with the same batchID, but in the exec plan, actual row count was 0. Should it have been 0?

    Also, if...

    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

    March 18, 2010 at 8:57 am

    #1136025

  • RE: Query cost = 150%

    It's not particularly uncommon. I had a set of queries whose total cost added to 200% the other day. I think it's Kevin (TheSQLGuru) who has a plan somewhere with...

    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

    March 18, 2010 at 8:35 am

    #1136003

  • RE: TSQL using parameters does not use the index

    stefan.gustafsson 60897 (3/18/2010)

    Just curious: What do you expect to find in the actual execution plan that might affect the solution ? In this case we already know that he gets...

    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

    March 18, 2010 at 8:13 am

    #1135984

  • RE: TSQL using parameters does not use the index

    stefan.gustafsson 60897 (3/18/2010)

    I find it is more helpful to suggest solutions rather than saying what not to do.

    I'll be very happy to give a solution once the actual execution plan...

    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

    March 18, 2010 at 7:57 am

    #1135966

Viewing 15 posts - 33,406 through 33,420 (of 49,552 total)