Viewing 15 posts - 1 through 15 (of 29 total)
Excellent article well explained!
I have a couple of performance-related comments and suggestions which may be of interest if consistent latency is paramount in your user-base.
Never underestimate the effects of parameter-sniffing...
April 23, 2015 at 5:38 am
I agree with Michael. This does not return the results as described. Furthermore, when TEXT contains NULL values, TEXT1 will be NULL. TEXT2 and TEXT3 will hold empty strings when...
July 29, 2013 at 2:21 am
I supposed (incorrectly) that the ALTER VIEW would fail due to the addition of the non-determinitic column, CurrentDate, to the indexed view.
Learned lots this morning! Nice question!
July 25, 2013 at 1:38 am
L' Eomot Inversé (6/6/2013)
michlimes (6/6/2013)
default collation is choosen at installation process - so imo it could be CS_AS.
You can override the installation defaults when doing the installation. Then you...
July 2, 2013 at 1:56 am
manik123 (2/19/2013)
nice question.... query will execute successfully..but Objective: Update all the M's to F and all F's to M. will not work...
How so?
February 19, 2013 at 7:53 am
Carlo Romagnano (2/19/2013)
The update may fails with error, if the default collation is case sensitive.
UPDATE GenderUpdate
SET Gender = CASE WHEN GENDER = 'M' then 'F' ELSE 'M' END
Carlo's onto...
February 19, 2013 at 3:46 am
GilaMonster (10/31/2012)
Andrew Diniz (10/31/2012)
After all, it is possible to observe 'Halloween Protection' in DELETE and INSERT plans too :hehe:
No, the Halloween problem is exclusively for updates. You can't insert or...
October 31, 2012 at 5:16 am
Nice one! I came across this last year whilst studying for an exam.
Shouldn't the options, CREATE, DELETE, INSERT, UPDATE and SELECT be checkboxes though as opposed to radio buttons?...
October 31, 2012 at 3:14 am
GilaMonster (10/16/2012)
It's not traversing the index 9.5 million times....
October 16, 2012 at 5:58 am
While troubleshooting a poor performing query this morning I came across something which surprised me - actually, two things:
1) one of the tables being queried defined no primary key or...
October 16, 2012 at 3:26 am
Did you check the FIX article I referenced above (http://support.microsoft.com/default.aspx?scid=kb;en-us;2717598)? At the top of page there's a large green hotspot titled 'Hotfix Download Available'.
I can't say if...
August 15, 2012 at 2:49 am
Indeed.
You can eliminate 7 evaluations from the vast majority of leap year candidates by simplifying and reordering the predicates:
SELECT
CASE
...
August 14, 2012 at 5:40 am
A calender is a series of hard pressure rollers used to form or smooth a sheet of material (see http://en.wikipedia.org/wiki/Calender).
Not sure how this relates to dates. :hehe:
August 10, 2012 at 4:03 am
Peter H (7/10/2012)
July 11, 2012 at 2:29 am
It occurs to me that our organization and developers need a better method to monitor modifications on specific objects, either DDL or DML, when then might affect "custom" or "one...
July 10, 2012 at 5:04 am
Viewing 15 posts - 1 through 15 (of 29 total)