Forum Replies Created

Viewing 15 posts - 21,571 through 21,585 (of 59,098 total)

  • RE: foreach loop in sql

    nwtsqlserv (2/12/2015)

    Jeff Moden (2/11/2015)

    nwtsqlserv (2/11/2015)

    I already have a spitter function mate...please have a read through my question again...thanks.

    Could you post the code for your splitter, please?

    CREATE FUNCTION [dbo].[StringSplitter]

    (

    @String varchar(5000),

    @Delimiter char(1)

    )

    RETURNS...

    --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 12, 2015 at 4:56 pm

    #1777375

  • RE: Traversing down a tree

    CELKO (2/12/2015)

    I did not design or build the database and as it is controlled by a different group so I have no say in that aspect of it - 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)

    February 12, 2015 at 3:48 pm

    #1777372

  • RE: Super long running queries (bad users)

    Killing even the most ridiculous users sessions is a really good way to need an updated resume. I know it takes a whole lot longer to do but proper...

    --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 12, 2015 at 1:05 pm

    #1777346

  • RE: Want to create random alphanumeric characters for primary key values

    carrieathomer (2/12/2015)

    which is better for performance GUID or sequence

    thanks

    Since a GUID (UniqueIdentifier/NEWID()) is based on a pseudo-random number and is 16 bytes long where a sequence is typically narrow (8,...

    --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 12, 2015 at 12:50 pm

    #1777343

  • RE: Help!!!

    Agreed. The more you know, the longer the answers to such "simple" questions will 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)

    February 12, 2015 at 10:40 am

    #1777302

  • RE: Traversing down a tree

    mark.worthen (2/12/2015)

    Jeff Moden (2/12/2015)

    Again, even though he's obnoxious as hell, Celko's right about one thing. The whole shebang should be recreated as a separate table that contains Nested Sets....

    --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 12, 2015 at 9:19 am

    #1777281

  • RE: Audit

    sqlserver12345 (2/12/2015)

    I have a generic question.I need to define the scope for a SQL server database 2008 audit.There could be several parameters which can part of the scope.But I have...

    --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 12, 2015 at 8:25 am

    #1777260

  • RE: Run all stored procedures in a database

    richardmgreen1 (2/12/2015)

    Hi all

    I'm looking for an easy way to run all stored procedures in a database that match a specified criteria.

    Under normal curcumstances, I'd create a "master" procedure that would...

    --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 12, 2015 at 8:03 am

    #1777254

  • RE: Help!!!

    somubhandaru23 (2/11/2015)

    if you want to copy a small table with its data into a new table, what is your best option. (if select into answer, ask why it would 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)

    February 12, 2015 at 8:02 am

    #1777253

  • RE: Very little space of harddisk problem

    WhiteLotus (2/11/2015)

    Thanks so much for your explanation ! Thats kind of you ..

    I just got approval to add 1 new drive which is 100 GB so I will move 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)

    February 12, 2015 at 1:30 am

    #1777155

  • RE: Traversing down a tree

    Ok. First, some more test data. I borrowed some numbers from the hierarchy article folks previously posted a link to. One "tree" looks like this but, 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 12, 2015 at 1:22 am

    #1777154

  • RE: foreach loop in sql

    nwtsqlserv (2/11/2015)

    I already have a spitter function mate...please have a read through my question again...thanks.

    Could you post the code for your splitter, 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, 2015 at 6:47 pm

    #1777124

  • RE: Intermittent error: Cannot open database "DBNAME" requested by the login. The login failed. Login failed for user 'USER'.

    lfajardo (2/11/2015)

    We ended up fixing the problem by rebooting our database server and applications servers that connect to it. Still unclear what caused the problem, if someone has any...

    --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, 2015 at 4:43 pm

    #1777108

  • RE: Traversing down a tree

    mark.worthen (2/11/2015)

    CELKO (2/11/2015)

    Please follow basic Netiquette and post the DDL we need to answer this. Follow industry and ANSI/ISO standards in your data. You should follow ISO-11179 rules for naming...

    --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, 2015 at 4:08 pm

    #1777106

  • RE: Traversing down a tree

    CELKO (2/11/2015)

    Please follow basic Netiquette and post the DDL we need to answer this. Follow industry and ANSI/ISO standards in your data.

    {snip}

    You talk about the bugs as a hierarchy. Since...

    --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, 2015 at 3:59 pm

    #1777105

Viewing 15 posts - 21,571 through 21,585 (of 59,098 total)