Forum Replies Created

Viewing 15 posts - 2,086 through 2,100 (of 5,678 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...

    - Craig Farrell

    Never stop learning, even if it hurts. Ego bruises are practically mandatory as you learn unless you've never risked enough to make a mistake.

    For better assistance in answering your questions[/url] | Forum Netiquette
    For index/tuning help, follow these directions.[/url] |Tally Tables[/url]
    Twitter: @AnyWayDBA

    December 13, 2011 at 12:10 pm

    #1420812

  • 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...

    - Craig Farrell

    Never stop learning, even if it hurts. Ego bruises are practically mandatory as you learn unless you've never risked enough to make a mistake.

    For better assistance in answering your questions[/url] | Forum Netiquette
    For index/tuning help, follow these directions.[/url] |Tally Tables[/url]
    Twitter: @AnyWayDBA

    December 13, 2011 at 12:08 pm

    #1420809

  • 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...

    - Craig Farrell

    Never stop learning, even if it hurts. Ego bruises are practically mandatory as you learn unless you've never risked enough to make a mistake.

    For better assistance in answering your questions[/url] | Forum Netiquette
    For index/tuning help, follow these directions.[/url] |Tally Tables[/url]
    Twitter: @AnyWayDBA

    December 13, 2011 at 12:07 pm

    #1420807

  • RE: Log file shrinks itself

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

    - Craig Farrell

    Never stop learning, even if it hurts. Ego bruises are practically mandatory as you learn unless you've never risked enough to make a mistake.

    For better assistance in answering your questions[/url] | Forum Netiquette
    For index/tuning help, follow these directions.[/url] |Tally Tables[/url]
    Twitter: @AnyWayDBA

    December 13, 2011 at 11:32 am

    #1420787

  • 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...

    - Craig Farrell

    Never stop learning, even if it hurts. Ego bruises are practically mandatory as you learn unless you've never risked enough to make a mistake.

    For better assistance in answering your questions[/url] | Forum Netiquette
    For index/tuning help, follow these directions.[/url] |Tally Tables[/url]
    Twitter: @AnyWayDBA

    December 13, 2011 at 10:55 am

    #1420752

  • 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...

    - Craig Farrell

    Never stop learning, even if it hurts. Ego bruises are practically mandatory as you learn unless you've never risked enough to make a mistake.

    For better assistance in answering your questions[/url] | Forum Netiquette
    For index/tuning help, follow these directions.[/url] |Tally Tables[/url]
    Twitter: @AnyWayDBA

    December 12, 2011 at 5:44 pm

    #1420319

  • 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...

    - Craig Farrell

    Never stop learning, even if it hurts. Ego bruises are practically mandatory as you learn unless you've never risked enough to make a mistake.

    For better assistance in answering your questions[/url] | Forum Netiquette
    For index/tuning help, follow these directions.[/url] |Tally Tables[/url]
    Twitter: @AnyWayDBA

    December 12, 2011 at 5:43 pm

    #1420318

  • 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...

    - Craig Farrell

    Never stop learning, even if it hurts. Ego bruises are practically mandatory as you learn unless you've never risked enough to make a mistake.

    For better assistance in answering your questions[/url] | Forum Netiquette
    For index/tuning help, follow these directions.[/url] |Tally Tables[/url]
    Twitter: @AnyWayDBA

    December 12, 2011 at 5:41 pm

    #1420317

  • 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...

    - Craig Farrell

    Never stop learning, even if it hurts. Ego bruises are practically mandatory as you learn unless you've never risked enough to make a mistake.

    For better assistance in answering your questions[/url] | Forum Netiquette
    For index/tuning help, follow these directions.[/url] |Tally Tables[/url]
    Twitter: @AnyWayDBA

    December 12, 2011 at 5:39 pm

    #1420316

  • RE: Variant Order 3

    It's official. I hate Variant.

    - Craig Farrell

    Never stop learning, even if it hurts. Ego bruises are practically mandatory as you learn unless you've never risked enough to make a mistake.

    For better assistance in answering your questions[/url] | Forum Netiquette
    For index/tuning help, follow these directions.[/url] |Tally Tables[/url]
    Twitter: @AnyWayDBA

    December 12, 2011 at 3:57 pm

    #1420307

  • 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,...

    - Craig Farrell

    Never stop learning, even if it hurts. Ego bruises are practically mandatory as you learn unless you've never risked enough to make a mistake.

    For better assistance in answering your questions[/url] | Forum Netiquette
    For index/tuning help, follow these directions.[/url] |Tally Tables[/url]
    Twitter: @AnyWayDBA

    December 12, 2011 at 2:56 pm

    #1420292

  • 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...

    - Craig Farrell

    Never stop learning, even if it hurts. Ego bruises are practically mandatory as you learn unless you've never risked enough to make a mistake.

    For better assistance in answering your questions[/url] | Forum Netiquette
    For index/tuning help, follow these directions.[/url] |Tally Tables[/url]
    Twitter: @AnyWayDBA

    December 12, 2011 at 2:52 pm

    #1420289

  • 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...

    - Craig Farrell

    Never stop learning, even if it hurts. Ego bruises are practically mandatory as you learn unless you've never risked enough to make a mistake.

    For better assistance in answering your questions[/url] | Forum Netiquette
    For index/tuning help, follow these directions.[/url] |Tally Tables[/url]
    Twitter: @AnyWayDBA

    December 12, 2011 at 2:19 pm

    #1420268

  • 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...

    - Craig Farrell

    Never stop learning, even if it hurts. Ego bruises are practically mandatory as you learn unless you've never risked enough to make a mistake.

    For better assistance in answering your questions[/url] | Forum Netiquette
    For index/tuning help, follow these directions.[/url] |Tally Tables[/url]
    Twitter: @AnyWayDBA

    December 12, 2011 at 1:26 pm

    #1420244

  • 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...

    - Craig Farrell

    Never stop learning, even if it hurts. Ego bruises are practically mandatory as you learn unless you've never risked enough to make a mistake.

    For better assistance in answering your questions[/url] | Forum Netiquette
    For index/tuning help, follow these directions.[/url] |Tally Tables[/url]
    Twitter: @AnyWayDBA

    December 12, 2011 at 11:19 am

    #1420200

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