Forum Replies Created

Viewing 15 posts - 10,651 through 10,665 (of 26,489 total)

  • RE: Cannot defrag indexes

    Perry Whittle (7/18/2012)

    Paul Randal details indexes in this article

    Thanks for the link. I'll save for later. At this time I have learned the error of my ways and...

    July 18, 2012 at 9:21 pm

    #1514592

  • RE: Shrinking DB not working

    vikrantspatil (7/18/2012)

    For the record, shrinking data files is not a good idea in the first place.

    My reasoning is based on the following blog by Paul Randall and we all...

    July 18, 2012 at 4:01 pm

    #1514564

  • RE: Time Zones

    jbnv (7/18/2012)

    djackson 22568 (7/18/2012)

    jbnv (7/18/2012)

    Given Americans' obnoxious refusal to use common-sense things like the metric system and dollar coins instead of bills, would probably never happen.

    Wow.

    <rant response to inappropriate post>

    One...

    July 18, 2012 at 3:59 pm

    #1514563

  • RE: Cannot defrag indexes

    pooyan_pdm (7/18/2012)

    To be honest I didn't read the last sentence in your reply to OPC and thought your were saying the exact opposite. Didn't mean to offend you.

    You obviously didn't...

    July 18, 2012 at 2:36 pm

    #1514550

  • RE: Cannot defrag indexes

    pooyan_pdm (7/18/2012)

    I said what i had to

    Really? After I had already said to OPC that I was mistaken? Nope, that looked like gloating to me.

    July 18, 2012 at 2:21 pm

    #1514544

  • RE: Cannot defrag indexes

    pooyan_pdm (7/18/2012)

    You're not the only one here with some years of experience here!! I've been doing this for 7 years . can just instead of repeating your claim give a...

    July 18, 2012 at 2:20 pm

    #1514542

  • RE: Cannot defrag indexes

    pooyan_pdm (7/18/2012)

    You're not the only one here with some years of experience here!! I've been doing this for 7 years . can just instead of repeating your claim give a...

    July 18, 2012 at 2:12 pm

    #1514538

  • RE: Cannot defrag indexes

    opc.three (7/18/2012)

    Lynn Pettis (7/18/2012)

    pooyan_pdm (7/18/2012)

    You can also try it to see what happens

    I have, I am talking from experience. If you have a clustered index that is highly fragmented,...

    July 18, 2012 at 1:40 pm

    #1514522

  • RE: query help

    This is what I wrote:

    SELECT

    CASE sex WHEN 'M' THEN 'Male' WHEN 'F' THEN 'Female' END AS Sex,

    RaceCode,

    COUNT(RaceCode) AS...

    July 18, 2012 at 1:33 pm

    #1514509

  • RE: query help

    By the way, I have a query that will provide you the data, just not in the format you presented in your original post.

    July 18, 2012 at 1:32 pm

    #1514508

  • RE: query help

    Looks lke homework. Can you show us what you have done so far to solve your problem?

    July 18, 2012 at 1:25 pm

    #1514501

  • RE: Highest Value

    For example, using the setup provided by ColdCoffee, this is what I came up with for a solution. I have included all the code ColdCoffee provided.

    IF OBJECT_ID('tempdb..#t') IS NOT...

    July 18, 2012 at 1:16 pm

    #1514494

  • RE: Highest Value

    thegoose78 (7/18/2012)

    Hi,

    I believe I have the solution. Still verifying, but it appears to work.

    Thanks.

    SELECT DISTINCT

    ID, NAME, FOP

    , ACCT, CTNUM, ENDDATE

    , DEBIT, CREDIT, TRANSACTION_DATE

    ,...

    July 18, 2012 at 1:10 pm

    #1514486

  • RE: how to delete duplicate col.

    SQLRNNR (7/18/2012)

    Lynn Pettis (7/18/2012)

    SQLRNNR (7/18/2012)

    lokeshvij (7/18/2012)

    Jason: I always wonder when I use CTE to delete duplicate rows.

    CTE being ANSI compliant, why does it let us delete data from CTE? I...

    July 18, 2012 at 12:25 pm

    #1514443

  • RE: how to delete duplicate col.

    SQLRNNR (7/18/2012)

    lokeshvij (7/18/2012)

    Jason: I always wonder when I use CTE to delete duplicate rows.

    CTE being ANSI compliant, why does it let us delete data from CTE? I am sure ANSI...

    July 18, 2012 at 12:17 pm

    #1514435

Viewing 15 posts - 10,651 through 10,665 (of 26,489 total)