Forum Replies Created

Viewing 15 posts - 21,721 through 21,735 (of 49,552 total)

  • RE: After cancelling SQL job database stuck in restoring state

    logicinside22 (12/14/2011)

    Is there any other way rather than to DROP?

    You can try RESTORE WITH RESTART, but unless the restore time is horrendous, probably unnecessary. The option's intended for absolutely huge...

    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

    December 14, 2011 at 2:23 pm

    #1421622

  • RE: Can we have multiple Secondary servers in Mirroring?

    Not with SQL 2005 or SQL 2008 database mirroring. Single principal, single mirror, optional witness. The new Always On Availability Groups in SQL 2012 will allow multiple secondaries (new feature,...

    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

    December 14, 2011 at 2:21 pm

    #1421620

  • RE: Log File out of control

    alanspeckman (12/14/2011)

    Thank you both, I had never heard of this method. but I assume it was a triage method when out of disk space, accepting the risk of loosing point-in-time...

    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

    December 14, 2011 at 2:17 pm

    #1421619

  • RE: Does alter index rebuild cause sp recompile?

    sroumel (12/14/2011)

    Maybe it doesn't matter,

    rebuild index triggers update statistics and then the plan recompiles

    Rebuild doesn't trigger update stats, it does the update as part of the index rebuild, plans...

    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

    December 14, 2011 at 2:14 pm

    #1421616

  • RE: Filter the contribution center

    Frankly I usually just use google. In this case I'm only looking for my own articles, which should be easy to fine. They used to be, before the blog change.

    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

    December 14, 2011 at 2:12 pm

    #1421614

  • RE: After cancelling SQL job database stuck in restoring state

    Drop the database and start the restore from scratch.

    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

    December 14, 2011 at 1:29 pm

    #1421582

  • RE: Does alter index rebuild cause sp recompile?

    okbangas (12/14/2011)

    Just curious, is this since associated statistics is updated?

    I can't remember if it gets flagged as a schema modification recompile or a statistics-based recompile. It's easy to test though,...

    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

    December 14, 2011 at 1:27 pm

    #1421579

  • RE: Does alter index rebuild cause sp recompile?

    Yes. If the plan used the index and the index was rebuild, the plan must recompile on next execution.

    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

    December 14, 2011 at 12:43 pm

    #1421547

  • RE: Uncommitted transactions?

    http://www.sqlservercentral.com/articles/Transaction+Log/72488/

    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

    December 14, 2011 at 12:11 pm

    #1421532

  • RE: Error changing a varchar column to allow nulls

    🙂

    I'm sure we've all done that a few times.

    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

    December 14, 2011 at 12:02 pm

    #1421525

  • RE: Are the posted questions getting worse?

    Stefan Krzywicki (12/14/2011)

    Here I go asking for opinions again

    Does anyone know about configuring your sql server on a SAN? Or have opinions about the best place to put the files?

    Everyone...

    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

    December 14, 2011 at 12:02 pm

    #1421524

  • RE: Error changing a varchar column to allow nulls

    clbast (12/14/2011)

    After dropping Default Value and Check Constraints on that field, I tried changing it to allow NULLs by running this statement:

    ALTER TABLE dbo.Assessment ALTER COLUMN AssessedWithParcel int NULL

    I think...

    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

    December 14, 2011 at 11:14 am

    #1421490

  • RE: encrypt backup

    The only way to encrypt backups natively is to encrypt the entire database with TDE (transparent database encryption). That is an Enterprise only feature.

    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

    December 14, 2011 at 10:43 am

    #1421468

  • RE: Full Backups - Snapshot - Tlogs- Chain is broke ..Please help!!

    Full backups do two things.

    Clear all the bits on the DIFF map pages. Set the value of the differential base LSN in the database header. That's the LSN of 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

    December 14, 2011 at 10:41 am

    #1421466

  • RE: Log File out of control

    alanspeckman (12/14/2011)

    Does anyone see a problem with this method?

    Absolutely yes.

    Also, another DBA told me he does the same thing as Tom, but he doesn't do the "full 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

    December 14, 2011 at 8:52 am

    #1421380

Viewing 15 posts - 21,721 through 21,735 (of 49,552 total)