Forum Replies Created

Viewing 15 posts - 31,291 through 31,305 (of 49,552 total)

  • RE: Cross editions back-restore in sql server 2008

    Should be possible. What were the errors?

    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

    August 11, 2010 at 12:51 pm

    #1205661

  • RE: RESTORE

    sqlbee19 (8/11/2010)

    But to apply this diff I need to retore full backup with norecovery and apply diff backup with recovery and this will kill my whole day....

    Yes, you do.

    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

    August 11, 2010 at 12:18 pm

    #1205629

  • RE: Are the posted questions getting worse?

    CirquedeSQLeil (8/11/2010)

    One I like from South Africa is Hluhluwe. And yes I had no clue the first time I saw it.

    Yeah, that one is hilarious. I'll give people...

    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

    August 11, 2010 at 12:04 pm

    #1205609

  • RE: uncommited transactions

    Have a look at this discussion - http://www.sqlservercentral.com/Forums/Topic967002-146-1.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

    August 11, 2010 at 12:00 pm

    #1205603

  • RE: SQL LOGFILE- how much is committed and uncommitted?

    iqtedar (8/11/2010)

    like can i shrink the 1 gb ldf to less than 200.

    No, because there's 200MB of the log in use.

    We have a process which shrinks log file before...

    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

    August 11, 2010 at 11:52 am

    #1205594

  • RE: Are the posted questions getting worse?

    I asked this to several people at the PASS summit last year. No one (other the ex-South African) got it even close to right.

    How do you pronounce "Gauteng"?

    For extra credit..

    How...

    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

    August 11, 2010 at 11:51 am

    #1205591

  • RE: MAXDOP - How many CPU's does it use

    iqtedar (8/11/2010)

    i) if MAXDOP is zero - cost threshold value doesnt matter since sql engine will push the query to all the processsors right?

    No. The cost threshold determines when 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

    August 11, 2010 at 11:40 am

    #1205578

  • RE: select count(*) or select count(OrderID)

    CELKO (8/11/2010)

    The table row count (NOT records! quit thinking this is a mag tape file system) is available at the table level, so three is no need to scan 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

    August 11, 2010 at 11:37 am

    #1205575

  • RE: SQL 2005 Log - To Full Backup Gap

    If you are restoring the 9pm full backup, then the 11pm log backup, yes.

    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

    August 11, 2010 at 9:54 am

    #1205483

  • RE: SQL 2005 Log - To Full Backup Gap

    AndrewSQLDBA (8/11/2010)

    There is no need to worry about the 5pm log backup if you just took a Full backup later. You will have all the data that you need in...

    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

    August 11, 2010 at 9:50 am

    #1205476

  • RE: SQL 2005 Log - To Full Backup Gap

    If you restore the full backup, then apply the log backup SQL will use the LSNs (Log Sequence numbers) of the full backup and the transactions in the log 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

    August 11, 2010 at 9:50 am

    #1205475

  • RE: SQL 2005 Log - To Full Backup Gap

    rickK_ (8/11/2010)

    My concern is with restoring the 11pm log backup after the full backup at 9pm. If would contain log data prior to the 9pm full backup.

    Yes, it would....

    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

    August 11, 2010 at 9:34 am

    #1205456

  • RE: select count(*) or select count(OrderID)

    http://sqlinthewild.co.za/index.php/2009/04/14/on-counts/

    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

    August 11, 2010 at 8:57 am

    #1205413

  • RE: Can I use a saved execution plan?

    Peter Trast (8/11/2010)

    But some students want the option!! 🙂

    Yeah, I know. Please just make sure if you're teaching this, also teach them why this is not something that one should...

    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

    August 11, 2010 at 8:21 am

    #1205382

  • RE: Differences between SQL Server 2008 and SQL Server 2008 R2

    R2 is a new version (like 2008 from 2005) and new licences must be purchased if you wish to upgrade.

    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

    August 11, 2010 at 8:08 am

    #1205372

Viewing 15 posts - 31,291 through 31,305 (of 49,552 total)