Forum Replies Created

Viewing 15 posts - 2,626 through 2,640 (of 9,703 total)

  • RE: Here are some SQL Server Interview Questions

    Luis Cazares (5/15/2015)


    It's important for us that you'll be a good fit in our team, so the following question will define if you get the job or not.

    Leading commas or...

  • RE: Here are some SQL Server Interview Questions

    GilaMonster (5/15/2015)


    Luis Cazares (5/14/2015)


    You receive a late call during the night to inform you that the server is down and must be working correctly before everyone arrives in the morning....

  • RE: Here are some SQL Server Interview Questions

    Jeff Moden (5/14/2015)


    Alvin Ramard (5/14/2015)


    Here's an interview question:

    Name 10 of the parameters for DBCC TimeWarp. 😛

    I'd seriously consider asking a DBCC TimeWarp question at an interview, just to see...

  • RE: Are the posted questions getting worse?

    GilaMonster (5/14/2015)


    Question for the people here...

    Over the years I've been very careful to keep my blog completely non-commercial, no adverts, no plugs for my company, nothing. Partially because when I...

  • RE: Here are some SQL Server Interview Questions

    pietlinden (5/14/2015)


    Best milkshakes ever. I don't like that boss very much.

    And we're OFF TO THE RACES! Thank you. I did get a chuckle out of that.

  • RE: You know you're having a slow day when...

    yb751 (5/1/2015)


    So I'm browsing the forums and seeing the usual comments like "please provide code and sample data". I'm sitting there and thinking this isn't that hard. I...

  • RE: Trace Flag 4299?

    It could be just set by default in their workplace (part of their install).

    Thanks, Gail. I appreciate the insight.

  • RE: Are the posted questions getting worse?

    SQLRNNR (5/8/2015)


    Lynn Pettis (5/8/2015)


    Geez, now someone doesn't even understand that the code they are running generates and runs dynamic SQL.

    What is dynamic sql?

    Doesn't it involve fireworks and music?

    ISTR there was...

  • RE: Uninstalling SQL 2012

    Perry Whittle (5/1/2015)


    Brandie Tarvin (4/30/2015)


    WHEE! I just got my new servers and am ready to install SQL 2012 when I discovered that one of these servers already has it installed...

  • RE: Uninstalling SQL 2012

    EMarkM (5/1/2015)


    Eirikur Eiriksson (5/1/2015)You could use System Restore to the earliest point available, patch the OS and then install the SQL Server.

    😎

    That's a pretty good idea!

    Otherwise, it'll be just the...

  • RE: Uninstalling SQL 2012

    The problem is that I can't nuke the OS. Corporate has to build servers (we're not allowed) and we had to pull teeth in order to get our new servers....

  • RE: Running WinSCP in SSIS Task / .bat file

    And now it is working.

    Everyone has been incredibly helpful. Thank you. Here's the file Powershell script that I'm using.

    $erroractionpreference = "Stop"

    # Load WinSCP .NET assembly

    [Reflection.Assembly]::LoadFrom("C:\Program Files (x86)\WinScp\WinSCPnet.dll")

    # Setup session...

  • RE: Running WinSCP in SSIS Task / .bat file

    jasona.work (4/30/2015)


    Brandie, I think your batch file is almost there, just a couple more tweaks and it should go.

    That being said, I'm 90% sure that DOS doesn't like single quotes...

  • RE: Running WinSCP in SSIS Task / .bat file

    Ed Wagner (4/29/2015)


    Brandie, a word of encouragement if I may. Your batch file is creating your WinSCP script file. You then invoke it by calling the WinSCP executable...

  • RE: Running WinSCP in SSIS Task / .bat file

    GAH. Now I get nothing at all in the log file. The only upside was I could see the issues in the command prompt.

    SIGH. Why can't this be easy?

Viewing 15 posts - 2,626 through 2,640 (of 9,703 total)