Forum Replies Created

Viewing 15 posts - 121 through 135 (of 1,033 total)

  • RE: Collation conflict between SQL 2012 SP1 and SQL 2005 SP3 ?

    I'm aware of the differences between what is shown. However looking at the actual collations at the server, database, table and column levels they were always SQL_Latin1_General_CP1_CI_AS

    In this case...

  • RE: Merge

    Good question, learned something I didn't know about Merge and I use it not every day, but at least every other week. 🙂

  • RE: Basic Date Function

    crmitchell (2/13/2013)


    Because the question requires the user to make assuptions about how the end user's systems are configured which are defined in the question.

    In this case we don't know and...

  • RE: Basic Date Function

    Hugo Kornelis (2/13/2013)


    I had almost missed the different time in the returned output, as I was focusing completely on the data type. Caught is just in time!

    I do not agree...

  • RE: Basic Date Function

    davoscollective (2/12/2013)


    Your computer shows the following system date and time:

    If my computer showed that time I would be concerned that it's in US format and not Australian (UK) format!...

  • RE: The Lonely and Neglected Cartesian Product (Cross Join)

    Greate question.... I like this one. Thanks!

  • RE: Interview Questions

    The weird thing is... estimated execution plans puts mine ahead. 🙂

    and so did the actual... didn't expect that... I thought PIVOT was not that efficient

  • RE: Interview Questions

    Thanks Jeff...

    I didn't look at it too hard... but then you made me try to make it work for N < 12 and still use my pivot function (which I...

  • RE: Creating Tables

    Thanks for the trips down memory lane...

    This question reminds me of things I did before I learned how temp tables worked. I was so confused way back when...

  • RE: Interview Questions

    Here's how I'd do it.

    ;WITH start AS (

    SELECT

    rowsort = CASE N % 3 WHEN 0 THEN 3 ELSE N % 3 end,

    N,

    rc = ROW_NUMBER() OVER (PARTITION BY CASE N...

  • RE: Wrong Index Being Used

    Roger Sabin (2/8/2013)


    So, you are saying that SQL Server determined --

    the cost of finding a few records (using second index) + lookup for other fields

    was greater than ---

    the cost...

  • RE: Wrong Index Being Used

    Brandie Tarvin (2/8/2013)


    Lynn, for my own edification... This is because Name isn't included in either index, right? So the Clustered Index is easier to use to find name as associated...

  • RE: Thesaurus Files

    I remembered this from past forays into Thesaurus files and trying to load them before.

    thanks for the brush up!

  • RE: Wrong Index Being Used

    Lynn's spot on with this.

    Because the Name field is missing from the non-clustered index it would require a seek on the non-clustered followd by a bookmark lookup to the clustered...

  • RE: Updating Views

    Good question, I learned something.

    Generally I don't ever write views with SELECT * in them.

    but even if I did... If I had to refresh the view, I'd typically just alter...

Viewing 15 posts - 121 through 135 (of 1,033 total)