Forum Replies Created

Viewing 15 posts - 1,801 through 1,815 (of 3,348 total)

  • RE: LEFT JOIN

    bev.kaufman (4/4/2013)

    I guess the lesson here is that JOIN clauses should be limited to the matching fields, and all other filters go in the WHERE clause. Does that sound...

    April 4, 2013 at 11:53 am

    #1603676

  • RE: LEFT JOIN

    Great idea for a question, Kapil!

    But ... (isn't there always a "but"?)

    When I saw the question in the newsletter, I expected the answer options to be phrased in terms of...

    April 4, 2013 at 1:35 am

    #1603450

  • RE: Assigning values to Variables with CASE

    I like the idea of the question - testing when an assignment to a variable with CASE would or would not overwrite previous assignments. I can see some people getting...

    April 3, 2013 at 4:31 am

    #1603083

  • RE: TRY...CATCH

    Good question, but the explanation falls a bit short. I was very disappointed when I first saw this behaviour. A semicolon is a statement terminator and should be used after...

    April 2, 2013 at 1:39 am

    #1602688

  • RE: LEN()

    Dineshbabu (4/1/2013)

    Thanks Hugo,

    I have one more doubt, will ANSI_PADDING set option affects the datastorage?

    No and yes.

    No, because the working of LEN and DATA_LENGTH are not affected by this option, they...

    April 2, 2013 at 12:57 am

    #1602680

  • RE: Throttle a Query in Mid-Execution

    Steve Jones - SSC Editor (4/1/2013)

    Glad you like it.

    I was curious how many might actually read the whole thing and not skip over my disclaimer sentence.

    Oops...

    Exposed. 🙁

    April 1, 2013 at 9:15 am

    #1602491

  • RE: Throttle a Query in Mid-Execution

    I was disappointed when the text of the editorial frankly admitted it being an April Fools prank. There goes the chance to read the comments of those who fell for...

    April 1, 2013 at 6:10 am

    #1602423

  • RE: LEN()

    Dineshbabu (4/1/2013)

    If somebody explains the difference b/w Datalength() & Len() in this thread will be useful.

    Datalength returns the amount of bytes that would be used on disk for storing the...

    April 1, 2013 at 2:34 am

    #1602396

  • RE: Database Mirroring

    L' Eomot Inversé (3/27/2013)

    Evgeny Garaev (3/26/2013)

    Correction, Principal do not wait for commit transaction on the mirror. It waits for transaction being recorded in transaction log file on the mirror server....

    March 27, 2013 at 8:12 am

    #1601167

  • RE: CASCADE - 2

    I think you're reading a bit too much into the code used to create some sample data, Tom. I suspect ROn used this method to eaily visualize which rows belong...

    March 26, 2013 at 7:57 am

    #1600801

  • RE: CASCADE - 1

    L' Eomot Inversé (3/21/2013)

    I guess if you are in a situation where you can't use foreign keys, which is what you appear to be saying, the question of using cascade...

    March 21, 2013 at 9:07 am

    #1599433

  • RE: CASCADE - 1

    L' Eomot Inversé (3/21/2013)

    Let's be clear here: under what circumstances is the order indeterminate?

    I never investigated this myseslf. I have heard this from many people. People I value and trust...

    March 21, 2013 at 9:03 am

    #1599429

  • RE: Delete v Truncate

    Raghavendra Mudugal (3/21/2013)

    Hugo Kornelis (3/21/2013)

    ...

    DML is language that inserted, updates, or deletes data. That (deleting data) is exactly what TRUNCATE TABLE does!

    Thank you Hugo; but one doubt...

    .... but still it...

    March 21, 2013 at 7:48 am

    #1599382

  • RE: Delete v Truncate

    (My original reply was much longer, but I lost it due to that stupid SQLServerCentral bug that tends to eat a reply when you worked on it for a long...

    March 21, 2013 at 6:52 am

    #1599353

  • RE: CASCADE - 1

    marlon.seton (3/21/2013)

    By 'why bother' I guess you're meaning why bother using triggers instead of cascade delete? Because the 4GL in which we write the application can't handle FK constraints (and...

    March 21, 2013 at 3:51 am

    #1599292

Viewing 15 posts - 1,801 through 1,815 (of 3,348 total)