Forum Replies Created

Viewing 15 posts - 21,511 through 21,525 (of 59,098 total)

  • RE: Share your best possible answers--

    Alvin Ramard (2/19/2015)

    abhisecks (2/19/2015)

    Tell me about your experience as a SSIS developer?

    I answered-SSIS is nothing but an ETL tool ...

    WRONG!

    SISS can do a lot more than just ETL!

    No disagreement...

    --Jeff Moden

    RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
    First step towards the paradigm shift of writing Set Based code:
    ________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.

    Change is inevitable... Change for the better is not.

    Helpful Links:
    How to post code problems
    How to Post Performance Problems
    Create a Tally Function (fnTally)

    February 19, 2015 at 12:57 pm

    #1778751

  • RE: Share your best possible answers--

    The correction I would make is that the sources that you mention aren't what I'd call "heterogeneous". The sources that you mention are very specific and, although the basic...

    --Jeff Moden

    RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
    First step towards the paradigm shift of writing Set Based code:
    ________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.

    Change is inevitable... Change for the better is not.

    Helpful Links:
    How to post code problems
    How to Post Performance Problems
    Create a Tally Function (fnTally)

    February 19, 2015 at 11:34 am

    #1778731

  • RE: Your Tools

    I've worked in many places that don't allow such tools. That would be a whole 'nuther discussion but, when such a limit happens, you'd better be able to use...

    --Jeff Moden

    RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
    First step towards the paradigm shift of writing Set Based code:
    ________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.

    Change is inevitable... Change for the better is not.

    Helpful Links:
    How to post code problems
    How to Post Performance Problems
    Create a Tally Function (fnTally)

    February 19, 2015 at 8:30 am

    #1778659

  • RE: I wanna be a DBA! What should I do?

    vignesh.ms (2/19/2015)

    Hi There,

    I wanna be a DBA! What should I do?

    Is there any free video tutorials out there ? or suggest me the good way to get there.

    The...

    --Jeff Moden

    RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
    First step towards the paradigm shift of writing Set Based code:
    ________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.

    Change is inevitable... Change for the better is not.

    Helpful Links:
    How to post code problems
    How to Post Performance Problems
    Create a Tally Function (fnTally)

    February 19, 2015 at 8:25 am

    #1778657

  • RE: decompress gzipped BLOB with MSSQL-SP

    I think the point that Gianluca is trying to make is why not let the app that's using the data warehouse do the unzipping on demand instead of storing the...

    --Jeff Moden

    RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
    First step towards the paradigm shift of writing Set Based code:
    ________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.

    Change is inevitable... Change for the better is not.

    Helpful Links:
    How to post code problems
    How to Post Performance Problems
    Create a Tally Function (fnTally)

    February 19, 2015 at 8:06 am

    #1778649

  • RE: WHERE 1 = 1,who uses this besides me

    ChrisM@Work (2/19/2015)

    Eric M Russell (2/18/2015)

    Resender (2/2/2015)

    ok this is something of a best practice of mine in my queries

    I always do

    WHERE 1 = 1

    I can't remember where I picked this habit...

    --Jeff Moden

    RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
    First step towards the paradigm shift of writing Set Based code:
    ________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.

    Change is inevitable... Change for the better is not.

    Helpful Links:
    How to post code problems
    How to Post Performance Problems
    Create a Tally Function (fnTally)

    February 19, 2015 at 8:03 am

    #1778645

  • RE: Non-partitioned table has several partition_ids?

    dajonx (2/19/2015)

    Ah, sorry. Here's the query:

    select *

    from sys.dm_db_partition_stats a

    right join sys.partitions b

    on a.partition_id = b.partition_id

    WHERE b.object_id = OBJECT_ID('tableA')

    The results:

    partition_idobject_idindex_idpartition_numberin_row_data_page_countin_row_used_page_countin_row_reserved_page_countlob_used_page_countlob_reserved_page_countrow_overflow_used_page_countrow_overflow_reserved_page_countused_page_countreserved_page_countrow_countpartition_idobject_idindex_idpartition_numberhobt_idrowsfilestream_filegroup_iddata_compressiondata_compression_desc

    7205760239081881612271514175137233750376000003750376018444957205760239081881612271514175172057602390818816184449501ROW

    NULLNULLNULLNULLNULLNULLNULLNULLNULLNULLNULLNULLNULLNULL7205760277689139212271514171172057602776891392184247401ROW

    NULLNULLNULLNULLNULLNULLNULLNULLNULLNULLNULLNULLNULLNULL7205760277695692812271514171172057602776956928184247401ROW

    NULLNULLNULLNULLNULLNULLNULLNULLNULLNULLNULLNULLNULLNULL7205760277793996812271514171172057602777939968184249801ROW

    NULLNULLNULLNULLNULLNULLNULLNULLNULLNULLNULLNULLNULLNULL7205760277807104012271514171172057602778071040184265801ROW

    NULLNULLNULLNULLNULLNULLNULLNULLNULLNULLNULLNULLNULLNULL7205760278259302412271514176172057602782593024184294401ROW

    7205760278370713612271514171137453780385000003780385018444957205760278370713612271514171172057602783707136184449501ROW

    7205760278377267212271514176144854517453000004517453018444957205760278377267212271514176172057602783772672184449501ROW

    Oh jeez... That's not easy to read. Is...

    --Jeff Moden

    RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
    First step towards the paradigm shift of writing Set Based code:
    ________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.

    Change is inevitable... Change for the better is not.

    Helpful Links:
    How to post code problems
    How to Post Performance Problems
    Create a Tally Function (fnTally)

    February 19, 2015 at 7:55 am

    #1778641

  • RE: DBA Skills: Striped Backup Video

    The video is unreadable even at full screen.

    --Jeff Moden

    RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
    First step towards the paradigm shift of writing Set Based code:
    ________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.

    Change is inevitable... Change for the better is not.

    Helpful Links:
    How to post code problems
    How to Post Performance Problems
    Create a Tally Function (fnTally)

    February 18, 2015 at 4:35 pm

    #1778511

  • RE: Non-partitioned table has several partition_ids?

    dajonx (2/18/2015)

    When querying sys.partitions for a non-partitioned table, there are several partition_ids. Only one record joins with it in sys.dm_db_partition_stats. Is this an error? If so, how...

    --Jeff Moden

    RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
    First step towards the paradigm shift of writing Set Based code:
    ________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.

    Change is inevitable... Change for the better is not.

    Helpful Links:
    How to post code problems
    How to Post Performance Problems
    Create a Tally Function (fnTally)

    February 18, 2015 at 3:54 pm

    #1778504

  • RE: DBA vs. Developer Question / Issue

    Guess I'll be one of the few dissenters here. Although it's a "best practice" to have clustered indexes on all permanent tables, remember that best practices are guidelines to...

    --Jeff Moden

    RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
    First step towards the paradigm shift of writing Set Based code:
    ________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.

    Change is inevitable... Change for the better is not.

    Helpful Links:
    How to post code problems
    How to Post Performance Problems
    Create a Tally Function (fnTally)

    February 18, 2015 at 3:43 pm

    #1778500

  • RE: WHERE 1 = 1,who uses this besides me

    CELKO (2/17/2015)

    Ditto that.

    Agree.

    Department of Redundancy Department 🙂

    🙂

    --Jeff Moden

    RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
    First step towards the paradigm shift of writing Set Based code:
    ________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.

    Change is inevitable... Change for the better is not.

    Helpful Links:
    How to post code problems
    How to Post Performance Problems
    Create a Tally Function (fnTally)

    February 18, 2015 at 6:39 am

    #1778325

  • RE: Are the posted questions getting worse?

    Grant Fritchey (2/17/2015)

    Ed Wagner (2/17/2015)

    Steve Jones - SSC Editor (2/17/2015)

    Hope everyone had a great President's Day. We don't have the snow that Grant does, but we did get 8" or...

    --Jeff Moden

    RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
    First step towards the paradigm shift of writing Set Based code:
    ________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.

    Change is inevitable... Change for the better is not.

    Helpful Links:
    How to post code problems
    How to Post Performance Problems
    Create a Tally Function (fnTally)

    February 18, 2015 at 6:31 am

    #1778324

  • RE: Importing spreadsheet in one single column

    Heh... the OP has left the building! 😛

    --Jeff Moden

    RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
    First step towards the paradigm shift of writing Set Based code:
    ________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.

    Change is inevitable... Change for the better is not.

    Helpful Links:
    How to post code problems
    How to Post Performance Problems
    Create a Tally Function (fnTally)

    February 18, 2015 at 12:29 am

    #1778264

  • RE: Next Business Day

    Joe's suggestion is spot on for this. The only difference that I'd take is that I'd use the underlying date serial numbers for the dates so that you don't...

    --Jeff Moden

    RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
    First step towards the paradigm shift of writing Set Based code:
    ________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.

    Change is inevitable... Change for the better is not.

    Helpful Links:
    How to post code problems
    How to Post Performance Problems
    Create a Tally Function (fnTally)

    February 18, 2015 at 12:28 am

    #1778262

  • RE: chainging isloation level with in the sesssion after closing first tran is correct or not

    Ok. Instead of guessing, setup a test and see what happens. It'll probably take less time to do that what we've already expended on this thread. 😀

    --Jeff Moden

    RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
    First step towards the paradigm shift of writing Set Based code:
    ________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.

    Change is inevitable... Change for the better is not.

    Helpful Links:
    How to post code problems
    How to Post Performance Problems
    Create a Tally Function (fnTally)

    February 18, 2015 at 12:25 am

    #1778261

Viewing 15 posts - 21,511 through 21,525 (of 59,098 total)