Forum Replies Created

Viewing 15 posts - 44,626 through 44,640 (of 59,095 total)

  • RE: Urgent : Sql server db tuning

    Yeah... I'm still curious, too. Someone posted a suggestion to use Java on this and, as I asked in a previous post on this thread, I'd really like 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)

    March 13, 2009 at 10:51 pm

    #959625

  • RE: Select distinct row on SQL 2000. Please help me!

    There are many solutions on this thread, so we're not sure which solution you're talking about.

    While I "have you on the phone", can you tell me what the business requirements...

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

    March 13, 2009 at 10:42 pm

    #959623

  • RE: SQL Server 2005 Paging – The Holy Grail

    For my ends, the 'holy grail' approach is absolutely the fastest and most efficient technique

    Heh... sure... 7 to 8 seconds compared to just over a second. I'm sure...

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

    March 13, 2009 at 10:38 pm

    #959621

  • RE: sql_variant

    Steve Mong (3/13/2009)

    Certain classes of apps can't anticipate the data types they'll be required to store, manipulate, etc.

    Master Data Management apps have always been prominent examples (wherein Oracle's product...

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

    March 13, 2009 at 10:31 pm

    #959619

  • RE: split date and time from datetime

    vijays (3/13/2009)

    select convert(datetime, convert(float, getdate()) - floor(convert(float, getdate())))

    Unfortunately, this is one of the posts where the original post made by the OP isn't even close to what the OP actually...

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

    March 13, 2009 at 6:25 am

    #959031

  • RE: How do I select a specific entry from a select top nn statement

    RBarryYoung (3/11/2009)

    PeterR (3/11/2009)

    OK Jeff - Why is it necessary?

    (Hope I got the question right)

    Since that wasn't the question that Jeff wanted, I'll answer this one, ...:D

    They are necessary because all...

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

    March 13, 2009 at 12:15 am

    #958918

  • RE: Please clarify

    prvreddy (3/12/2009)

    Hi guys,

    Yesterday, I attended one interview for DBA.I got following questions.But i didn't answers these questions.Please help me in this regard.

    1)if log file fills 100% then how...

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

    March 13, 2009 at 12:09 am

    #958917

  • RE: Are the posted questions getting worse?

    Grant Fritchey (3/12/2009)

    My favorite snooty response, mainly because I've received it several times, "You're being far too SQL Server specific. What happens when you need to switch platforms?"

    My favorite...

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

    March 12, 2009 at 9:41 pm

    #958896

  • RE: Are the posted questions getting worse?

    Alvin Ramard (3/12/2009)

    Steve Jones - Editor (3/12/2009)

    I'm just glad they're coming here instead of Google first 🙂

    Yeah. You can buy pork chops in bulk now and get a much...

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

    March 12, 2009 at 9:32 pm

    #958895

  • RE: SQL Server 2005 Paging – The Holy Grail

    Jeff Moden (3/12/2009)

    C. Westra (3/12/2009)

    I'm afraid differences in resources are partly induced by Sql Server caching (intermediate) results between the first and latter queries.

    If you use DBCC DROPCLEANBUFFERS between 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)

    March 12, 2009 at 9:26 pm

    #958894

  • RE: SQL Server 2005 Paging – The Holy Grail

    C. Westra (3/12/2009)

    I'm afraid differences in resources are partly induced by Sql Server caching (intermediate) results between the first and latter queries.

    If you use DBCC DROPCLEANBUFFERS between the queries, caches...

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

    March 12, 2009 at 9:10 pm

    #958891

  • RE: SP naming convention policy

    Sorry... almost for got...

    select @name where @name like ''_\_[a-z][a-z][a-z]\_%'' ESCAPE '\'

    The code above is one way to use underscores as both a single character wild card and a "literal". ...

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

    March 12, 2009 at 9:07 pm

    #958890

  • RE: SP naming convention policy

    dallas13 (3/12/2009)

    well i agree but irrespective of all tht we r going to create new system , we are building it from scratch..

    Now so far i m using NAme facet...

    Where...

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

    March 12, 2009 at 9:01 pm

    #958888

  • RE: Can I make this any faster

    chrisau168 (3/12/2009)

    hey mate

    what's authority

    rules were made so you know what you are breaking

    and you are only breaking them "only" when you get caught

    BWAA-HAA!!! Now THAT's ironic... THAT's probably...

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

    March 12, 2009 at 8:06 pm

    #958881

  • RE: Get Month Name

    karthikeyan (3/12/2009)

    A little modification in Jeff's code.

    SELECT DateName(mm,DATEADD(mm,MonthNumber,-1))

    Yep... good call.

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

    March 12, 2009 at 6:55 pm

    #958866

Viewing 15 posts - 44,626 through 44,640 (of 59,095 total)