Forum Replies Created

Viewing 15 posts - 21,541 through 21,555 (of 59,072 total)

  • RE: Extract substring in SQL Statement

    Tamrak (2/12/2015)

    I tried to extract the information in a field

    Samples of the data:

    "Current Date updated ( 12/31/2015 -> 12/31/2016 )"

    "Status updated ( Open -> Should be Closed )"

    From example 1...

    --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 7:33 pm

    #1777388

  • RE: What are First Steps for a dba in new Office?

    jeffrey yao (2/12/2015)

    I will first try to understand the environment I will manage, such as how many sql instances, SSAS/SSRS/SSIS instances I need to take care of, what are their...

    --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 5:17 pm

    #1777379

  • RE: What are First Steps for a dba in new Office?

    Megistal (2/12/2015)

    IMHO I follows theses:

    1- The DBA job was posted for a business reason. What it is? What management worries the most right now from their own eyes.

    2- Next depending...

    --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 5:16 pm

    #1777378

  • RE: Query Causing Blocking, Locks Table for 1000 Seconds, Help Needed!

    I'm thinking that the following from the original code could be the real problem here. Dunno for sure because I don't know the data but it would be one...

    --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 5:05 pm

    #1777377

  • 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

Viewing 15 posts - 21,541 through 21,555 (of 59,072 total)