Forum Replies Created

Viewing 15 posts - 2,206 through 2,220 (of 7,483 total)

  • RE: Are the posted questions getting worse?

    GilaMonster (9/12/2014)

    Um... http://www.sqlservercentral.com/Forums/Topic1612868-3411-1.aspx ????

    Not fair Gail, surely on topic comments are not allowed in the thread. 🙂

    A finer display of ignorance and misunderstanding is hard to imagine. I can...

    Tom

    September 12, 2014 at 5:05 am

    #1745028

  • RE: Using COALESCE and also trying to multiply and divide

    Luis Cazares (9/11/2014)

    Thank you, Tom.

    I guess I shouldn't have taken the quote from Wikipedia. My mistake.

    PS. It's great that you can create cables on SQL :-D:hehe:

    Ouch! I must get...

    Tom

    September 11, 2014 at 2:52 pm

    #1744936

  • RE: Using COALESCE and also trying to multiply and divide

    Luis Cazares (9/11/2014)

    You should remember the third normal form: "all the attributes in a table are dependent on the primary key and only the primary key."

    While I agree with most...

    Tom

    September 11, 2014 at 2:41 pm

    #1744931

  • RE: Are the posted questions getting worse?

    Ed Wagner (9/11/2014)

    Heh - We just got our driveway paved with asphalt on Tuesday (the day before the rain) and our dog doesn't know what to do any more. ...

    Tom

    September 11, 2014 at 2:18 pm

    #1744927

  • RE: Check the Variable is Empty or Null

    Eirikur Eiriksson (9/11/2014)

    Lets add some spanners into the mix

    Although the first two chunks indicate clearly that NULL is ordered low by ORDER BY, they don't indicate anything else.

    The "spanners" added...

    Tom

    September 11, 2014 at 2:04 pm

    #1744921

  • RE: View Definition?

    I think you will need to give your user select access on sys.all_objects and deny select access on sys.syscolumns and sys.sql_modules for the user to get SP names but not...

    Tom

    September 11, 2014 at 10:03 am

    #1744847

  • RE: Check the Variable is Empty or Null

    Eirikur Eiriksson (9/9/2014)

    Alan.B (9/9/2014)

    IF @user > '' --This checks for not null and not empty

    Cool. I never knew you could do that, very interesting :laugh:

    Edit: sql code tag messed up...

    Tom

    September 11, 2014 at 9:32 am

    #1744830

  • RE: Check the Variable is Empty or Null

    Luis Cazares (9/10/2014)

    Eugene Elutin (9/10/2014)

    Alan.B (9/9/2014)

    IF @user > '' --This checks for not null and not empty

    Cool. I never knew you could do that, very interesting :laugh:

    Edit: sql code tag...

    Tom

    September 11, 2014 at 9:28 am

    #1744829

  • RE: Check the Variable is Empty or Null

    Eugene Elutin (9/10/2014)

    You may do it... sometimes...

    But it is NOT right. Try this:

    .......

    I find that if I stick <shift in>, <shift out>, and <data link escape> into a string...

    Tom

    September 11, 2014 at 9:22 am

    #1744825

  • RE: Issue with Unicode Conversion

    Koen Verbeeck (9/11/2014)

    What data type did you pick in the source component in the data flow?

    DT_TEXT?

    If the source is unicode, it should be DT_NTEXT.

    More to the point, if the data...

    Tom

    September 11, 2014 at 9:03 am

    #1744821

  • RE: Today's Random Word!

    djj (9/11/2014)

    BWFC (9/11/2014)

    SQLRNNR (9/10/2014)

    Sean Lange (9/10/2014)

    SQLRNNR (9/10/2014)

    Sean Lange (9/10/2014)

    Ed Wagner (9/10/2014)

    whereisSQL? (9/10/2014)

    Sean Lange (9/10/2014)

    Ed Wagner (9/10/2014)

    djj (9/10/2014)

    Telephone

    Telegraph

    Pony Express

    History

    Lessons Learned

    and promptly forgotten so we can repeat ourselves.

    Is that old age or...

    Tom

    September 11, 2014 at 5:13 am

    #1744703

  • RE: Truncate table query

    Iulian -207023 (9/11/2014)

    What happens if while the pages are deallocated , another task / process / txn ( or something ) allocates that space for other purposes...

    Tom

    September 11, 2014 at 5:11 am

    #1744700

  • RE: Truncate table query

    Koen Verbeeck (9/11/2014)

    Vimal Lohani (9/11/2014)

    TRUNCATE TABLE removes the data by deallocating the data pages used to store the table data and records only the page deallocations in the transaction log.

    this...

    Tom

    September 11, 2014 at 4:15 am

    #1744683

  • RE: Truncate table query

    Iulian -207023 (9/11/2014)

    Although I answered more based on the instinct that the data is safely recovered after a rollback. I am still wandering why have I thought that TRUNCATE would...

    Tom

    September 11, 2014 at 2:36 am

    #1744658

  • RE: Truncate table query

    Koen Verbeeck (9/11/2014)

    Please don't say truncate table data isn't logged unless you understand the concepts involved.

    😉

    The Myth that DROP and TRUNCATE TABLE are Non-Logged

    +1000000

    It's amazing, when even the reference quoted...

    Tom

    September 11, 2014 at 2:36 am

    #1744657

Viewing 15 posts - 2,206 through 2,220 (of 7,483 total)