Forum Replies Created

Viewing 15 posts - 34,591 through 34,605 (of 59,099 total)

  • RE: What steps to follow, If there is an open transaction on Database server?

    Ali Tailor (3/15/2011)

    Hi

    Lowell, and All

    It is what I was expecting From experts, thank you very much Lowell for a detail reply.

    Ummm... they actually forgot to mention taking the offending user...

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

    March 15, 2011 at 9:58 pm

    #1299202

  • RE: Formatting the value of a parameter

    I agree with Daniel. That "field" appears to be a GUID. GUID's of that nature will always be 32 bytes. You could simply take the RIGHT(33) 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)

    March 15, 2011 at 9:55 pm

    #1299201

  • RE: Are table restores possible

    Actually, there's another way depending on how far back you need to go. In a previous company, we used the abilities of our EMC SAN to build an exact...

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

    March 15, 2011 at 9:37 pm

    #1299200

  • RE: Group by

    GSquared (3/15/2011)

    Also, using parsename in this fashion requires more complex documentation, since it's being used in a fashion that it isn't designed for. Anyone looking up "parsename" in BOL/MSDN...

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

    March 15, 2011 at 9:19 pm

    #1299199

  • RE: Max Memory

    OCTom (3/11/2011)

    Philip Barry (3/11/2011)

    We run several servers, however, for our main OLTP cluster each node is 12 core (2 sockets x 6 core) running 128GB RAM. This was a 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)

    March 15, 2011 at 9:01 pm

    #1299196

  • RE: Varchar to datetime

    sqlserver12345 (3/10/2011)

    I have a column with datatype as varchar.

    I am writing a select statement and need to show the data in the below format.

    MM/DD/YYYY

    Having dates and times stored in...

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

    March 15, 2011 at 8:44 pm

    #1299195

  • RE: Page Size 8K

    The maximum sized datatype, not including the MAX data types, is 8016 (SQL_Variant). For all the

    other datatypes, the max row size can actually be less than 8060 because...

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

    March 15, 2011 at 8:35 pm

    #1299194

  • RE: Split Comma Seperate Column Problem

    jscot91 (3/15/2011)

    Here is my source data

    Description

    D-1,D2

    D-2,D-U,T1

    U-5,T2,K-5,T3

    NULL

    Here is the expressions i am using in "Derived Column"

    Col1 = SUBSTRING(Description,1,FINDSTRING(Description,",",1) - 1)

    Col2 = SUBSTRING(Description,FINDSTRING(Description,",",1) + 1,FINDSTRING(Description,",",2) - FINDSTRING(Description,",",1) - 1)

    Col3 = SUBSTRING(Description,FINDSTRING(Description,",",2) +...

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

    March 15, 2011 at 8:02 pm

    #1299190

  • RE: How To Work with Files based on file name patterns

    YSLGuru (3/15/2011)

    Jeff

    Don't laugh but I'm not that familiar with Command line syntax and so I never thought about trying something like xp_DirTree. Do you know of any examples using...

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

    March 15, 2011 at 7:50 pm

    #1299188

  • RE: T-SQL Help

    MattW2010 (3/15/2011)

    I don't have any questions. Thanks for asking. I actually already got feedback from the biz and that's exactly what they were looking for!

    You should ask 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)

    March 15, 2011 at 4:00 pm

    #1299156

  • RE: Scripting for deployment

    Thats always going to be a problem, then.... users not having enough privs to do their jobs.

    My recommendation would be to give those users bulk admin privs.

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

    March 15, 2011 at 3:52 pm

    #1299151

  • RE: bulk insert system date and time

    Jeff Moden (3/15/2011)

    Then my recommendation is to add GETDATE() to the table column as a default and create an "INSERT" view so you can skip it using BULK INSERT 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)

    March 15, 2011 at 3:49 pm

    #1299150

  • RE: bulk insert system date and time

    Then my recommendation is to add GETDATE() to the table column as a default and create an "INSERT" view so you can skip it using BULK INSERT and have 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)

    March 15, 2011 at 3:46 pm

    #1299149

  • RE: how to replace a particular values in coumn names

    If there was a common naming convention for keys and indexes, this change will wipe out any automation associated with such things.

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

    March 15, 2011 at 3:41 pm

    #1299145

  • RE: Displaying Sorted Hierarchies (SQL Spackle)

    @sean-2,

    Did you get my email?

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

    March 15, 2011 at 3:34 pm

    #1299143

Viewing 15 posts - 34,591 through 34,605 (of 59,099 total)