Forum Replies Created

Viewing 15 posts - 21,481 through 21,495 (of 59,072 total)

  • RE: decompress gzipped BLOB with MSSQL-SP

    hurr1k4ne (2/20/2015)

    why not let the app that's using the data warehouse do the unzipping on demand

    Ah, okay got ya! That a good point on storage...

    Because it is a data...

    --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 20, 2015 at 6:34 pm

    #1779087

  • RE: PK v Unique Index

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

    I user request to get an article, which would explain in details the differences between primary key and unique index, especially from disk i/o point...

    --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 20, 2015 at 6:18 pm

    #1779086

  • RE: delete data from partitions - faster approach

    Tara-1044200 (2/20/2015)

    table partitioned by month

    Understood that from your original post. There are two types of partitioning in SQL Server. One is known as "partitioned views", which works...

    --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 20, 2015 at 11:54 am

    #1779034

  • RE: delete data from partitions - faster approach

    Tara-1044200 (2/20/2015)

    I am restoring a database with 10yrs worth of data which have monthly partitions but i would like to keep only 5yrs of data after the restore is done,...

    --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 20, 2015 at 10:29 am

    #1779007

  • 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

Viewing 15 posts - 21,481 through 21,495 (of 59,072 total)