Forum Replies Created

Viewing 15 posts - 31 through 45 (of 373 total)

  • RE: Today's Random Word!

    SQLRNNR (3/28/2014)

    Ed Wagner (3/28/2014)

    Row

    Roe

    Wade

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

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

    March 28, 2014 at 7:31 am

    #1701083

  • RE: Restore compressed backup creates 5x larger database

    I have production issues I need to deal with and will post your requested information as soon as I can free up.

    Kurt

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

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

    March 27, 2014 at 7:50 am

    #1700682

  • RE: automated-index-defrag-script

    You execute a script like this either directly as a SQL Server Agent job or you can create a Maintenance Plan and run the SQL within it. You would...

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

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

    March 27, 2014 at 7:49 am

    #1700681

  • RE: Restore compressed backup creates 5x larger database

    See attached:

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

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

    March 26, 2014 at 9:44 am

    #1700370

  • RE: Restore compressed backup creates 5x larger database

    GilaMonster (3/26/2014)

    You're absolutely sure there aren't somehow multiple backups appended in the same file? (since you're using noinit on the backup)

    Absolutely!

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

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

    March 26, 2014 at 9:05 am

    #1700341

  • RE: Restore compressed backup creates 5x larger database

    GilaMonster (3/26/2014)

    What are the exact versions of the two servers?

    SELECT @@Version

    Any traceflags enabled on either server?

    no traceflags.

    Production server:

    Microsoft SQL Server 2008 R2 (SP2) - 10.50.4000.0 (X64)

    Jun 28...

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

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

    March 26, 2014 at 8:56 am

    #1700335

  • RE: Restore compressed backup creates 5x larger database

    GilaMonster (3/26/2014)

    Hmmm... that's odd.

    Should created the DB exactly as it was at the time of the backup. Nothing else going on? No reverts from snapshot? No data obfuscations being run?

    Can...

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

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

    March 26, 2014 at 8:35 am

    #1700323

  • RE: Restore compressed backup creates 5x larger database

    GilaMonster (3/26/2014)

    You said the production DB has initial size of 15GB, what's the actual size of the data file on disk?

    Edit: Native backups? What's the backup command? What's the restore...

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

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

    March 26, 2014 at 8:25 am

    #1700309

  • RE: Today's Random Word!

    EricEyster (3/24/2014)

    Ed Wagner (3/24/2014)

    BWFC (3/24/2014)

    Lonely

    Isolation

    Island

    Hopping

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

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

    March 24, 2014 at 10:01 am

    #1699581

  • RE: Today's Random Word!

    Revenant (3/20/2014)

    Kurt W. Zimmerman (3/20/2014)

    TomThomson (3/20/2014)

    crookj (3/20/2014)

    Ed Wagner (3/20/2014)

    Stuart Davies (3/20/2014)

    BWFC (3/20/2014)

    Ed Wagner (3/19/2014)

    crookj (3/19/2014)

    Revenant (3/19/2014)

    Ed Wagner (3/19/2014)

    SQLRNNR (3/19/2014)

    parsename

    Quotename

    Delimiter

    Pipe

    Plumbing

    Depths

    Charge

    Cash

    Dough

    Bread

    Truckin'

    Keep

    fortified

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

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

    March 20, 2014 at 1:59 pm

    #1698881

  • RE: Today's Random Word!

    TomThomson (3/20/2014)

    crookj (3/20/2014)

    Ed Wagner (3/20/2014)

    Stuart Davies (3/20/2014)

    BWFC (3/20/2014)

    Ed Wagner (3/19/2014)

    crookj (3/19/2014)

    Revenant (3/19/2014)

    Ed Wagner (3/19/2014)

    SQLRNNR (3/19/2014)

    parsename

    Quotename

    Delimiter

    Pipe

    Plumbing

    Depths

    Charge

    Cash

    Dough

    Bread

    Truckin'

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

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

    March 20, 2014 at 11:20 am

    #1698810

  • RE: TEMPDB on RAM

    That reminds me of yet another position I had. They had some code that had been around for a very long time. I believe it originated on a...

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

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

    March 19, 2014 at 1:56 pm

    #1698514

  • RE: TEMPDB on RAM

    +1 on Jeff's comments as well. This topic of bad code seems to be cropping up more and more. If I had the best of all worlds I'd...

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

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

    March 19, 2014 at 12:24 pm

    #1698487

  • RE: Today's Random Word!

    mathematician

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

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

    March 19, 2014 at 7:22 am

    #1698359

  • RE: FULL TEXT SEARCH

    It has been a while since I had a DB with a FTI, but from time to time I found it to report incorrect results despite the Auto-Index was on....

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

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

    March 18, 2014 at 7:34 am

    #1697997

Viewing 15 posts - 31 through 45 (of 373 total)