Viewing 15 posts - 121 through 135 (of 1,033 total)
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...
February 15, 2013 at 7:25 am
crmitchell (2/13/2013)
In this case we don't know and...
February 13, 2013 at 7:25 am
Hugo Kornelis (2/13/2013)
I do not agree...
February 13, 2013 at 7:23 am
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!...
February 13, 2013 at 6:56 am
Greate question.... I like this one. Thanks!
February 12, 2013 at 11:56 am
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
February 11, 2013 at 7:44 am
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...
February 11, 2013 at 7:41 am
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...
February 11, 2013 at 7:04 am
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...
February 8, 2013 at 2:50 pm
Roger Sabin (2/8/2013)
the cost of finding a few records (using second index) + lookup for other fields
was greater than ---
the cost...
February 8, 2013 at 12:48 pm
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...
February 8, 2013 at 12:22 pm
I remembered this from past forays into Thesaurus files and trying to load them before.
thanks for the brush up!
February 8, 2013 at 7:26 am
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...
February 8, 2013 at 7:16 am
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...
February 7, 2013 at 7:02 am
Viewing 15 posts - 121 through 135 (of 1,033 total)