Forum Replies Created

Viewing 15 posts - 61 through 75 (of 373 total)

  • RE: Big transaction log file

    Jeff Moden (2/18/2014)

    cygne17_2 77208 (2/18/2014)

    Hi,

    I found a sql server database with a transaction log file of 65 GB.

    The database is configured with the recovery model option = full.

    Also, I noticed...

    Kurt W. Zimmerman
    SR DBA
    Lefrak Organization
    New York, NY

    http://www.linkedin.com/in/kurtwzimmerman

    February 19, 2014 at 8:39 am

    #1690325

  • RE: Today's Random Word!

    crookj (2/19/2014)

    WotD - tedium

    boring

    Kurt W. Zimmerman
    SR DBA
    Lefrak Organization
    New York, NY

    http://www.linkedin.com/in/kurtwzimmerman

    February 19, 2014 at 8:27 am

    #1690320

  • RE: Today's Random Word!

    Ed Wagner (2/13/2014)

    crookj (2/13/2014)

    Ed Wagner (2/13/2014)

    BWFC (2/13/2014)

    TomThomson (2/12/2014)

    SQLRNNR (2/12/2014)

    parsnip

    butter (familiam non alunt verba)

    Dairy

    Cream

    Crispy

    Caramelized

    Browning

    Kurt W. Zimmerman
    SR DBA
    Lefrak Organization
    New York, NY

    http://www.linkedin.com/in/kurtwzimmerman

    February 13, 2014 at 6:47 am

    #1688708

  • RE: high cpu

    It appears you are running the same query in 2 different where clauses. If I were to tackle this I'd consider restructuring the code so this result set:

    select...

    Kurt W. Zimmerman
    SR DBA
    Lefrak Organization
    New York, NY

    http://www.linkedin.com/in/kurtwzimmerman

    February 11, 2014 at 9:17 am

    #1687965

  • RE: Today's Random Word!

    jcrawf02 (2/11/2014)

    Ed Wagner (2/11/2014)

    BWFC (2/11/2014)

    SQLRNNR (2/11/2014)

    Ed Wagner (2/11/2014)

    BWFC (2/11/2014)

    Ed Wagner (2/11/2014)

    SQLRNNR (2/10/2014)

    Ed Wagner (2/10/2014)

    SQLRNNR (2/10/2014)

    Stuart Davies (2/10/2014)

    Ed Wagner (2/10/2014)

    crookj (2/10/2014)

    Stuart Davies (2/10/2014)

    BWFC (2/10/2014)

    SQLRNNR (2/7/2014)

    L' Eomot Inversé (2/7/2014)

    SQLRNNR (2/7/2014)

    Confidence

    Trickster

    TURN

    Rotate

    Twist

    Ferris

    Bueller (anyone...anyone)

    Day...

    Kurt W. Zimmerman
    SR DBA
    Lefrak Organization
    New York, NY

    http://www.linkedin.com/in/kurtwzimmerman

    February 11, 2014 at 9:00 am

    #1687954

  • RE: Today's Random Word!

    BWFC (2/6/2014)

    Ed Wagner (2/6/2014)

    L' Eomot Inversé (2/6/2014)

    BWFC (2/6/2014)

    Animated

    Cartoon

    Bugs

    Bunny

    Fudd (Elmer J)

    Kurt W. Zimmerman
    SR DBA
    Lefrak Organization
    New York, NY

    http://www.linkedin.com/in/kurtwzimmerman

    February 6, 2014 at 7:19 am

    #1686591

  • RE: Today's Random Word!

    BWFC (2/5/2014)

    Kurt W. Zimmerman (2/5/2014)

    Ed Wagner (2/5/2014)

    BWFC (2/5/2014)

    SQLRNNR (2/4/2014)

    toke

    Draw

    Shoot

    Skeet

    Clay

    Pot

    Kurt W. Zimmerman
    SR DBA
    Lefrak Organization
    New York, NY

    http://www.linkedin.com/in/kurtwzimmerman

    February 5, 2014 at 7:34 am

    #1686196

  • RE: Today's Random Word!

    Ed Wagner (2/5/2014)

    BWFC (2/5/2014)

    SQLRNNR (2/4/2014)

    toke

    Draw

    Shoot

    Skeet

    Kurt W. Zimmerman
    SR DBA
    Lefrak Organization
    New York, NY

    http://www.linkedin.com/in/kurtwzimmerman

    February 5, 2014 at 7:06 am

    #1686190

  • RE: Shrinking log file

    If your database recovery model is FULL then you simply need to schedule a job to backup the transaction log. If it is set to SIMPLE then you probably...

    Kurt W. Zimmerman
    SR DBA
    Lefrak Organization
    New York, NY

    http://www.linkedin.com/in/kurtwzimmerman

    January 30, 2014 at 9:45 am

    #1684749

  • RE: Today's Random Word!

    Ed Wagner (1/29/2014)

    BWFC (1/29/2014)

    Kurt W. Zimmerman (1/28/2014)

    Ed Wagner (1/28/2014)

    L' Eomot Inversé (1/28/2014)

    crookj (1/28/2014)

    Ed Wagner (1/28/2014)

    BWFC (1/28/2014)

    Drink

    Restaurant

    Jocko's Steak House

    Rib Eye Steak

    Medium rare

    à point

    Blue

    Demi glace

    glaze

    Kurt W. Zimmerman
    SR DBA
    Lefrak Organization
    New York, NY

    http://www.linkedin.com/in/kurtwzimmerman

    January 29, 2014 at 7:36 am

    #1684320

  • RE: T-SQL help on datetime

    As Luis pointed out the conversion works fine with the sample you have. Maybe there is an instance of data that doesn't contain a valid entry or simply IS...

    Kurt W. Zimmerman
    SR DBA
    Lefrak Organization
    New York, NY

    http://www.linkedin.com/in/kurtwzimmerman

    January 28, 2014 at 2:00 pm

    #1684074

  • RE: memory issue: manual memory settings

    What else do you have running on that box? 8gb alone should be plenty to keep the OS happy. However if there is something else requiring extra memory...

    Kurt W. Zimmerman
    SR DBA
    Lefrak Organization
    New York, NY

    http://www.linkedin.com/in/kurtwzimmerman

    January 28, 2014 at 1:54 pm

    #1684072

  • RE: Triggers

    Jeff Moden (1/28/2014)

    You can actually control what order everything is done by triggers. Note that I did NOT say you could control the order of triggers (other than the...

    Kurt W. Zimmerman
    SR DBA
    Lefrak Organization
    New York, NY

    http://www.linkedin.com/in/kurtwzimmerman

    January 28, 2014 at 1:28 pm

    #1684061

  • RE: Today's Random Word!

    Ed Wagner (1/28/2014)

    L' Eomot Inversé (1/28/2014)

    crookj (1/28/2014)

    Ed Wagner (1/28/2014)

    BWFC (1/28/2014)

    Drink

    Restaurant

    Jocko's Steak House

    Rib Eye Steak

    Medium rare

    à point

    Kurt W. Zimmerman
    SR DBA
    Lefrak Organization
    New York, NY

    http://www.linkedin.com/in/kurtwzimmerman

    January 28, 2014 at 11:24 am

    #1684020

  • RE: Hardware for data mirroring.

    I have several databases that are mirrored. A few have a witness server and a few don't. Initially I set up all of the databases with witnesses until one...

    Kurt W. Zimmerman
    SR DBA
    Lefrak Organization
    New York, NY

    http://www.linkedin.com/in/kurtwzimmerman

    January 28, 2014 at 10:34 am

    #1684015

Viewing 15 posts - 61 through 75 (of 373 total)