Forum Replies Created

Viewing 15 posts - 5,431 through 5,445 (of 5,678 total)

  • RE: Help with Update Query

    Lynn Pettis (9/30/2010)

    Just a typical Celko response.

    I'd disagree. He's usually got the tact of a steamroller but that was obnoxious, even for him.

    - 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 30, 2010 at 12:49 pm

    #1229839

  • RE: Help with Update Query

    CELKO (9/30/2010)

    Have you even thought about using a relational design instead mimicking a deck of punch cards? Do you know about UPC and industry standards? Do you know why IDENTITY...

    - 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 30, 2010 at 12:21 pm

    #1229803

  • RE: Are the posted questions getting worse?

    *blink*blink*... Wow. Makes me never want to buy one of those books of his.

    http://www.sqlservercentral.com/Forums/Topic994925-392-1.aspx

    - 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 30, 2010 at 12:18 pm

    #1229798

  • RE: SQL is slow

    Expand this code to each field. You're running subqueries for each line, that's going to hurt.

    UPDATE tt

    SETclm_loc_city = lt.loc_city,

    clm_loc_state = lt.loc_state

    -- ... keep going on

    FROM

    #temp_table AS tt

    JOIN

    LOCATION_TABLE 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

    September 30, 2010 at 12:05 pm

    #1229787

  • RE: Large Table Design

    jackimo (9/30/2010)

    Thanks Grant,

    I do understand that and the fact is in some cases we'll have to do a full scan. Do you think that storing the message in 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

    September 30, 2010 at 11:39 am

    #1229772

  • RE: How can you see the Recovery Model?

    SwayneBell (9/30/2010)

    Update:

    I'm told that what's happening here is that we do full backups each night. The following morning, the log files are 'deleted' and allowed to fill through the 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

    September 30, 2010 at 11:29 am

    #1229764

  • RE: SQL is slow

    Create a copy of the procedure and do timestamp wrappers around each of the updates. Find out where the pain in time is. Then start pulling out execution...

    - 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 30, 2010 at 11:21 am

    #1229755

  • RE: Are the posted questions getting worse?

    Jeff Moden (9/29/2010)

    Chris Morris-439714 (9/29/2010)

    Jack Corbett (9/29/2010)

    So how do you all deal with a "maverick"/"lone ranger" coder? I think you all know what I mean. That person who...

    - 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 29, 2010 at 5:43 pm

    #1229412

  • RE: Clustered Index - UniqueIdentifiers

    AmolNaik (9/29/2010)

    Create copy of the table that is identically same with the correct structure. Copy data from the existing table to this new table. Switch the table names.

    After that 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

    September 29, 2010 at 5:26 pm

    #1229409

  • RE: Are the posted questions getting worse?

    I figured I'd eventually get the pork chop thing from context eventually... but... yeah, I'm not. Where'd this originate? I've got the generic idea but still a little...

    - 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 29, 2010 at 5:16 pm

    #1229406

  • RE: Can Wives Shorten Work Hours?

    SQLBill (9/29/2010)

    I don't mind working extra hours when needed and my wife supports me in that. It is interesting how lots of companies expect their employees to work extra...

    - 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 29, 2010 at 4:06 pm

    #1229382

  • RE: Optimization strategy?!

    WayneS (9/28/2010)

    With all this talk about the clustered index, and churn on the date field, don't forget that all of those numerous non-clustered indexes will be converted to carrying 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 28, 2010 at 2:29 pm

    #1228658

  • RE: How to Slice Up LUNs for SQL Server

    Logical disks are only useful for logical storage. It will give you no performance boost. Regarding the giant RAID 5 array, you'll want to find out if 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 28, 2010 at 2:22 pm

    #1228655

  • RE: sp_refreshview

    I'm staring at a case for the need right now: The dependency broke across a linked server.

    - 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 28, 2010 at 11:54 am

    #1228567

  • RE: Optimization strategy?!

    scott.pletcher (9/27/2010)

    I don't object to an IDENTITY column in tables per se, and they have very legitimate uses.

    But I dislike the idea that the default for a clus index should...

    - 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 28, 2010 at 11:50 am

    #1228564

Viewing 15 posts - 5,431 through 5,445 (of 5,678 total)