Forum Replies Created

Viewing 15 posts - 421 through 435 (of 5,678 total)

  • RE: Why sql does not follow the order of the instructions as I wrote, like in sql2000?

    patsipatochoa (2/13/2014)


    It's much simpler your query, but i think query plan make a bad choice, because if SqlServer do it as it's written, not fail, and its a very 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: Getting imported file create date and storing it with the data

    dogramone (2/11/2014)


    Koen and Phil (and anybody else who is able and willing to help),

    I am trying and it is really showing my lack of knowledge, I have a book on...


    - 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 working with existing package

    wendy elizabeth (2/11/2014)


    1. What type of file should I open? Should I open a file called ssispackage.sln? Is the last node called *.sln?

    .sln is a solution, not a package....


    - 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: Access to the remote server is denied because the current security context is not trusted.

    Giles,

    Are you the Network Sysadmin with access to the firewalls and the like? This is typically a domain/server level setting. I don't know the specifics offhand on fixing...


    - 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: Generating CREATE TABLE Scripts for a large number of tables

    Lowell (2/11/2014)


    oh yeah no doubt about it Craig; but it does have a narrow use window for me, and it's faster than SMO generating the scripts.

    It all started because...


    - 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 Talent Leaves

    Craig-315134 (2/11/2014)


    So, yes, the Second Amendment does reference state militias.

    Yes, it does. I was avoiding this conversation figuring a full on train wreck of a derail wasn't good for...


    - 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 and Null values

    Just FYI: The only variable type in SSIS that's allowed to contain a NULL value is the Object variable, which is why you're not able to pass it in via...


    - 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: XML data retrieval

    Dear gods, someone sent you an Excel file as XML? That's simply evil. Excel is bad enough as it is.

    I didn't notice a code sample to be able...


    - 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: Generating CREATE TABLE Scripts for a large number of tables

    That is one LONG way around the pond, Lowell.

    SSMS. Open database, click on tables. Go to Object Explorer Details window on right. If you don't see 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: Any Advice??

    You have given us your business requirements, but we cannot see a thing about your system. We don't know how it's organized, we don't know what the tables look...


    - 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: entry level job question

    An article I wrote... gods, was it really 3 years ago?

    http://www.sqlservercentral.com/articles/Career/73400/

    Still a valid approach.


    - 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: Data flow task (OLE DB) does not fetch all the stored procedure data

    Lookup is fussy.

    First, realize it's case sensitive. UPPER everything to make sure you're matching like to like.

    Next, you have to tell it to ignore failures if you want nulls...


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

    Probably security. What's the error in the Job history/step 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: SSIS

    Connect to the SSIS server, rt-click, execute package?

    Otherwise, more details, please.


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

    Double Extra Small and my beer belly... and only in pink?

    I'm in. When are we doing the photo ops?


    - 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 - 421 through 435 (of 5,678 total)