Forum Replies Created

Viewing 15 posts - 34,906 through 34,920 (of 59,099 total)

  • RE: storage and performance issues of using NVarchar(Max)

    This was done as that database pre-allocated space to the size of text blocks indicated, and if defined as 1 block of max 4k chars would be very wasteful 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 27, 2011 at 1:55 pm

    #1292063

  • RE: ERD Software Needed

    SQL_Student (2/26/2011)

    Any suggestions on a recommended open source software that is fast, simple, and thorough in helping me design a ERD for my database? Thank you

    SQL Server comes with such...

    --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 27, 2011 at 1:34 pm

    #1292061

  • RE: sql remote access

    I'll also remind folks that SQL Server Standard Edition and Enterprise Editions require Windows Server, as well. SQL Server Express and Developer's Editions will install on the desktop edition...

    --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 27, 2011 at 1:25 pm

    #1292060

  • RE: Push data from SQL Server to Java Application Server

    A lot of my peers will tell you to use XML for such a thing. I'm not such a big fan of XML because of the overhead involved 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)

    February 27, 2011 at 1:21 pm

    #1292058

  • RE: How to solve this 2 query

    daveriya (2/27/2011)

    this is not a my hw,and this forum is about to help each other,i m learning so many things.

    and i am learning through this blog

    You have to pardon us,...

    --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 27, 2011 at 1:08 pm

    #1292056

  • RE: Programaticaly determine relation between two tables

    Yes, there are a couple of ways although none of them are guaranteed to be correct because of the "human element" during table design.

    You could look for duplicate column names...

    --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 27, 2011 at 1:00 pm

    #1292054

  • RE: Trim Function help

    rocky_498 (2/26/2011)

    Hi Guys,

    I have question regarding Trim function,

    Here is my requirement,

    Address = ADDRESS1+ADDRESS2+ADDRESS3

    I want to trim if there is no Address1 or Address3

    I know i can use...

    --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 27, 2011 at 12:34 pm

    #1292052

  • RE: user defined function

    mwwheeler (2/25/2011)

    Ive created a user defined function

    dbo.UDF_ParseNumChars

    when I try to use it in a select statement, its not being recognised

    'UDF_ParseNumChars' is not a recognized built-in function name.

    im trying to execute...

    --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 27, 2011 at 10:31 am

    #1292046

  • RE: Windowed Function Where Clause

    Simon Davidson (2/27/2011)

    Hi guys,

    Thanks for your responses. Unfortunately the query is for a system that won't be going Live till April. I'm expecting to get some historic data...

    --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 27, 2011 at 10:16 am

    #1292042

  • RE: How to solve this 2 query

    Craig Farrell (2/25/2011)

    My question, and yes it's a serious one, not just a rant:

    2) At the end of each month, a new table is created for each bank that contains...

    --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 27, 2011 at 9:43 am

    #1292039

  • RE: SQL & the JOIN Operator

    Paul,

    Isn't this a bit like the article you wrote on designing databases? While I agree with all the things you've stated, entire books have been written on how 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)

    February 27, 2011 at 7:37 am

    #1292034

  • RE: Are the posted questions getting worse?

    WayneS (2/25/2011)

    Jeff Moden (2/25/2011)

    uf curs ah gots ta haz abito funz hurinder too! 😛

    I don't get this 'hurinder" part...

    "Here'n'There". 😛

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

    #1291875

  • RE: Return records at least 10 minutes apart from last valid record without CURSOR

    bobhines (2/25/2011)

    Couldn't you create a table valued function and then do a global find and replace, replacing the table name with the name of your table valued function, e.g., "Race_Report"...

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

    #1291874

  • RE: Varchar and the data dictionary

    nico van niekerk (2/21/2011)

    Some folks think using varchar(max) as a declared variable in a SP would give them more than 8K. It doesn't because there is no underlying object 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)

    February 25, 2011 at 7:54 pm

    #1291873

  • RE: Temp DB

    subha.mcts2005 (2/24/2011)

    TempDB size is 10 GB.

    In that case, it sounds like someone made an accidental many-to-many query (ie, partial Cross Join that looks like an Inner Join).

    --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 25, 2011 at 7:51 pm

    #1291872

Viewing 15 posts - 34,906 through 34,920 (of 59,099 total)