Forum Replies Created

Viewing 15 posts - 151 through 165 (of 373 total)

  • RE: Inserting error data into a table from CATCH statement within a TRY CATCH

    //Ravi (11/12/2013)

    Keith, Thanks. That did the Trick. Here is the correct Code:

    END TRY

    BEGIN CATCH

    ...

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

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

    November 12, 2013 at 9:48 am

    #1665786

  • RE: Right or Wrong, Dynamic SQL AND a Cursor

    Nadrek (11/8/2013)

    It is not generalizable to restore every single t-log backup in the directory you store backups - this script as presented only works if a human has already selected...

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

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

    November 8, 2013 at 2:26 pm

    #1665228

  • RE: Right or Wrong, Dynamic SQL AND a Cursor

    bradphilp (11/8/2013)

    The reasons we don't like cursors are due to the unpredictability of locks, not to mention not set programming. Anything you can do with a cursor, you can do...

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

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

    November 8, 2013 at 9:20 am

    #1665151

  • RE: Right or Wrong, Dynamic SQL AND a Cursor

    Larry Aue (11/8/2013)

    Use the INSENSITIVE keyword in your declare statement and the cursor is essentially just like using a temp table, since insensitive cursors don't keep track of changes that...

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

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

    November 8, 2013 at 8:06 am

    #1665132

  • RE: Today's Random Word!

    Ed Wagner (11/7/2013)

    Sean Pearce (11/7/2013)

    Bazinga

    Theory

    analytical

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

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

    November 7, 2013 at 1:24 pm

    #1664910

  • RE: please help with cte

    This code is a bit confusing to follow, but as a previous poster indicated your statement

    WITH cteSource ( NAME, ID, GR, SC, Ethnicity, Gate, SpecialED, LF,...

    has...

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

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

    November 7, 2013 at 8:29 am

    #1664807

  • RE: Today's Random Word!

    Revenant (11/4/2013)

    Ed Wagner (11/4/2013)

    Revenant (11/4/2013)

    Ed Wagner (11/4/2013)

    SQLRNNR (11/4/2013)

    TurDucken

    Good eats

    Three weeks and three days

    Cooking

    Roasting

    Chestnuts

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

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

    November 4, 2013 at 1:37 pm

    #1663968

  • RE: Issue with Logshipping

    Perry Whittle (11/3/2013)

    Firstly, don't use administrative shares for file\folder access, create a new share at the appropriate folder level and ensure you set the following for the account the SQL...

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

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

    November 4, 2013 at 12:06 pm

    #1663925

  • RE: inserting cte table into temp table?

    Jeff Moden (11/4/2013)

    mick burden (11/4/2013)

    thanks Jeff, it's not something I've used before. What is the advantage? and can the table created be read using VB.net?

    The biggest advantage is that you...

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

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

    November 4, 2013 at 11:28 am

    #1663915

  • RE: Failed to map 8388608 bytes of contiguous memory

    I'm not sure exactly what the actual cause of the problem was. I presumed that it had to do with the way the VM environment allocated memory.

    In...

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

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

    November 4, 2013 at 8:32 am

    #1663847

  • RE: SQL Search very slow please help

    I guess better stated is Out-of-Date statistics.

    Kurt

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

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

    November 1, 2013 at 2:02 pm

    #1663600

  • RE: Failed to map 8388608 bytes of contiguous memory

    Greetings all;

    Just an update. I was experiencing issues with the entire application stack so I was able to take advantage of rebooting the SQL Server. It...

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

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

    November 1, 2013 at 12:52 pm

    #1663566

  • RE: SQL Search very slow please help

    clayman (11/1/2013)

    Kurt W. Zimmerman (11/1/2013)

    clayman (11/1/2013)

    Kurt W. Zimmerman (11/1/2013)

    If I'm going to move data from one server to another via Import/Export I will script out the source database...

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

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

    November 1, 2013 at 10:25 am

    #1663505

  • RE: SQL Search very slow please help

    clayman (11/1/2013)

    Kurt W. Zimmerman (11/1/2013)

    If I'm going to move data from one server to another via Import/Export I will script out the source database first and place it on...

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

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

    November 1, 2013 at 9:38 am

    #1663466

  • RE: SQL Search very slow please help

    If I'm going to move data from one server to another via Import/Export I will script out the source database first and place it on the destination box. Then...

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

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

    November 1, 2013 at 8:53 am

    #1663438

Viewing 15 posts - 151 through 165 (of 373 total)