Forum Replies Created

Viewing 15 posts - 4,426 through 4,440 (of 5,678 total)

  • RE: Select statement of view stays 5 hours to return results......

    *nearly sprays his tea all over the monitor upon opening the execution plan*

    Yikes. Wow. :w00t:

    Now, THAT'S a Table Spool. Just the estimate, I know, but a 101million...

    - 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

    January 10, 2011 at 10:40 am

    #1271511

  • RE: Are the posted questions getting worse?

    Dave Ballantyne (1/10/2011)

    This guy may know 😀

    BWAHAHAHAH. That drawing must be from the Palin camp. Note how Alaska looks to be about the same size as 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

    January 10, 2011 at 9:54 am

    #1271489

  • RE: Are the posted questions getting worse?

    Tom.Thomson (1/10/2011)

    What, me being serious? On a topic other than database or maths? Are you crazy or something?

    YIKES! Sorry Tom. Note to self: When up 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

    January 10, 2011 at 9:52 am

    #1271485

  • RE: Select statement of view stays 5 hours to return results......

    Grant Fritchey (1/10/2011)

    This results in a merge join on just a few records. From what I can see, I'd try an index on the PastExperience table on the column IdAuthor...

    - 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

    January 10, 2011 at 9:45 am

    #1271480

  • RE: Query to sum total time

    Hey Cagan,

    Welcome to SSC. It would be easier to help you if you check out the first link in my sig, which will walk you through proving some sample...

    - 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

    January 10, 2011 at 9:42 am

    #1271477

  • RE: SQL SERVER DBA

    If you don't mind an article I wrote, perhaps this will help you:

    Getting Started in SQL Server[/url].

    That should at least give you an idea of the keywords and general basic...

    - 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

    January 10, 2011 at 9:30 am

    #1271466

  • RE: Are the posted questions getting worse?

    GilaMonster (1/9/2011)

    Craig Farrell (1/9/2011)

    If the USA isn't the center of the world, why does it seem like a lot of people keep gravitating to it?

    Very bad joke (with bad physics)...

    - 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

    January 9, 2011 at 11:20 pm

    #1271250

  • RE: Are the posted questions getting worse?

    Tom.Thomson (1/9/2011)

    bitbucket-25253 (1/8/2011)

    On a more joyous note, I ran across this link on MSDN's Channel 9

    http://whathappenedinmybirthyear.com/

    Go ahead, go to it, input your year of birth, now it is not video,...

    - 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

    January 9, 2011 at 10:25 pm

    #1271242

  • RE: ssis related question

    You do this at the windows level, talk to your network administrators.

    - 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

    January 9, 2011 at 10:21 pm

    #1271241

  • RE: RAID 5 and SQL Server

    The write penalty for RAID 5 is painful, there is little argument there. However, unless you're dealing with incredibly high transactions, the write-cache built into most sans these days...

    - 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

    January 8, 2011 at 11:40 pm

    #1271106

  • RE: Need help, to load dynamic columns

    touchmeknot (1/4/2011)

    Hello everyone,

    I agree with Craig and disagree with Phil.

    I succeeded in loading the file. Yes, it seems impossible but I succeeded in loading the file dynamically without using any...

    - 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

    January 8, 2011 at 11:30 pm

    #1271105

  • RE: Flat with multiple data sets

    Ghanta (1/7/2011)

    Thanks Elliott and Craig for the response. Craig it is positional association only... each line will have different schema based on three characters at position 9, 10, 11 and...

    - 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

    January 8, 2011 at 5:36 am

    #1271046

  • RE: Memory lacking causing disk issues?

    shifty1981 (1/7/2011)

    thanks for the comment. I would appreciate us discussing this however. Only because this server is rare in that the DB is on a SAN. most of our environments...

    - 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

    January 8, 2011 at 5:29 am

    #1271045

  • RE: ssis

    Madhu....

    Answer to what? There is no question here.

    - 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

    January 8, 2011 at 5:04 am

    #1271043

  • RE: Flat with multiple data sets

    Ghanta, one of the key items in dealing with a mainframe output file like this is if the records can be re-associated by anything except positionally. IE If...

    - 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

    January 7, 2011 at 4:31 pm

    #1270980

Viewing 15 posts - 4,426 through 4,440 (of 5,678 total)