Forum Replies Created

Viewing 15 posts - 49,426 through 49,440 (of 59,078 total)

  • RE: www.sqlservercentral.com

    The OP "left the building" 2 months ago...

  • RE: Raima Database Data Import

    What is a "Raima" database? Never heard that one before...

  • RE: To Certify or Not To Certify

    Heh... Ok... I'll summarize my position on Certifications and Degrees...

    Everyone my bosses hired had great Certifications and Degrees on their resumes and they were hired for that reason... most...

  • RE: Using 'Where' with 'LIKE' 'AND' 'OR' with NULL values mixed in.

    tybee (7/3/2008)


    I'm still a novice at SQL and I'm stuck trying to set up a search on a table that could have four 'AND' and two 'OR' searches, if...

  • RE: Spliting a string

    Depending on the need, the following is about twice as fast... but it'll take a million rows to notice so let's just say it's very readable... 😀

    DECLARE @InputString VARCHAR(8000)

    ...

  • RE: Handling hirarchy in tables

    Heh... must be catchy... "Now, how did THAT happen?"... heh... I'm not even wearing a helmet! 😉

    Thanks for the catch, Barry. 🙂

  • RE: Bulk Insert and Index Considerations

    BCP uses the log only if you've not met the requirements for "minimal logging". Otherwise, it will minimally log... just like BULK INSERT which is actually faster than BCP.

    Please...

  • RE: Handling hirarchy in tables

    Ok... now, I'm impressed! I've not reviewed all of the code in the good article recommended by Rashmi, yet... but the author (James Simpson) has done a strange and...

  • RE: Handling hirarchy in tables

    rashmi.todkar (7/4/2008)


    by the way this is also a very good link for nested sets

    http://www.codeproject.com/KB/database/nestedsets.aspx

    That is a good article... graphics for the explanations are spot on and done well.

    Heh......

  • RE: Handling hirarchy in tables

    rashmi.todkar (7/4/2008)


    Thanks all.

    I gone through nested sets options its really best one for high performance reads on such data. but update and insert is bit costly however I can afford...

  • RE: CLR Assemblies

    Greatings Mr. Burrows! Say... are you going to make the trek to Pass this fall? If you are, look for the guy wearing my avatar on the back...

  • RE: Output to csv

    Shodman (7/2/2008)


    Hi Folks

    I am trying to do a simple query and output to a csv file.

    SELECT *

    FROM mytable

    OUTPUT TO c:\mycsvfile.csv

    Could somebody please advise why this isn't working.

    I've read through loads...

  • RE: eliminating duplicates

    Just so you know... I've had it take as long a 6 weeks from the submital date to have an article published and as little as 1 week. It...

  • RE: Table of Numbers (Tally Table)

    Apparently, my Windows Live account signup hasn't made it this far, yet. Needless to say, I have some pretty strong feelings in the area of Tally tables... 😉

    ... I'll...

  • RE: Dynamic USE clause

    Sidebar: Yeah, I agree... this is one of the few and only places where I suppose it's ok to use a cursor... you just won't see me doing it!...

Viewing 15 posts - 49,426 through 49,440 (of 59,078 total)