Forum Replies Created

Viewing 15 posts - 30,346 through 30,360 (of 59,101 total)

  • RE: precautions before applying critical patches

    Simha24 (4/17/2012)

    Hi,

    Please suggest me is there any other precautions need to take before applying to patches on my sqlservers.

    we are taking

    1.Full backups of each db.

    2.mssqlsystemresource.mdf, mssqlsystemresource.ldf.

    we are having sqlservers...

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

    April 17, 2012 at 9:13 pm

    #1475136

  • RE: Problem with CTE

    Cadavre (4/17/2012)

    Using recursive CTEs to count is bad.

    ... {snip} ...

    Personally, I can't think of a good reason to use something that I know is massively slower than other alternatives.

    You did...

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

    April 17, 2012 at 9:08 pm

    #1475135

  • RE: Problem with CTE

    capn.hector (4/17/2012)

    thanks for the tally table code, im still working on getting it through my head exactly how to use them and keep reading every thing on the web i...

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

    April 17, 2012 at 8:57 pm

    #1475133

  • RE: Failsafe way of converting floats to chars?

    aaa-322853 (4/17/2012)

    I guess if this is the best method I go down this route and carry out a round of testing with the customer.

    If you have such a rapport with...

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

    April 17, 2012 at 8:51 pm

    #1475132

  • RE: Question about dbcc shrinkfile

    Simon-413722 (4/16/2012)

    Please note that this question is for educational purpose, not that I would perform shrink database.

    Simon-413722 (4/16/2012)

    I hardly use dbcc shrinkdatabase for shrinking dev database and only ever...

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

    April 17, 2012 at 8:29 pm

    #1475130

  • RE: Want to modify the content of the cols

    hbanerje (4/17/2012)

    for example I have a table, which has ID, Service, Subservice cols.

    I want to modify or change 'Surgery Service' to 'XXX-Surgery' for the "Service" col where ID = 123,

    and...

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

    April 17, 2012 at 8:16 pm

    #1475128

  • RE: New to SQL

    My recommendation would be to not use SQL Express even though it's free especially if you want to get into BI. My recommendtion would be to buy a copy...

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

    April 17, 2012 at 8:12 pm

    #1475127

  • RE: how can i insert in udf

    Actually, never mind. I missed page 2 and now I see the OP closed the 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)

    April 17, 2012 at 7:58 pm

    #1475124

  • RE: how can i insert in udf

    hbtkp (4/16/2012)

    this is what i have to figure out ,how they calculate it.

    No problem. Please post the data in the readily consumable format identified in the article in 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)

    April 17, 2012 at 7:45 pm

    #1475123

  • RE: how can i insert in udf

    hbtkp (4/16/2012)

    it snot running total,if you see it carefully,

    its not just adding values. sometimes its adding 1 ,sometimes it minus 1

    That is what is known as a "running total".

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

    April 17, 2012 at 7:42 pm

    #1475122

  • RE: How do you count percentage?

    If you'd like a tested answer, put the sample data in a format like the one identified in the article at the first link in my signature line below. 🙂

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

    April 17, 2012 at 7:34 pm

    #1475121

  • RE: Dropping indexes with low read to write ratio?

    SQLKnowItAll (4/17/2012)

    I've dropped some indexes that have 0 reads (or very few) and a high number of writes.

    If I did that, I'd be fired. If you don't know why 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)

    April 17, 2012 at 6:41 pm

    #1475107

  • RE: URGENT PLEASE Got a SQL Scenario to solve

    GSquared (4/17/2012)

    Jeff Moden (4/15/2012)

    vm.chowdary85 (4/14/2012)

    hello everyone.

    i got a scenario like this i got 5 parent tables and 30 child tables in the source using SSIS control flow and data flow...

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

    April 17, 2012 at 6:14 pm

    #1475103

  • RE: URGENT PLEASE Got a SQL Scenario to solve

    vm.chowdary85 (4/14/2012)

    hello everyone.

    i got a scenario like this i got 5 parent tables and 30 child tables in the source using SSIS control flow and data flow i need...

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

    April 15, 2012 at 9:47 pm

    #1473831

  • RE: URGENT PLEASE Got a SQL Scenario to solve

    CELKO (4/15/2012)

    The terms parent and child are not RDBMS; they are from the old network DBs. We have referenced and referencing tables which is very different.

    Only a couple of...

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

    April 15, 2012 at 9:39 pm

    #1473830

Viewing 15 posts - 30,346 through 30,360 (of 59,101 total)