Forum Replies Created

Viewing 15 posts - 1,336 through 1,350 (of 5,678 total)

  • RE: Is it a good practice to maintain the data in a separate table from the task table?

    Do humans need to perform these tasks on particular edits or does the system? The approach will vary widely depending on the two.

    If the system needs to perform a...


    - 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

  • RE: Can you prent a DBA from viewing the data ?

    lianvh (8/2/2012)


    Good Day ,

    our IT Auditors suggested the database administrators should not be able to view the Production data . Is there way to do that or should we rather...


    - 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

  • RE: T-SQL Advice on Update Statement Needed

    Brandie Tarvin (8/2/2012)


    I'm going to start this off rather generically because the code we have does work, but has started running into performance problems.

    Well, will try to help, but you...


    - 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

  • RE: without [union] in Query

    Cadavre (8/1/2012)


    SELECT

    CASE WHEN a.id IS NULL THEN b.id ELSE a.id END AS id,

    CASE WHEN a.value IS NULL THEN b.value ELSE a.value END AS value

    FROM (SELECT [id], [value]

    ...


    - 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

  • RE: Are the posted questions getting worse?

    Lynn Pettis (8/1/2012)


    Evil Kraig F (8/1/2012)


    GilaMonster (7/31/2012)


    Evil Kraig F (7/31/2012)


    Ugh, sick for a week blows. I miss anything of import since last Tuesday?

    Vacation! Mine! (no, you're not invited :-)...


    - 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

  • RE: Are the posted questions getting worse?

    GilaMonster (7/31/2012)


    Evil Kraig F (7/31/2012)


    Ugh, sick for a week blows. I miss anything of import since last Tuesday?

    Vacation! Mine! (no, you're not invited 🙂 )

    LOL! Bah, shame you...


    - 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

  • RE: Are the posted questions getting worse?

    Ugh, sick for a week blows. I miss anything of import since last Tuesday?


    - 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

  • RE: Practical Service Broker

    Heya Chad.

    Sorry, came down very sick for a week, haven't reviewed a thing for a while.

    The other primary reason I like SB vs. other messaging apps is the fact that...


    - 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

  • RE: Discussion: is e-Commerce making a mockery of SQL Server?

    Ow G2, that SUCKS. Been there done that though. However, my version of that report got every consultant let go because they couldn't 'let go' normal employees while...


    - 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

  • RE: Insert data via Reporting Services

    kd11 (7/24/2012)


    Via RS can I have a user to enter 4 parameters(Fname, Lname, City, State) and that data will be store in a table on the back-end?

    Since noone else came...


    - 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

  • RE: Synchronous vs Asynchronous backup

    sequelite (7/24/2012)


    Thank you. When I asked, I was thinking of the Maintenance Plan route, where you select all databases you want backed up. I guess in that scenario, they will...


    - 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

  • RE: UNPIVOT an flat Tabel

    Would it be possible to provide the schema, some sample data, and the expected results from that data? The first question was simple enough to extrapolate for me 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

  • RE: Practical Service Broker

    Chad, you might want to include a piece on how limiting the # of activations can allow for lowering the impact of multiple high-impact bulk work simultaneously requested, so it...


    - 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

  • RE: T-SQL (Proc) Conversion to SSIS!

    Jeff Moden (7/24/2012)


    Koen Verbeeck (7/24/2012)


    Jeff Moden (7/23/2012)


    Thanks for the response, Jason. Do you have any good examples of where SSIS might outshine T-SQL? Please don't say "anything that...


    - 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

  • RE: Are the posted questions getting worse?

    Gianluca Sartori (7/19/2012)


    That's a good idea! Thanks.

    I'm working in an industry where data theft is very common and intellectual property is the most important assset. I understands the reasons behind...


    - 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

Viewing 15 posts - 1,336 through 1,350 (of 5,678 total)