Forum Replies Created

Viewing 15 posts - 46,486 through 46,500 (of 59,062 total)

  • RE: Query to fill in missing dates in a series of rows

    bnordberg (12/18/2008)

    The data in this format will allow for contract tracing of MRSA infections. Our statisticians can pipe this through some algorithims in SAS to see if we can't find...

    December 18, 2008 at 9:06 am

    #914652

  • RE: Query to fill in missing dates in a series of rows

    bnordberg (12/17/2008)

    Thanks Chris!

    that appears functional. Now to tune and see how it works with a few hundred million rows!

    Are you sure it works? When I run it, I only...

    December 18, 2008 at 9:04 am

    #914646

  • RE: How do you archive data?

    Gabe (12/18/2008)

    3) The clustered index must also be the partition key.

    I would say that's only true for things that are temporal in nature. If the partitions are based on...

    December 18, 2008 at 8:44 am

    #914624

  • RE: Are the posted questions getting worse?

    r.hensbergen (12/18/2008)

    You know both internet and SQL Server are international? On forums like these people visit from all over world.

    Nah... really? I thought the internet was just the U.S....

    December 18, 2008 at 8:18 am

    #914584

  • RE: Are the posted questions getting worse?

    ALZDBA (12/18/2008)

    Jeff Moden (12/18/2008)

    ... we now have two national languages just due to immigration.

    Due to WWII we have 3 official languages 😉

    Heh... due to WWII, we only had one, until...

    December 18, 2008 at 8:10 am

    #914574

  • RE: Updating Values Without Cursor

    Now there's a milestone... thanks for the feedback on this, Parul...

    December 18, 2008 at 7:47 am

    #914550

  • RE: Are the posted questions getting worse?

    Ninja's_RGR'us (12/18/2008)

    There's a question, it's just not obvious.

    The guy abviously has troubles with the english written language. Nothing to be made fun of guys!!!!!!1

    Actually, there is... it's people like...

    December 18, 2008 at 7:16 am

    #914514

  • RE: The Full Potential of SQL 2000

    sausage.dog (12/17/2008)

    People scoff at the idea of buying bigger hardware but as you point out it's cheap. Oftentimes it's far cheaper than paying a team to optimise (read: rewrite) large...

    December 17, 2008 at 11:54 pm

    #914313

  • RE: Guest Editorial: On writing SQL

    gcopeland (12/17/2008)

    Jeff Moden (12/17/2008)

    Ooooohhhh, I so disagree with that... the customer almost never includes performance and scalability requirements in any quantifiable manner... but they do get awfully ticked when it...

    December 17, 2008 at 11:48 pm

    #914309

  • RE: Add a character, or expand to non-printable?

    RBarryYoung (12/17/2008)

    Jeff Moden (12/17/2008)

    Also, have you given any thought to using a hybrid of the Nested Set Model instead of the Adjacency Model you're currently using?

    Actually, Jeff, I believe that...

    December 17, 2008 at 11:42 pm

    #914307

  • RE: Cross Tabs and Pivots, Part 2 - Dynamic Cross Tabs

    psmg01 (12/17/2008)

    Hi Jeff,

    Thank you for your reply.

    I will post this in T_SQL forum too.

    I am having a table like below

    [CREATE TABLE [dbo].[Output_Info](

    [Common_Id] [int] NOT NULL,

    [Signal] [real] NOT NULL,

    [Detect] [nchar](10)...

    December 17, 2008 at 11:38 pm

    #914304

  • RE: Discovering Gaps in Identity Column

    Way cool... finally, a good use for such a thing. Might I suggest you "baseline" the table by saving the output of the query I gave you in a...

    December 17, 2008 at 11:30 pm

    #914302

  • RE: Order by numbers in proper sequence

    Sergiy (12/17/2008)

    dejanette.gordon (12/17/2008)

    How do you sort alphanumeric data in sequential order? I need the data to go from:

    100

    101

    102

    etc...

    The answer is:

    ORDER BY AlphanumericValue

    Now, THAT's entertainment! 😀

    December 17, 2008 at 11:27 pm

    #914300

  • RE: Order by numbers in proper sequence

    dejanette.gordon (12/17/2008)

    Thanks for the replies!! I do apologize for not posting my question in the proper format. It's my first time posting, although I'm not looking for a pass based...

    December 17, 2008 at 11:27 pm

    #914299

  • RE: How do you archive data?

    Gabe (12/15/2008)

    Hey everyone thanks for your help. I got the green light to use partitioning on the production database. Basically we have a database where we keep 31 days of...

    December 17, 2008 at 10:12 pm

    #914290

Viewing 15 posts - 46,486 through 46,500 (of 59,062 total)