Forum Replies Created

Viewing 15 posts - 18,511 through 18,525 (of 49,552 total)

  • RE: DBCC CHECKDB with READONLY Filegroup(s)

    SQL_ME_RICH (5/16/2012)

    I guess I am wanting to know if I am going to need another 300+gb of disk space to create the snapshot, and then incremental amounts based on 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

    May 16, 2012 at 4:02 pm

    #1488724

  • RE: deadlocks, dbcc page object ID = 0

    Please post the DBCC page output, just the header's enough.

    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

    May 16, 2012 at 11:05 am

    #1488568

  • RE: HOW TO INSERT A RECORD IN ORDER

    A table has no definition of order, it's an unordered set. Hence there's no concept of inserting a row into a particular place.

    Even a clustered index just imposes a...

    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

    May 16, 2012 at 1:26 am

    #1488197

  • RE: dbcc checkdb Error

    Please post new questions in a new thread. thank you

    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

    May 15, 2012 at 11:47 pm

    #1488175

  • RE: Query Cost 27%

    Please post query, execution plan, table definition, index definition.

    Also, ask yourself if the scan is a problem before you spend any time thinking about it.

    http://sqlinthewild.co.za/index.php/2010/03/11/the-root-of-all-evil/

    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

    May 15, 2012 at 2:03 pm

    #1488004

  • RE: Are the posted questions getting worse?

    Evil Kraig F (5/15/2012)

    @Gail: Was being a wise-arse, thought I'd get a laugh, not boggling confusions... :hehe:

    Yeah, i figured as much, knowing you.

    And for the record... still waiting.

    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

    May 15, 2012 at 1:55 pm

    #1487998

  • RE: DBCC CHECKDB with READONLY Filegroup(s)

    Snapshots are near-instantaneous, they take very, very little time to create and they only use space = amount of changes made during their existence.

    As I mentioned, checkDB normally takes...

    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

    May 15, 2012 at 11:03 am

    #1487878

  • RE: MCSA SQL 2008

    You've got time for the MCSE data platform, the 2012 exams aren't out yet and neither are any study guides. Having written the beta, I would not suggest you try...

    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

    May 15, 2012 at 9:07 am

    #1487793

  • RE: MCSA SQL 2008

    Honestly, I'd say don't bother. Unless you know the BI stuff very well.

    This is from MS's rebranding of the certs from MCTS and MCITP to MCSA and MCSE. Rather 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

    May 15, 2012 at 8:53 am

    #1487778

  • RE: Performance effect: Calling SP in the same DB VS Calling SP from other DB

    No, there will be no effect from having procedures in DB1 vs DB2 on the same 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

    May 15, 2012 at 8:34 am

    #1487757

  • RE: DBCC CHECKDB with READONLY Filegroup(s)

    The first question is why you want to switch back to read-write? If you're planning on doing file/filegroup backups and relying on the fact that you won't need more than...

    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

    May 15, 2012 at 12:18 am

    #1487536

  • RE: Are the posted questions getting worse?

    Revenant (5/14/2012)

    You do not have to delete data, you can mark rows as inactive or obsolete, which of course allows undo.

    Which won't help an iota when a DBA connected 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

    May 14, 2012 at 5:25 pm

    #1487458

  • RE: Are the posted questions getting worse?

    Revenant (5/14/2012)

    GilaMonster (5/14/2012)

    Steve Jones - SSC Editor (5/14/2012)

    Jack Corbett (5/14/2012)

    I haven't done a backup, restore, or anythign with security since I've been there.

    Whaaa? No backups of your laptop?...

    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

    May 14, 2012 at 4:44 pm

    #1487444

  • RE: Are the posted questions getting worse?

    Steve Jones - SSC Editor (5/14/2012)

    Jack Corbett (5/14/2012)

    I haven't done a backup, restore, or anythign with security since I've been there.

    Whaaa? No backups of your laptop? None of...

    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

    May 14, 2012 at 3:01 pm

    #1487407

  • RE: Best Practice for LDF location

    The default locations for the files of new databases is not the location of model's files. It's the SQL Server default data folder and default log folder.

    Change those and any...

    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

    May 14, 2012 at 2:59 pm

    #1487406

Viewing 15 posts - 18,511 through 18,525 (of 49,552 total)