Forum Replies Created

Viewing 15 posts - 26,491 through 26,505 (of 59,099 total)

  • RE: DATABASE SLOW

    rajluves (7/3/2013)

    Hie,

    can any one help me what are the steps to b take when database is running slow?

    This is a huge subject and runs the full gambit from which hardware...

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

    July 3, 2013 at 6:04 pm

    #1629707

  • RE: Probably a very dumb file size question...

    jasona.work (7/2/2013)

    So I was adjusting the size of a DB for a customer (increasing the size of his QA DB) and noticed something. SQL will let you set an...

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

    July 3, 2013 at 5:39 pm

    #1629706

  • RE: Partial match & Update

    DBA12345 (7/3/2013)

    I need update the AppID in table1 by comparing Table2. the data looks like below. Here the problem is AppNames in the both tables are not exactly same but...

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

    July 3, 2013 at 4:20 pm

    #1629699

  • RE: TEMP DB ISSUE

    sqlpanther (7/3/2013)

    hello All ,

    we have issue in our environment where temp db grows very large in 6-8 hrs, the settings are fine and as per standards such as temp db...

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

    July 3, 2013 at 3:53 pm

    #1629694

  • RE: sql quantity sold per day

    Ohhhh, be careful, folks. This looks like a trick question that I might write as an "ace breaker" on an example. If you read the original question, it...

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

    July 3, 2013 at 3:22 pm

    #1629690

  • RE: Implicit conversion using COALESCE or CASE

    Welcome aboard, Mr. Sommarskog. Very nice to have you here.

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

    July 3, 2013 at 3:12 pm

    #1629686

  • RE: tail log backup

    manikanta1207 (7/2/2013)

    when do we take tail-log backup? and how can we take? wt cmds to be used

    This sounds like a series of interview questions. My recommendation is that Gail'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)

    July 3, 2013 at 3:09 pm

    #1629685

  • RE: Xp_cmdshell

    river1 (7/12/2010)

    Hi,

    i am trying to create a xp_cmdshell to execute the DBCC checkDB comand and same the output to a txt file. Can someone help, please?

    Thank you.

    Please see...

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

    July 3, 2013 at 2:59 pm

    #1629682

  • RE: Xp_cmdshell

    @Lowell,

    Thank you for the coded example. Much appreciated. That's kind of what I thought it was going to be but haven't touched VB since 2002 and didn't want...

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

    July 3, 2013 at 2:53 pm

    #1629680

  • RE: Tabs or Spaces

    Steve Jones - SSC Editor (7/3/2013)

    I'd argue these days we should have tools that reformat stuff for us. My company (Red Gate) makes one, but there are others.

    We shouldn't have...

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

    July 3, 2013 at 2:40 pm

    #1629675

  • RE: Xp_cmdshell

    chauhanparixit (7/3/2013)

    use SQLCMD or something.

    How do you do that from VB?

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

    July 3, 2013 at 7:56 am

    #1629541

  • RE: Xp_cmdshell

    Tara Kizer (7/13/2010)

    If you are using a VB application, then there is no need to use xp_cmdshell for this.

    Since I'm no VB expert but still very curious, how would you...

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

    July 3, 2013 at 7:53 am

    #1629539

  • RE: CPU Flat lines and numerous Time Outs

    We had a similar problem in the "early days" of VM. I'm not a VM kinda guy. Someone else always set this up in the environment. That...

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

    July 2, 2013 at 9:41 pm

    #1629351

  • RE: CHARINDEX problem

    Luis Cazares (7/2/2013)

    What are you trying to do? It seems to me that you want either one of these options.

    Without sample data and expected results there's hard to know.

    Select LEFT(FT.DESCAR,CHARINDEX('|',FT.DESCAR)-1)...

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

    July 2, 2013 at 9:33 pm

    #1629349

  • RE: Problem in executing bunch of Insert statements

    Wait a minute, please. There's something I don't understand. It would appear that you're capturing data from one table at a time. Are you telling me that...

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

    July 2, 2013 at 9:19 pm

    #1629347

Viewing 15 posts - 26,491 through 26,505 (of 59,099 total)