Forum Replies Created

Viewing 15 posts - 5,071 through 5,085 (of 5,678 total)

  • RE: Clustered Index and Striping

    biju.pad (11/5/2010)

    I thought non-clustered index had the RIDs of the actual rows, whereas clustered index stored the actual row as leaf nodes. It is precisely because of physical ordering that...

    - 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

    November 5, 2010 at 5:40 pm

    #1247379

  • RE: Are the posted questions getting worse?

    Lynn Pettis (11/5/2010)

    tosscrosby (11/5/2010)

    ALZDBA (11/5/2010)

    Jack Corbett (11/5/2010)

    Today my oldest son (9) fell off a swing, landed wrong on his arm and is on the way to the ER...

    - 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

    November 5, 2010 at 3:13 pm

    #1247351

  • RE: Are the posted questions getting worse?

    Much luck, Roy. May your rain be soft and pretty, instead of sideways and flipping trees. 😀

    On a lighter note, I made into the top 5 posters 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

    November 5, 2010 at 2:20 pm

    #1247321

  • RE: DATEFIRST setting oddity

    Hey Lutz.

    Yeah, found the 'Monday' equation, which is how I think I went flying up the wrong DATEFIRST when I did a little research behind it on the web. ...

    - 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

    November 5, 2010 at 11:50 am

    #1247268

  • RE: DATEFIRST setting oddity

    Jeff Moden (11/4/2010)

    Craig Farrell (11/3/2010)

    It manipulates DATEFIRST and you might botch something up on your real servers if you run it.

    Setting DATEFIRST in a query only affects the session, 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

    November 4, 2010 at 9:34 pm

    #1246983

  • RE: A Simple Way to Get Row Counts from Multiple tables

    Perhaps something like this?

    select

    o.name,

    i.rowcnt

    from

    sysobjects o

    JOINsysindexes I

    ONo.id = i.id

    where

    o.type = 'u'

    and i.indid IN (0,1)

    order by

    o.name

    - 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

    November 4, 2010 at 3:50 pm

    #1246900

  • RE: Are the posted questions getting worse?

    Greg Edwards-268690 (11/4/2010)

    CirquedeSQLeil (11/4/2010)

    GilaMonster (11/4/2010)

    CirquedeSQLeil (11/4/2010)

    GilaMonster (11/4/2010)

    Gianluca Sartori (11/4/2010)

    Nothing to complain about today?

    Plenty, but I think most people are tired of hearing me whine about the Nightmare Project.

    Nah - do...

    - 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

    November 4, 2010 at 12:52 pm

    #1246772

  • RE: How to store 1/3rd in the database

    Use a higher precision numeric/decimal then you're going to display as. For an example:

    DECLARE @n1a NUMERIC (25, 8),

    @n1b NUMERIC (25, 8),

    @n1c NUMERIC (25, 8),

    @n2 NUMERIC (20, 4),

    @n3 MONEY,

    @n4 NUMERIC...

    - 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

    November 4, 2010 at 12:45 pm

    #1246766

  • RE: PARSING a Concatenated string into columns

    SQL33 (11/4/2010)

    I've been investigating this syslog parsing problem further, and noted using my HEXEditor that the field I need to have parsed (the MSGText field) is actually internally delimited with...

    - 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

    November 4, 2010 at 12:33 pm

    #1246757

  • RE: DATEFIRST setting oddity

    Michael Valentine Jones (11/4/2010)

    There is a nasty gotcha to watch out for if your application is doing connection pooling: The transaction isolation level does not get reset by sp_reset_connection, 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

    November 4, 2010 at 12:32 pm

    #1246755

  • RE: Calculate number of moths between two days?

    Michael Valentine Jones (11/3/2010)

    I mainly wanted to show the logic for how to handle this: "(If date of month >=15 will count as whole month, if <15 will be ignored)...

    - 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

    November 3, 2010 at 10:56 pm

    #1246380

  • RE: DATEFIRST setting oddity

    <------------- Okay, I earned one of these...

    Michael Valentine Jones (11/3/2010)

    What you are missing is the following from SQL Server Books Online under the SET DATEFIRST topic:

    When you have @@DATEFIRST =...

    - 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

    November 3, 2010 at 10:44 pm

    #1246376

  • RE: Error converting nvarchar to float [depending on execution plan]

    SQL-Tucker (11/3/2010)

    Thank you, that is a HUGE help and gets me on the right track.

    At this point I either need to rethink my approach and handle the conversion on 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

    November 3, 2010 at 10:35 pm

    #1246372

  • RE: Error converting nvarchar to float [depending on execution plan]

    SQL-Tucker (11/3/2010)

    You Rock! Thank you!

    FORCE ORDER was exactly what was needed (still need to gauge performance impacts and such but the error is gone)

    Hold up. Force Order is letting...

    - 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

    November 3, 2010 at 7:43 pm

    #1246362

  • RE: Error converting nvarchar to float [depending on execution plan]

    The optimizer doesn't promise it's going to do anything in a specific order, just the fastest it can figure out.

    The WHERE clause is a good start, but the issue 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

    November 3, 2010 at 6:22 pm

    #1246344

Viewing 15 posts - 5,071 through 5,085 (of 5,678 total)