Forum Replies Created

Viewing 15 posts - 47,461 through 47,475 (of 59,102 total)

  • RE: StaticvsDynamic queries

    clive (11/3/2008)

    1. Static query: (Clustered Index Seek cost is 100% - estimated execution plan)

    Select * from tblContract_Instal1

    where Contract_No = 4669

    2. Dynamic query: (Clustered Index Seek cost not shown -...

    --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)

    November 3, 2008 at 8:08 pm

    #893384

  • RE: Change datatype

    Mike Levan (10/31/2008)

    I am changing datatype int to varchar(10) whata re the pros and cons, will i lose any data by any chance, what is the gud approach and how.

    thanks

    Ummm......

    --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)

    November 3, 2008 at 8:03 pm

    #893383

  • RE: convert string to int in ssis

    The "E" indicates either "Engineering Notation" or "Scientific Notation". The "E+11" means "Times 10 to the 11th power". It won't fit into an INTEGER, but it will fit...

    --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)

    November 3, 2008 at 7:59 pm

    #893381

  • RE: Please need help on looping through the dataset!!!

    Awesome to know... thanks for the compliment, Seth. I really appreciate it. Heh... I also appreciate you getting to all of these before me! Makes my life...

    --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)

    November 3, 2008 at 7:54 pm

    #893380

  • RE: Tune Query

    What indexes do you have on the 3 tables?

    --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)

    November 3, 2008 at 7:45 pm

    #893379

  • RE: Relationships between views?

    Are you saying that you've revoked base table rights from users on a reporting database? If so, give it back!

    --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)

    November 3, 2008 at 7:25 pm

    #893376

  • RE: Parsed string into a view

    Robert,

    Take a look at the following article. It explains what a Tally table is, how it works, has a couple of examples including how to split a whole table's...

    --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)

    November 3, 2008 at 7:22 pm

    #893374

  • RE: Auto grow option

    Matt Miller (11/3/2008)

    I would usually advise to leave autogrow on. Not leaving auto-grow on means your database runs the risk of running out of space, in which case everything...

    --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)

    November 3, 2008 at 7:16 pm

    #893373

  • RE: Introduction to DML Triggers

    Dang it, Jack! Somehow I missed this article when it was published. Found it as a link in one of your good posts. Awesome article especially for...

    --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)

    November 3, 2008 at 6:53 pm

    #893365

  • RE: Page Splits

    mark.hall (11/3/2008)

    I've got an SQL server where my avg. page splits per second is 3-4. However there is process that runs twice a day when this process is running...

    --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)

    November 3, 2008 at 6:30 pm

    #893361

  • RE: compressing / collapsing numbers

    OMG! LMAO! Stop it! {Clutching at sides trying to catch a breath} That's just too funny! 😛

    --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)

    November 3, 2008 at 6:21 pm

    #893359

  • RE: using CLR assembly

    J (11/3/2008)

    Never used CLR yet. This was supposed to be the greatest thing since sliced bread.

    Jeff, would you please enlighten me as to why CLR is viewed as a bad...

    --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)

    November 3, 2008 at 6:18 pm

    #893356

  • RE: Subquery and Join (Speed)

    I appreciate the comments guys. Thank you very much. Perhaps I will write it up as an article with a couple of more "gotcha" examples... Thanks again.

    --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)

    November 3, 2008 at 6:11 pm

    #893354

  • RE: Query data with manipulation

    jack_hc (11/3/2008)

    Jeff Moden (10/31/2008)

    jack_hc (10/30/2008)

    Hi,

    I am facing a problem to extract data from a table, the table contains over 41k records, and some of them(>5k) share same column value, now...

    --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)

    November 3, 2008 at 5:58 pm

    #893351

  • RE: Please need help on looping through the dataset!!!

    It's amazing, even to me, how often that particular solution has been used, lately. Nice job, Seth. 🙂

    --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)

    November 3, 2008 at 5:55 pm

    #893350

Viewing 15 posts - 47,461 through 47,475 (of 59,102 total)