Forum Replies Created

Viewing 15 posts - 1,156 through 1,170 (of 5,678 total)

  • RE: T-SQL Help Needed

    SomewhereSomehow (9/20/2012)

    Ha-ha-ha! I think you are joking about beating =)

    He's not, but we're talking a mideival training method.

    In Russia we have a proverb: "Every joke has a little bit of...

    - 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

    September 20, 2012 at 2:40 pm

    #1540388

  • RE: generate multiple data flow tasks

    sqlfriends (9/20/2012)

    The reason I ask is I saw actually we have a ETL that seems generated somehow.

    In it there are about 30 data flows, from the format they look so...

    - 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

    September 20, 2012 at 1:39 pm

    #1540355

  • RE: Number of natural\business keys in dimension tables

    Daniel Hallam (9/19/2012)

    Should the dimension have an excessive number of business keys if the source data warrants it?

    I would say more if the questions the users were asking of 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

    September 20, 2012 at 1:32 pm

    #1540349

  • RE: Help writing SQL Server development guide!

    I'm going to nitpick a bit about a few items here the others didn't mention (yet), as they concentrated on the huge issues.

    PiMané (9/20/2012)

    * Always create FK 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

    September 20, 2012 at 1:25 pm

    #1540345

  • RE: generate multiple data flow tasks

    sqlfriends (9/20/2012)

    Is there a way to generate multiple data flow tasks?

    We need to import data from 40 flat files to 40 SQL server tables, instead of manually create each data...

    - 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

    September 20, 2012 at 1:04 pm

    #1540329

  • RE: A Database with 70 Table

    vahid.arr (9/18/2012)

    hi everybody

    I Have Database With 70 Tables and this my first time that i have alot table in my DB. I want Any Subject or Topic that is Good...

    - 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

    September 18, 2012 at 3:31 pm

    #1539311

  • RE: Setting a Primary key to subsequential Data (Header - Line)

    dwain.c (9/18/2012)

    Now I'm fairly sure someone is going to think that I'm crazy and perhaps I am, but why not use XML for this?

    Let's set up the incoming data just...

    - 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

    September 18, 2012 at 1:31 pm

    #1539274

  • RE: Are the posted questions getting worse?

    Sean Lange (9/18/2012)

    Lynn Pettis (9/18/2012)

    SQLRNNR (9/18/2012)

    Lynn Pettis (9/18/2012)

    Flat file, 150,000 columns, SQL Server only allows 1,024 columns per table. The flat file needs to be imported into Excel spreadsheets.

    I'm...

    - 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

    September 18, 2012 at 1:26 pm

    #1539271

  • RE: Are the posted questions getting worse?

    Lowell (9/18/2012)

    Lynn Pettis (9/18/2012)

    SQLRNNR (9/18/2012)

    Lynn Pettis (9/18/2012)

    Flat file, 150,000 columns, SQL Server only allows 1,024 columns per table. The flat file needs to be imported into Excel spreadsheets.

    I'm not...

    - 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

    September 18, 2012 at 1:15 pm

    #1539260

  • RE: unique patients from duplicate patient row entries

    boehnc (9/17/2012)

    this is basically the code...this join... left join UserView.vwEncounterDiagnosis d on d.VisitId=a.VisitId...will give me multiple rows per patient

    i might need help with the diagnosis order/code statements in the where...

    - 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

    September 18, 2012 at 1:12 pm

    #1539257

  • RE: job for collecting data

    eh.shams (9/17/2012)

    I need a script to copy data from one table(source) to anotehr table (destination),

    i want to sheduling this task for every 5 minute , rows which data were copied...

    - 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

    September 17, 2012 at 9:38 pm

    #1538881

  • RE: unique patients from duplicate patient row entries

    boehnc (9/17/2012)

    I need to bring back in a table unique patients where dxcode = 23 or 34.

    one patient can have 23 and 34..I just need to bring back whether they...

    - 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

    September 17, 2012 at 9:36 pm

    #1538880

  • RE: SSIS error from flat file to table

    You're delivering to a unicode string (nVarchar) and your file source definition is most likely string instead of unicode. Modify the source to be unicode, or use the datatype...

    - 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

    September 15, 2012 at 10:09 pm

    #1538316

  • RE: Are the posted questions getting worse?

    I was working on a massive threadizen post and... lost it due to the vagueries of IE 10.

    Short form: Is there a yearly threadizen gathering that I'm unaware of. ...

    - 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

    September 15, 2012 at 2:45 am

    #1538261

  • RE: Are the posted questions getting worse?

    SQL Kiwi (9/14/2012)

    Evil Kraig F (9/14/2012)

    He might have meant as far away from civilization as possible, in which case New Zealand might have been more accurate... 😛

    Noting all this down,...

    - 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

    September 14, 2012 at 5:41 pm

    #1538230

Viewing 15 posts - 1,156 through 1,170 (of 5,678 total)