Forum Replies Created

Viewing 15 posts - 11,746 through 11,760 (of 49,552 total)

  • RE: DBCC checkdb lifecycle

    Benki Chendu (9/9/2013)

    GilaMonster (8/26/2013)

    Firstly why did you repair rather than restoring a clean backup? Repair is typically the last resort, not the first solution.

    Do you know how much data...

    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

    September 9, 2013 at 4:25 am

    #1648492

  • RE: Reindex script alteration

    If you print the command rather than exec, what prints out?

    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

    September 9, 2013 at 4:24 am

    #1648491

  • RE: windows os edition support for log shipping

    All of them should. There's no windows OS feature requirements for log shipping.

    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

    September 8, 2013 at 11:53 am

    #1648395

  • RE: Are the posted questions getting worse?

    Jan Van der Eecken (9/8/2013)

    Now why TF would they do that? Paul is one of the very few guys I totally respect.

    Anonymous. Need for attention. Fun (for them). Who knows.

    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

    September 8, 2013 at 11:02 am

    #1648393

  • RE: HOW TO STORE THE PROCEDURE VALUES TO TABLE VARIABLE

    INSERT INTO @TableVariable

    EXEC StoredProcedure

    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

    September 8, 2013 at 12:23 am

    #1648374

  • RE: No More MCM

    L' Eomot Inversé (9/7/2013)

    The connect item has now disappeared.

    I think someone at MS doesn't like being told they screwed up.

    It was removed at Jen's request because a small number 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

    September 8, 2013 at 12:19 am

    #1648373

  • RE: Are the posted questions getting worse?

    Jan Van der Eecken (9/7/2013)

    And, as to be expected, Gail's presentation on "Do's and Don'ts of Database Corruption" was top of the cream. Thanks, Gail!

    You're welcome.

    And now, as a reward,...

    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

    September 7, 2013 at 12:39 pm

    #1648343

  • RE: Principal server unexpected shutdown?

    SQLisAwE5OmE (9/7/2013)

    However, if your mirror is in high performance mode and if principal goes down, then definitely there will be some data loss.

    Not definitely. There may be some data loss....

    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

    September 7, 2013 at 10:43 am

    #1648338

  • RE: Database Password Protected

    Don't use sa. Use specific accounts for specific users with minimal permissions. Strong passwords or preferably windows authentication.

    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

    September 7, 2013 at 5:58 am

    #1648317

  • RE: Database Password Protected

    Minimum permissions on logins, don't give everyone sa.

    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

    September 7, 2013 at 5:19 am

    #1648307

  • RE: Database Password Protected

    There's no way to password protect a database, passwords are used on logins to SQL Server, if someone has a valid login, they can then see any databases they've been...

    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

    September 7, 2013 at 4:39 am

    #1648303

  • RE: Path to a Database Architect

    It's a low-level certification that tests basic database design concepts.

    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

    September 7, 2013 at 1:57 am

    #1648293

  • RE: Too Much Unused Space A Performance Issue?

    Jon.Morisi (9/6/2013)

    Does it cause a performance issue to have a lot of unused space.

    No.

    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

    September 7, 2013 at 12:03 am

    #1648287

  • RE: It's not you; it's us

    Grant Fritchey (9/6/2013)

    Steven.Howes (9/6/2013)

    8 out of 10? really? That's insane. I can't believe that many people would try to cheat and screw their employers by taking 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

    September 6, 2013 at 2:25 pm

    #1648240

  • RE: sp_UpdateStats missing in database

    That procedure isn't in a user database. It's in the system resource database and, because it's a system procedure, can be called from anywhere.

    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

    September 6, 2013 at 1:08 pm

    #1648212

Viewing 15 posts - 11,746 through 11,760 (of 49,552 total)