Forum Replies Created

Viewing 15 posts - 35,926 through 35,940 (of 59,099 total)

  • RE: retrieve Column Names from Table and Used in QUERY

    parth83.rawal (11/25/2010)

    That is what i am doing...:)

    Anyways really thanks for the reply. This makes me confident about my approach 🙂

    Thanks

    Parth

    You'll have to understand that we didn't think so because 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)

    November 25, 2010 at 8:53 pm

    #1255684

  • RE: How to Insert Million of records in less time ?

    MTY-1082557 (11/24/2010)

    I need to insert between 1 Million to 4 million of rows into a table. Part of my process is pretty fast, but the insertion of this rows take...

    --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 25, 2010 at 8:49 pm

    #1255682

  • RE: How can do syntax check with osql and sqlcmd

    matthew.lau (11/24/2010)

    SQL Analyzer can perform syntax check before actual SQL execution. Is there any way to do syntax check with osql and sqlmcd? thx

    I agree. They don't. 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)

    November 25, 2010 at 8:47 pm

    #1255680

  • RE: JOIN Question

    @Grinja,

    I just want to make sure I'm seeing the data correctly. It looks like you have account #1 called "BLUE" and it is owned by [font="Arial Black"]both [/font]"Fred" 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)

    November 25, 2010 at 8:44 pm

    #1255678

  • RE: temp table usage

    grahamc (11/25/2010)

    You [font="Arial Black"]should [/font]be creating the #temp table and then doing the appropriate INSERT

    I've gotta say that, with certain exceptions, I totally disagree with that statement. Please explain...

    --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 25, 2010 at 8:38 pm

    #1255676

  • RE: Help with SQL SCRIPT Causing Deadlock

    Eddie Wuerch (11/23/2010)

    Note: Sessions can deadlock themselves, due to parallelism. Rare, but it happens, and troubleshooting it is a real pain.

    Not one hand clapping so much as the fingers...

    --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 25, 2010 at 8:25 pm

    #1255675

  • RE: xp_cmdshell

    longingfriend (4/28/2003)

    USE master

    EXEC xp_cmdshell 'print /D:\\server-3\\hp4100 C:\temp.txt'

    OutPut

    1 Enable to initialize device \\server-3\\hp4100

    2 NULL

    Are you sure the output isn't ...

    1 [font="Arial Black"]U[/font]nable to initialize device \\server-3\\hp4100

    ???

    Also,...

    --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 25, 2010 at 8:19 pm

    #1255674

  • RE: Cannot delete db on sqlserver

    Build a new, empty database. Detach it and then try restoring that to the "bad entry". I've only had to do that once so I don't know if...

    --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 25, 2010 at 8:03 pm

    #1255671

  • RE: Cannot delete db on sqlserver

    reshma_t22 (11/24/2010)

    Delete the entry from sysdatabase system table.

    First, direct manipulation of system tables is an extraordinarily BAD idea. Second, it's very difficult to do. I'm thinking that even...

    --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 25, 2010 at 8:01 pm

    #1255670

  • RE: Database Standards Parsing

    Joe Fuller (11/25/2010)

    Hi,

    in our environment Developers are responsible for supplying script or scripts to be applied to Test/Prod environments. We have situation where Developers code scripts that don't meet DBA...

    --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 25, 2010 at 7:57 pm

    #1255668

  • RE: Copying data from multiple related tables

    WO (11/25/2010)

    You don't need a cursor to make this work, if you copy the project (insert into project (columns except identity column) select (columns except identity column) from project where...

    --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 25, 2010 at 7:53 pm

    #1255667

  • RE: SQL to Oracle & ViceVersa

    soundlogic (11/25/2010)

    what do you mean by crowd ramblers?

    It means that the usage of phrases like "dependency inversion principle " don't mean much to the common person. You need 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)

    November 25, 2010 at 7:48 pm

    #1255666

  • RE: cross apply

    kevin4u06 (11/24/2010)

    This is the table and sample data (Attached below)

    my out put shoud be something like this.

    My function does the splitting of the address field .

    Thank you in advance

    A .JPG...

    --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 25, 2010 at 1:12 am

    #1255467

  • RE: how many variables can I have?

    ColdCoffee (11/22/2010)

    make use of some [font="Arial Black"]SET-based code to loop [/font]

    Whiskey Tango Foxtrot, CC?????? 😉

    --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 25, 2010 at 12:44 am

    #1255459

  • RE: temp table usage

    shaun.stuart (11/24/2010)

    Temp tables are created and stored in the temdb system database, so look for bottlenecks there. Is tempdb on its own drive and not on the same drive as...

    --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 25, 2010 at 12:41 am

    #1255458

Viewing 15 posts - 35,926 through 35,940 (of 59,099 total)