Forum Replies Created

Viewing 15 posts - 376 through 390 (of 612 total)

  • RE: recovery model simple

    George M Parker (11/4/2013)

    GilaMonster (11/4/2013)

    kevaburg (11/4/2013)

    Just to clarify.....In SIMPLE recovery mode, transactions are cleared once they are committed,

    In simple recovery, the log is marked reusable by a checkpoint, not a...

    November 5, 2013 at 12:42 am

    #1664049

  • RE: recovery model simple

    George M Parker (11/2/2013)

    Simple recovery allows the log file to be cleared of transactions without having to take a backup of the transaction log. Regardless, it will still grow if...

    November 4, 2013 at 2:59 am

    #1663754

  • RE: How to undo Drop Table Statement

    Koen Verbeeck (10/20/2013)

    kevaburg (10/19/2013)

    Richard Warr (10/18/2013)

    Alternatively, petition for the UNDROP TABLE command to be introduced in SQL Server 2016.

    Hope you found a way to get the table recreated from somewhere.

    Personally...

    October 21, 2013 at 12:44 am

    #1660034

  • RE: Recovery senarios

    amitsdba (10/18/2013)

    Good evening all,

    I am new to sql sever admin .I want to clarify few recovery scenarios.

    1)if i take weekly full backup on sunday at 10 PM.and daily i take...

    October 19, 2013 at 11:26 am

    #1659926

  • RE: Profiler

    cdl_9009 (10/18/2013)

    This may not fit this category.

    Does anybody know how to create a template in SQL Profiler 2008r2 that would allow you to use that on a 2012 server?

    I Profiler...

    October 19, 2013 at 11:23 am

    #1659925

  • RE: How to undo Drop Table Statement

    Richard Warr (10/18/2013)

    Alternatively, petition for the UNDROP TABLE command to be introduced in SQL Server 2016.

    Hope you found a way to get the table recreated from somewhere.

    Personally I would like...

    October 19, 2013 at 11:20 am

    #1659924

  • RE: How to undo Drop Table Statement

    hoseam (10/18/2013)

    I don't have a backup

    Is it also safe to assume that you have no snapshots? Or a copy of the database somewhere else that you can copy the...

    October 19, 2013 at 11:18 am

    #1659923

  • RE: user permissions to only for view

    $w@t (10/9/2013)

    after login with taht user i can see systemtables,system stored procedures,another users(even i can modify it) under particular database...but i want to restrict that..

    If you map the user to...

    October 13, 2013 at 4:23 am

    #1658105

  • RE: dm_db_session_space_usage and tempdb

    Just as a side note for myself, how is your tempdb configured? Is it possible that this person appears to be "abusing" it with bad queries but maybe the...

    October 13, 2013 at 4:19 am

    #1658104

  • RE: Fragmentation doesn't changes after index rebuilding

    Alan.B (10/11/2013)

    sandeep singh-337370 (10/11/2013)

    Guys,

    One of the other project's guys in my company asked me to improve the performance of their databases.

    Keeping your indexes un-fragmented will help performance. That said,...

    October 13, 2013 at 4:15 am

    #1658103

  • RE: calculate database size

    saso_yns (10/8/2013)

    ??? ??? ???? ??????

    ??? ??? ??? ??? ???????

    ??? ??? ??? ??? ??????

    ahhhhh......Everything seems so much clearer now....:-D

    October 9, 2013 at 12:18 am

    #1656994

  • RE: Prevent backups on C:\ drive?

    Jeff Moden (10/1/2013)

    Kurt W. Zimmerman (10/1/2013)

    kevaburg (10/1/2013)

    Kurt W. Zimmerman (10/1/2013)

    I think the resolution is more a function of control. As a DBA restrict access to those developers who don't at...

    October 1, 2013 at 7:51 am

    #1654913

  • RE: Prevent backups on C:\ drive?

    Kurt W. Zimmerman (10/1/2013)

    I think the resolution is more a function of control. As a DBA restrict access to those developers who don't at by the rules. Make them come...

    October 1, 2013 at 6:18 am

    #1654856

  • RE: Prevent backups on C:\ drive?

    Jeffrey Williams 3188 (9/29/2013)

    In addition to which drive backups are performed - I really need to be able to block someone from taking native backups on some of my systems.

    I...

    September 29, 2013 at 9:34 am

    #1654340

  • RE: Five Rules For Sucessful Conversations With DBAs

    dkrasnikov (9/29/2013)

    kevaburg (9/28/2013)

    dkrasnikov (9/28/2013)

    eddie.caplan (9/24/2013)

    Joshua Feierman seems to think the developers are supplicants, pleading for help. In fact, the DBA should think of the developers as his customers, and...

    September 29, 2013 at 8:58 am

    #1654337

Viewing 15 posts - 376 through 390 (of 612 total)