Forum Replies Created

Viewing 15 posts - 51,436 through 51,450 (of 59,072 total)

  • RE: Bulk-Logged Recovery Model

    Ignacio A. Salom Rangel (3/28/2008)

    I have used LiteSpeed, but i'm sure there are other third party applications that gives the same result as LiteSpeed. It will reduce the size of...

    March 28, 2008 at 11:09 pm

    #795570

  • RE: Choosing between a View and Table-valued function

    Robert (3/28/2008)

    Just noticed my posts were too bare bones.

    So, views are preferable for several reasons:

    - they're highly portable

    - they're simpler

    - server can better optimize query based on view as view...

    March 28, 2008 at 10:51 pm

    #795569

  • RE: Could I eliminate this cursor?

    rbarryyoung (3/28/2008)

    Jeff Moden (3/28/2008)

    ... If it's the first split, he uses 36 characters. If the Party_Name is more than 36 characters, the first row uses 36 characters and all...

    March 28, 2008 at 10:13 pm

    #795565

  • RE: Could I eliminate this cursor?

    Cory Ellingson (3/28/2008)

    WOOHOO!! I got a "Mighty Close" by Mr Jeff M himself! Thanks!

    Gosh, I'm really sorry Cory... I didn't mean to offend...

    March 28, 2008 at 9:33 pm

    #795561

  • RE: Could I eliminate this cursor?

    Cory Ellingson (3/28/2008)

    I could VERY well be wrong on this, as I am just starting to work with CTE's, but something like this may work...

    WITH TEST_CTE_Insert (...

    March 28, 2008 at 8:48 pm

    #795556

  • RE: How to convert char to real to numeric

    Robert (3/28/2008)

    Numeric is decimal, so it must be used whenever accuracy matters.

    I was with you all the way up until you said that...

    If you do cascaded conversions like this, what...

    March 28, 2008 at 7:20 pm

    #795543

  • RE: Four Rules for NULLs

    kaspencer (3/28/2008)

    Sorry, but because I couldn't read your post while writing my reply, I forgot to add my third point:

    By the way, if you scroll down when constructing a reply,...

    March 28, 2008 at 6:13 pm

    #795540

  • RE: Four Rules for NULLs

    Ok... it's all semantics... I call zero "nothing" and an empty string "nothing" and I say "Null is NOT nothing". You say Null is nothing. I disagree, but...

    March 28, 2008 at 6:09 pm

    #795537

  • RE: What would you do?Update situation....

    You bet... and thanks for the great feedback!

    March 28, 2008 at 6:01 pm

    #795536

  • RE: How to convert char to real to numeric

    Kevin Durham (3/28/2008)

    Thanks rbarryyoung,

    You confirmed what I feared was true from what I had read elsewhere. If REAL only holds 7 digits, and the other 15 are lost, I have...

    March 28, 2008 at 5:45 pm

    #795531

  • RE: Bulk-Logged Recovery Model

    David Naples (3/27/2008)

    Have fun with THIS.

    Pleasant surprise... there's even some documentation in the code... thanks David.

    March 28, 2008 at 5:26 pm

    #795526

  • RE: Bulk-Logged Recovery Model

    Ignacio A. Salom Rangel (3/27/2008)

    I think that you should Really consider using third party tools.

    Don't leave us hanging... spit it out.. WHICH 3rd party tools would you recommend?

    March 28, 2008 at 5:20 pm

    #795523

  • RE: Four Rules for NULLs

    Mike C (3/28/2008)

    I get a clustered index scan when I run your code. The optimizer expands it out to RowNum <> 1 AND RowNum <> 2 AND RowNum <> 3.

    Hmmm......

    March 28, 2008 at 5:06 pm

    #795517

  • RE: are there "arrays" in sql 2005 ?

    blahknow (3/26/2008)

    I've been told i must send a string and create a function to change the string into a table and i guess thats what i'll do unless i hear...

    March 28, 2008 at 5:00 pm

    #795514

  • RE: are there "arrays" in sql 2005 ?

    dfalso (3/28/2008)

    Jeff Moden (3/28/2008)

    Any code to go along with this "FWIW"? 😉

    What, you want answers too? 🙂

    Heh... no... just wanted to know if I was gonna have to write some......

    March 28, 2008 at 4:54 pm

    #795513

Viewing 15 posts - 51,436 through 51,450 (of 59,072 total)