Forum Replies Created

Viewing 15 posts - 2,626 through 2,640 (of 5,678 total)

  • RE: Are the posted questions getting worse?

    bitbucket-25253 (9/2/2011)

    I will point out that my Dad worked for wages, hard work, and bought me up to never, ever expect a had out for doing nothing. My thoughts 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

    September 2, 2011 at 3:54 pm

    #1376711

  • RE: Looking for help taking the RBAR from this problem

    Can you create a nonclustered index on serverId/timestamp only, and then re-check the max function? That should cure your issue, if not, I'd like to see the execution plan...

    - 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 2, 2011 at 3:40 pm

    #1376707

  • RE: Basing the where clause on certain conditions

    Hey Rog, you seem semi-new around here, but when asking for code assistance it helps if we can test it before we hand it to you. There's too many...

    - 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

    August 29, 2011 at 2:40 pm

    #1374726

  • RE: Combining SQL Servers

    Having done this wholesale about 2 years ago, some thoughts:

    1) Watch all FOUR bottlenecks. Network I/O, Disk I/O, CPU, Memory. One server bit us in the butt when...

    - 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

    August 29, 2011 at 2:36 pm

    #1374724

  • RE: Why is my select slow? (question about indexes)

    jeeva.nadarajah (8/29/2011)

    Switching it to varchar(max) didn't slow down anything but not including deploymentlog in select did.

    Am going to see what the max length on deploymentlog is and switch it 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

    August 29, 2011 at 2:26 pm

    #1374716

  • RE: Why is my select slow? (question about indexes)

    jeeva.nadarajah (8/29/2011)

    Thanks Everybody!

    Since there is so little data in the table, I've switched the type to be VARCHAR(max) and am refactoring to remove the deploymentLog from queries.

    That makes it 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

    August 29, 2011 at 2:06 pm

    #1374704

  • RE: error while creating SSIS package

    tracmonali (8/29/2011)

    This is more regarding creating an SSIS package. While I create an SSIS pkg, I am using the sql command

    RESTORE DATABASE db

    FROM DISK = '\\'

    WITH REPLACE

    I get an...

    - 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

    August 29, 2011 at 2:04 pm

    #1374701

  • RE: Specialists or Generalists: Who are best as Developers?

    Rod at work (8/29/2011)

    Revenant (8/29/2011)

    jn_gray (8/29/2011)

    I think that all developers start out as specialists and over time become generalists unless they decide to make a concerted effort to remain 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

    August 29, 2011 at 2:02 pm

    #1374700

  • RE: Why is my select slow? (question about indexes)

    jeeva.nadarajah (8/29/2011)

    Thanks for the prompt response. I'm looking into whether or not we can change the type for that field without much intrusion.

    That's what you meant by by "Round...

    - 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

    August 29, 2011 at 1:06 pm

    #1374666

  • RE: Are the posted questions getting worse?

    GilaMonster (8/29/2011)

    And right on cue, a PM that's leaning towards harassment. <sigh>

    Why do some people think that just because I've answered a couple of their questions that I'm their BFF?

    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

    August 29, 2011 at 12:52 pm

    #1374654

  • RE: Why is my select slow? (question about indexes)

    jeeva.nadarajah (8/29/2011)

    My table has 4000 rows and a simple select * from [DeploymentTarget_Temp] takes more than 2.3 minutes. Can someone help me understand how I can improve performance?

    CREATE TABLE [dbo].[DeploymentTarget_Temp](

    [DeploymentTargetID]...

    - 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

    August 29, 2011 at 12:51 pm

    #1374652

  • RE: Is it RBRAR???

    It's not RBAR (Row By Agonizing Row), it's just ugly.

    Take this piece and run it on the foreign server, dump to a local temp with only the columns you need,...

    - 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

    August 29, 2011 at 12:49 pm

    #1374650

  • RE: Inserted Identity

    Tom.Thomson (8/26/2011)

    I suppose some might go for the "error" answer if they think that "define" is a reserved word that would need to be quoted when used as a table...

    - 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

    August 29, 2011 at 12:47 pm

    #1374649

  • RE: Has anybody constructed dynamic SQL by storing SQL in fields in tables?

    Francis McFaul (8/29/2011)

    Well, 2) is definitely out of the question. They're asked me to stay beyond my 6 month committment, and I said "No, thank you" -- mainly 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

    August 29, 2011 at 12:21 pm

    #1374643

  • RE: Return one row from multiple rows based on order of tests in where clause

    tshad (8/26/2011)

    But why does this work in the Order By? Normally you have to have a valid column to do an Order By on.

    Why does this work?

    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

    August 26, 2011 at 4:56 pm

    #1374157

Viewing 15 posts - 2,626 through 2,640 (of 5,678 total)