Forum Replies Created

Viewing 15 posts - 27,511 through 27,525 (of 59,101 total)

  • RE: Naming Convention for UDF's, Views and SP's

    I put most everything in the DBO schema, Crissy. The only time I deviate from that is for utility and scratch objects. Of course, most of the work...

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

    February 11, 2013 at 4:08 pm

    #1586777

  • RE: FTP Sites?

    Lowell (2/11/2013)

    You probably have all the links you needed now Jeff, I'm late to the party on this one, but here's one more:

    Project Gutenberg has a large number of http://ftp...

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

    February 11, 2013 at 4:04 pm

    #1586774

  • RE: Naming Convention for UDF's, Views and SP's

    Synonyms won't work there. Remember, the structure of the table has been modified but the GUIs have to think it hasn't. This is especially true when you add...

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

    February 11, 2013 at 4:03 pm

    #1586772

  • RE: Naming Convention for UDF's, Views and SP's

    Andy Hyslop (2/11/2013)

    I recently has to take a written SQL test for a client and one of the questions got me stumped (from memory was something like this):

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

    February 11, 2013 at 3:40 pm

    #1586768

  • RE: Restore space needed WAY more than bak file size

    As a sidebar, I'm thinking there's something seriously wrong with the database. You're talking about a very small database using almost a quarter of a Terabyte! When you finally...

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

    February 11, 2013 at 3:31 pm

    #1586765

  • RE: Help with sorting this recursion

    The old cursors wouldn't work any better. Recusive CTE's are just another rendition of RBAR.

    What you're missing is a "Hierarchical Path" to preserve the correct sort order. Please...

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

    February 11, 2013 at 3:26 pm

    #1586758

  • RE: Job taking 50 hours to run

    mahesh.dasoni (2/10/2013)

    We will be moving to SAN in couple of weeks but till then we cant ignore the job,it has to run.

    Ok... now I'm totally confused. I thought 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)

    February 11, 2013 at 3:09 pm

    #1586750

  • RE: Interview Questions

    mtassin (2/11/2013)

    The weird thing is... estimated execution plans puts mine ahead. 🙂

    and so did the actual... didn't expect that... I thought PIVOT was not that efficient

    NEVER use comparisons 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)

    February 11, 2013 at 2:57 pm

    #1586745

  • RE: FTP Sites?

    Thanks for the links, Narayana, but I already know how to do the things you have in the articles you provided links to, What I was looking for were...

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

    February 11, 2013 at 2:52 pm

    #1586743

  • RE: Change value of column in last row when doing insert

    SQLAJ (2/11/2013)

    I don't believe I said,

    "will clearly and certainly make a different entry for ONLY the last row inserted."

    I was only trying to provided some information in order to help...

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

    February 11, 2013 at 2:42 pm

    #1586740

  • RE: FTP Sites?

    Jeff Moden (2/11/2013)

    HowardW (2/11/2013)

    How about the National Climate Data Center:

    ftp://ftp.ncdc.noaa.gov/pub/data/gsod

    By Jove! That might be just what the doctor ordered! The files are zipped using Gun-Zip, the directory structure...

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

    February 11, 2013 at 5:45 am

    #1586494

  • RE: FTP Sites?

    anthony.green (2/11/2013)

    I dont know of any off the top of my head, but I do have a private FTP server on a dyndns lookup to my ISP in the UK...

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

    February 11, 2013 at 5:44 am

    #1586491

  • RE: FTP Sites?

    HowardW (2/11/2013)

    How about the National Climate Data Center:

    ftp://ftp.ncdc.noaa.gov/pub/data/gsod

    By Jove! That might be just what the doctor ordered! The files are zipped using Gun-Zip, the directory structure is consistant...

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

    February 11, 2013 at 5:38 am

    #1586486

  • RE: Job taking 50 hours to run

    mahesh.dasoni (2/10/2013)

    I have a 2008 Server(SAN) which is fetching data from 2005 server (Physical server) through linked server.

    Intially both were on SAN and that time the job took 30 mintues...

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

    February 10, 2013 at 11:35 pm

    #1586395

  • RE: TVP in SysObjects

    Vedran Kesegic (2/9/2013)

    Instead of loop, you can just:

    grant execute to public

    That includes all procedures that will be generated in the future in that database and all scalar functions.

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

    February 10, 2013 at 10:58 pm

    #1586388

Viewing 15 posts - 27,511 through 27,525 (of 59,101 total)