Forum Replies Created

Viewing 15 posts - 35,041 through 35,055 (of 59,099 total)

  • RE: Understanding Indexes

    Grant Fritchey (2/15/2011)

    Jeff Moden (2/15/2011)

    Grant Fritchey (2/15/2011)

    Define a clustered index on the column that appears most frequently in the WHERE clause of SELECT

    statements.

    But not in JOIN criteria? No,...

    --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 15, 2011 at 12:16 pm

    #1287258

  • RE: Abnormal growth of temp db

    ganeshkumar005 (2/15/2011)

    I can see abnormal growth of temp db during a update query:

    UPDATE tlstagingdb.dbo.tbltlxyz SET lImpStatus = 10 where limpidentity in ( select xxxxxxxxxxxxxxxxxxxxx)

    select subquery works excellent and 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 15, 2011 at 8:14 am

    #1287103

  • RE: whether really any column gets changed in updated row?

    karthimca07 (2/15/2011)

    checksum uses more resources in my case.

    as i have to check more than 20 columns off different types.

    how columns_updated works?

    if want random columns means how do i please help

    Columns_Updated...

    --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 15, 2011 at 8:08 am

    #1287100

  • RE: Understanding Indexes

    Grant Fritchey (2/15/2011)

    Define a clustered index on the column that appears most frequently in the WHERE clause of SELECT

    statements.

    But not in JOIN criteria? No, no way. The basic...

    --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 15, 2011 at 7:46 am

    #1287082

  • RE: Understanding Indexes

    Gail and Grant (or anyone else that can jump in),

    The article also has the following statements:

    ...[font="Arial Black"]whereas, with a nonclustered index the leaf level contains the address to the 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 15, 2011 at 7:30 am

    #1287062

  • RE: Datewise Cummulative total for particular customer

    chintalagiriprakash (2/14/2011)

    hi Jeff

    i donot know why it is not working i wrote the query as u mention in the link but i could not get the result

    thanks...

    --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 15, 2011 at 12:11 am

    #1286878

  • RE: parse XML using sql

    nadabadan (2/14/2011)

    http://technet.microsoft.com/en-us/library/ms345122(SQL.90).aspx is a good white paper on XQuery that you may want to look at.

    At the bottom of this white paper are links to three other decent xml...

    --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 14, 2011 at 11:12 pm

    #1286868

  • RE: Tuning on parallel processing

    sql_butterfly (2/14/2011)

    Gail, I read your article again and again. That's interesting but still I'm not able to get solution. Can you check for example the attached execution plan and Statistics...

    --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 14, 2011 at 11:08 pm

    #1286866

  • RE: How do I return data as subset of another table?

    darryljm (2/14/2011)

    Example I have two tables "Labor" and "Parts" need to return as follows

    Labor field 1

    Part1

    Part2

    Part3

    Labor field2

    Part1

    Part2

    Part3

    Any help would be appreciated

    I believe you should only have 1 labor field 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 14, 2011 at 10:02 pm

    #1286847

  • RE: Cursor and case function

    frecapi (2/14/2011)

    No I didn't think about that. Something like:

    Select ID, apn, (select permit_1 from #mytable), from #mytable union all

    Select ID, apn, (select permit_2 from #mytable), from #mytable....

    Yep... kind 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 14, 2011 at 10:00 pm

    #1286845

  • RE: Proc runs slow only during business hours?

    You might also want to do a server side trace and find out what's using most of the CPU time.

    --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 14, 2011 at 9:54 pm

    #1286842

  • RE: Cursor and case function

    frecapi (2/14/2011)

    There can only be a maximum of 8 permits per record. There can be more than 8 records per APN in which case the permitnum would equal permit_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 14, 2011 at 9:01 pm

    #1286834

  • RE: Varchar and the data dictionary

    nico van niekerk (2/14/2011)

    I was wondering whether specifying varchar columns as varchar(255) as a minimum size makes any difference as opposed to varchar(10) for example. varchar(255) is still only 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 14, 2011 at 7:03 pm

    #1286821

  • RE: Evaluating Spaces

    Oh yeah... I forgot to mention it... it handles a space as a delimiter, as well.

    --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 14, 2011 at 6:56 pm

    #1286820

  • RE: Evaluating Spaces

    Here's my latest splitter. I'm still testing it to be included in the rewrite of the "Tally Table" article but it blows the doors off the old splitter especially...

    --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 14, 2011 at 6:55 pm

    #1286819

Viewing 15 posts - 35,041 through 35,055 (of 59,099 total)