Forum Replies Created

Viewing 15 posts - 2,221 through 2,235 (of 5,678 total)

  • RE: nvarchar to variable adding extra backslash

    Sounds like it's forcing an escape character, ie: http://msdn.microsoft.com/en-us/library/ms141001.aspx

    To confirm the events: Dataflow with OLEDB source of SELECT col,col,col FROM table. Immediate destination to a recordset destination, which...


    - 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?

    Newbie with a master database corruption here.

    They're not being quick on the responses, I want to make sure someone doesn't send him off to rebuild it if it's just 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: delete in batch makes drive space almost full

    sqlfriends (11/28/2011)


    [No - switching the recovery models does not reduce the amount of logging on deletes. The amount of data logged will be exactly the same whether in simple,...


    - 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: MSSQLSERVER stopped and does not start

    I should have mentioned, right about now is when you want to make dang sure you know where a valid copy of your master db backups are, and the most...


    - 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: SSIS puzzle or microsoft bug?

    sql_er (11/28/2011)


    I then open the original raw CSV file and remove the extra comma from the end of each row (I open it in textpad and replace ',' with '').

    ....

    Once...


    - 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: MSSQLSERVER stopped and does not start

    It can't find the master database, or it's corrupt. What was the last thing that happened on this server?

    Can you pull up the tail of the previous error log...


    - 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?

    Evil Kraig F (11/28/2011)


    That's just screaming someone hit the wrong dropdown option for title... but seriously, don't they do skillset matching anymore for email dumps?

    Title: Moving Target. Job...


    - 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: delete in batch makes drive space almost full

    sqlfriends (11/28/2011)


    Steve Jones - SSC Editor (11/28/2011)


    I'm confused. What space are you trying to save? You started posting as though you were having log space issues with this delete. Then...


    - 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: Top command question

    soochkoam (11/28/2011)


    I don't know how to copy the execution plan to here, but after viewing the plan, there is definetly a difference between the two querys.

    Check out the bottom left...


    - 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: Top command question

    soochkoam (11/28/2011)


    I have a query that joins 8 tables together and will return 50 records. When I use the "top 100" command the query will return all 50 records...


    - 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: Where to go to learn how to create custom SSIS Dataflow Tasks

    dndaughtery (11/28/2011)


    I need to learn how to create custom ssis dataflow tasks. I've been told that my new company often will incorporate stored procedures inside a custom task. Is there...


    - 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: How do you write to Teradata in SSIS?

    You need to create a datasource to teradata in the lower section and then use the corresponding destination component, most likely OLDB.

    From the first couple of hits in google (Keywords:...


    - 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?

    Jack Corbett (11/28/2011)


    So I had to post this job description I got via email today for a SQL Server DBA position:

    Qualified candidates will possess programming skills, such as skill in...


    - 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?

    SQLRNNR (11/28/2011)


    Evil Kraig F (11/28/2011)


    GSquared (11/28/2011)


    Brandie Tarvin (11/28/2011)


    GSquared (11/28/2011)


    But, Yahoo Babel Fish wins first prize with:

    ... in fact c' is a work of plunger.

    I just love this part. @=)

    Yep!...


    - 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: linked server. To use or not to use

    captcooldaddy (11/28/2011)


    I have a couple tables and or viewes that i want to copy over to a different box daily. I was planning on using linked servers as opposed to...


    - 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 - 2,221 through 2,235 (of 5,678 total)