Forum Replies Created

Viewing 15 posts - 33,931 through 33,945 (of 49,552 total)

  • RE: Getting Cache Flush messages on sql 2005 standby server during restore of transaction log

    The caches are flushed whenever a restore occurs. This includes restores of transaction logs.

    It might be something to worry about if you're using the secondary as a reporting server, but...

    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

    February 18, 2010 at 9:17 am

    #1120993

  • RE: Backup and Recovery - What are two options to validate whether or not a SQL Server backup will restore successfully?

    Joy Smith San (2/18/2010)

    .....has got 585 points in this forum.... 🙂

    You get points from correctly answering the Question of the Day as well.

    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

    February 18, 2010 at 9:01 am

    #1120984

  • RE: Emergency!!!!!!!! Production Databases

    dennisengel (2/18/2010)

    Yes, i can connect using SSMS. However in object explorer details i see only database names i don't see any details for these databases.

    If you open a query window...

    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

    February 18, 2010 at 9:00 am

    #1120981

  • RE: Shrink TempDB considerations & impact

    Read the entire of this kb article carefully. Especially the section "Effects of Execution of DBCC SHRINKDATABASE or DBCCSHRINKFILE While Tempdb Is In Use"

    http://support.microsoft.com/kb/307487

    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

    February 18, 2010 at 5:57 am

    #1120840

  • RE: system_seeks, system_scans and system_lookups

    What do you mean? How are they different from 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

    February 18, 2010 at 5:54 am

    #1120837

  • RE: Record metadata and IsDeleted?

    Dave Winchester (2/18/2010)

    Thanks for the response. My question about the CreatedDate, CreatedBy...columns - was more along the lines of "Should I have them?" in a social networking site with 100K+...

    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

    February 18, 2010 at 5:44 am

    #1120831

  • RE: Are the posted questions getting worse?

    GilaMonster (2/18/2010)

    Gianluca Sartori (2/18/2010)

    I've been spending some time trying to make it return rows in a different order, but I did not succeed. Does anybody have a script to 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

    February 18, 2010 at 4:39 am

    #1120798

  • RE: Are the posted questions getting worse?

    Gianluca Sartori (2/18/2010)

    I've been spending some time trying to make it return rows in a different order, but I did not succeed. Does anybody have a script to do 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

    February 18, 2010 at 4:30 am

    #1120789

  • RE: Are the posted questions getting worse?

    Paul White (2/18/2010)

    Oh dear, I posted a reply to that identity-order thread before checking here :ermm:

    If I'm reading the q correctly, he wants the data in the identity order, but...

    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

    February 18, 2010 at 4:22 am

    #1120783

  • RE: Recover a database to its maximum from a full backup and ldf file

    Did you detach it?

    DB doesn't have to be accessible. Just listed as a database in SQL (ie must be listed in elect name from sys.databases )

    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

    February 18, 2010 at 3:05 am

    #1120750

  • RE: Are the posted questions getting worse?

    Gianluca Sartori (2/18/2010)

    In that particular case, with the identity column as primary key clustered, yes, doesn't it?

    Logical order of the index - yes

    Physical order of the data - no

    Order 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

    February 18, 2010 at 2:26 am

    #1120742

  • RE: Are the posted questions getting worse?

    Gianluca Sartori (2/18/2010)

    Looks like somebody can't stay away from corruption threads...

    We don't even know if there is any corruption there. There's nothing I could see in the errors posted 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

    February 18, 2010 at 2:19 am

    #1120738

  • RE: Recover a database to its maximum from a full backup and ldf file

    If the recovery model is full and the recovery model has not been changed since that full backup, if no one has ever truncated the transaction log and if 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

    February 18, 2010 at 2:18 am

    #1120735

  • RE: Locks on select statements why?

    koteswara kishore K. (2/18/2010)

    As per the Microsoft SQL Server 2008 concern select statements and join tables(source tables) will not affect with any locks.

    Locks get applied to any 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

    February 18, 2010 at 1:27 am

    #1120705

  • RE: Emergency!!!!!!!! Production Databases

    If you try to connect via management studio, what error do you get?

    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

    February 18, 2010 at 1:25 am

    #1120704

Viewing 15 posts - 33,931 through 33,945 (of 49,552 total)