Forum Replies Created

Viewing 15 posts - 2,086 through 2,100 (of 5,685 total)

  • RE: How long should a shrink take

    Sean Grebey-262535 (12/13/2011)


    I kicked of a shrink (the server had run out of room), but almost an hour and a half later it is still spinning. How long should this...

  • RE: Are the posted questions getting worse?

    Revenant (12/13/2011)


    GSquared (12/13/2011)


    jcrawf02 (12/13/2011)


    I think that's actually showing up as a diagnosis in ICD-10, "Threadizen"

    CDC request...

    And the only cure is beingectomy - in other words, you have to be amputated...

  • RE: Log file shrinks itself

    jbrown414 (12/13/2011)


    It is set to auto shrink. :pinch:

    Thank you Craig. I will get it turned off.

    LOL, no problem. Sometimes Occam was quite correct. Gotta love inheriting...

  • RE: Log file shrinks itself

    Do you have auto-shrink turned on for the database?

  • RE: configuration file

    Koen Verbeeck (12/13/2011)


    Clicking on 'Start Debugging' or right-clicking on a package and selecting "Execute Package" will result in the configuration file being used.

    However, if you select a task/container and choose...

  • RE: configuration file

    sqlfriends (12/12/2011)


    When I design SSIS package, I point it to a package configuration file using environment variable to point to an xml file on my file system.

    My question is when...

  • RE: Is dynamic SQL the only route to SQL injection?

    Stephanie Giovannini (12/12/2011)


    I'm trying to make the argument that we don't need this type of filter, but I'm not entirely certain. I've seen many approaches to preventing SQL injection, but...

  • RE: Assigning variables in Where Clause

    jigsm_shah (12/12/2011)


    My question is that generally in the Where clause we do assignment as 'WHERE p.Name=@productName'

    But in the above query the assignment is 'WHERE @productName=p.Name'

    There is no difference between the...

  • RE: Are the posted questions getting worse?

    LutzM (12/12/2011)


    Evil Kraig F (12/12/2011)


    ...

    Nah, he used the front portion of the crown. It's about the hardest portion of your body, he's fine. I've done that a few...

  • RE: Variant Order 3

    It's official. I hate Variant.

  • RE: update a table using another set of data

    sqlfriends (12/9/2011)


    Thanks,

    My table A has 400000 row counts, but the table B only has 100 row counts.

    So I think if I should do a join of two tables to insert,...

  • RE: Does the Role of the DBA Need to Evolve?

    GSquared (12/12/2011)


    You're probably thinking of the (much later) Feudal-period "bards". Same job title, but more entertainer than keeper of lore. That's a post-literate development. I was refering...

  • RE: Does the Role of the DBA Need to Evolve?

    GSquared (12/12/2011)


    michael.french 172 (12/12/2011)


    An exponential advance in technology is an understatement. Think of how far we come in just the last 50 years or even five years. Think about how...

  • RE: Are the posted questions getting worse?

    SteveBell (12/12/2011)


    Brandie Tarvin (12/12/2011)


    Steve Jones - SSC Editor (12/9/2011)


    Brandie Tarvin (12/9/2011)


    Oh, it's not a thread. I didn't post on this. I just found it and put a dent in my...

  • RE: Having trouble with a join select query

    tarr94 (12/12/2011)


    Kraig, your solution appears to work! Thank you!

    It does return a duplicate for order detail record #5, but that is because both parent items are present in the...

Viewing 15 posts - 2,086 through 2,100 (of 5,685 total)