Forum Replies Created

Viewing 15 posts - 32,581 through 32,595 (of 59,099 total)

  • RE: simple sp

    CELKO (9/11/2011)

    There are no magi val universal "id" in RDBMS.

    Sure there is... it's called an IDENTITY column and it has several purposes... one is to provide uniqueness 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)

    September 11, 2011 at 9:46 pm

    #1379777

  • RE: My query runs very slowly whith special where clause!

    I agree with Dave... simply not enough information to help. Please read the article at the link that Dave posted.

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

    September 11, 2011 at 9:20 pm

    #1379774

  • RE: SELECT INTO

    sunny.tjk (9/11/2011)

    Not sure what you meant by the second table?

    Quite literally... make a copy of the table at the schema level. Generate the CREATE TABLE statement for the original...

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

    September 11, 2011 at 9:18 pm

    #1379773

  • RE: Cursor Causing Performance Issues

    CELKO (9/11/2011)

    Darn, I need to rewrite 150+ reports of mine. Too bad they actually do what they need, and fast too :-D.

    You should not be writing reports...

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

    September 11, 2011 at 1:14 pm

    #1379735

  • RE: How to ensure a job only runs for a set duration?

    winston Smith (9/9/2011)

    I have 60 mins a day for index maintenance. I want to rebuild the indexes one at a time, based on their usage, rebuilding the most used indexes...

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

    September 11, 2011 at 12:57 pm

    #1379729

  • RE: use bcp for export query result to excel

    elham_azizi_62 (9/11/2011)

    hi all.

    I use this code for export query result to excel file

    set @x = 'bcp "SELECT top 10 [TBL_CustomerID],[TBL_CustomerTitle]

    FROM [dbname].[dbo].[TBL_Customer]" queryout c:\test.xls -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)

    September 11, 2011 at 12:42 pm

    #1379725

  • RE: sql server MCQs , at DBA level

    Grant Fritchey (2/21/2011)

    Further, employers will do internet searches based on your name. They can find this thread and will certainly be less inclined to hire someone as a trusted database...

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

    September 11, 2011 at 12:35 pm

    #1379721

  • RE: Convert Mainframe numbers

    lnelson (9/11/2011)

    I have a table (checkmaster) which was created by importing from an IBM mainframe system. The numeric values are in the mainframe format (stored as varchar(50) in my...

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

    September 11, 2011 at 12:26 pm

    #1379716

  • RE: simple sp

    LutzM (9/11/2011)

    I guess Jeff asked to decide whether a CrossTab or a DynamicCrossTab would be required.

    As usual, spot on, Lutz. Not my job to judge but nicely done 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)

    September 11, 2011 at 12:06 pm

    #1379713

  • RE: simple sp

    And what would you like to do if there are more than 2 (or even more) ID2's for a given File Number? Or are you willing to guarantee 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)

    September 11, 2011 at 1:58 am

    #1379667

  • RE: TSql help

    npeters 86796 (9/10/2011)

    Thank you my friend this works perfectly.

    Thank you for the feedback but I'm still curious... what do you have in place that guarantees that f.docdate will always be...

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

    September 11, 2011 at 1:54 am

    #1379666

  • RE: Cursor Causing Performance Issues

    @sqlsatyam,

    I agree with Gail (Gila Monster)... we need to see the stored procedure that you're calling in the cursor. One of the very few things that Celko is likely...

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

    September 11, 2011 at 1:39 am

    #1379664

  • RE: Cursor Causing Performance Issues

    I disagree. Using Temp Tables to "Divide'n'Conquer" is frequently much more efficient that using CTE's or derived tables to do a complicated task.

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

    September 11, 2011 at 1:38 am

    #1379663

  • RE: IDENTIFIERS !!!

    karthikeyan-444867 (9/10/2011)

    Hi All,

    I have recently answered some questions under 'QOD' section. I saw the below one and it looks strange for me.

    create table [VARRAY[]]]

    (

    eno int

    )

    When i execute the above code,...

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

    September 10, 2011 at 9:55 am

    #1379611

  • RE: SQL Standards

    You might want to continue your good use of GOOGLE to search for those two terms. For example, you get some really great hits if you search for "backward...

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

    September 10, 2011 at 9:10 am

    #1379604

Viewing 15 posts - 32,581 through 32,595 (of 59,099 total)