Forum Replies Created

Viewing 15 posts - 4,291 through 4,305 (of 5,678 total)

  • RE: Date range query slow on a date as varchar

    This will still get you incorrect results. You're avoiding the conversion this way, which is then avoiding finding the correct values.

    Let me show you what's happening.

    You have 5 dates:

    DECLARE...

    - 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 21, 2011 at 2:00 pm

    #1276791

  • RE: Should SSIS sit on its own server?

    Jeffrey Williams-493691 (1/21/2011)

    Michael Valentine Jones (1/21/2011)

    We have been using centralized servers for DTS and SSIS for several years for packages that mainly produce scheduled customer reporting deliverables like spreadsheets.

    A big...

    - 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 21, 2011 at 1:39 pm

    #1276781

  • RE: Where do you look for DBA's?

    This topic is near and dear to me, so it's been percolating in my brainpan a few days now. Ferguson, tell me what you think of the following as...

    - 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 21, 2011 at 12:58 pm

    #1276750

  • RE: Are the posted questions getting worse?

    bitbucket-25253 (1/21/2011)

    LutzM (1/21/2011)

    GilaMonster (1/21/2011)

    ...

    Yes, and I got a second meeting invite for Monday afternoon. Accepted that cause I just don't feel like fighting any more.

    Unfortunately, a term like "mañana" seems...

    - 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 21, 2011 at 12:26 pm

    #1276733

  • RE: Where do you look for DBA's?

    Brandie Tarvin (1/21/2011)

    Hey, Craig, even us non-employer types are learning a lot from this discourse. I've learned a lot about job descriptions just by reading your responses (and Gail's).

    Thanks.

    Thanks 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 21, 2011 at 11:38 am

    #1276719

  • RE: Need a solution for this sql query

    Guvera (1/21/2011)

    Hi,

    Thanks for your reply. I am using PIVOT table concept already. I am using Oracle 10g. 10g version is not supported PIVOT Table.

    Thats why i think that using sql...

    - 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 21, 2011 at 3:02 am

    #1276436

  • RE: Need a solution for this sql query

    Lookup the PIVOT function. You'll have to create a column in the table/result set that the PIVOT will work from that will give names to each row though. ...

    - 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 21, 2011 at 2:22 am

    #1276423

  • RE: Are the posted questions getting worse?

    Jeff Moden (1/20/2011)

    Koen (da-zero) (1/19/2011)

    WayneS (1/19/2011)

    This thread has made me realize that I suck in deciphering job descriptions. Craig, hurry up with your articles - I need the help!!!

    At my...

    - 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 20, 2011 at 7:24 pm

    #1276340

  • RE: Where do you look for DBA's?

    Ferguson,

    Just a note. I know it looks like I'm abusing you and/or your intentions. I'm really not trying to flog this. I'm hoping that you're not 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 20, 2011 at 3:30 pm

    #1276284

  • RE: Where do you look for DBA's?

    Ferguson (1/20/2011)

    To the comments on words, inconsistencies in the descriptions -- got it. These things get written by committees, and clearly the result reflects it. There is 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

    January 20, 2011 at 12:45 pm

    #1276205

  • RE: Where do you look for DBA's?

    Ninja's_RGR'us (1/20/2011)

    In all those instances, I did my due dilligence and figured out what the market is where I was going to contract... 75$/H is on the low range...

    - 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 20, 2011 at 12:26 pm

    #1276193

  • RE: Where do you look for DBA's?

    Ferguson (1/19/2011)

    Craig, thanks.

    It is senior, not sure where you saw it was not, I did not post the actual position description in full. Should have. it is...

    - 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 19, 2011 at 9:24 pm

    #1275659

  • RE: Query to Rip the X & Y from a Geometry column

    Since this sat around a bit here, I'll ask the obvious. Can you post the DDL and a few rows of sample data here, specifically for the Map 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

    January 19, 2011 at 4:55 pm

    #1275618

  • RE: Are the posted questions getting worse?

    Alvin Ramard (1/19/2011)

    GilaMonster (1/19/2011)

    Craig Farrell (1/19/2011)

    Anyone know what brand of cookies (or cigars) the current MVPGA likes? 😉

    Bribing a committee is an expensive proposition. :hehe:

    Bribing witnesses can be even more...

    - 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 19, 2011 at 3:54 pm

    #1275610

  • RE: Are the posted questions getting worse?

    GilaMonster (1/19/2011)

    Craig Farrell (1/19/2011)

    Side note: How does one become a MS SQL MVP? My google-fu is failing miserably.

    You get a nice little email from MS on the first day...

    - 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 19, 2011 at 3:16 pm

    #1275600

Viewing 15 posts - 4,291 through 4,305 (of 5,678 total)