Viewing 15 posts - 16 through 30 (of 75 total)
Taking a step back, why should the sort order depend on either SOUNDEX (especially when case sensitive) or gramnatical interpretation at all?
That sounds like total stupidity to me.
// Corrected "atupid"...
September 12, 2012 at 2:21 pm
Raghavendra Mudugal (9/12/2012)
vk-kirov (9/12/2012)I don't understand why peppers are in the end of the list. Shouldn't they be between pepper and Pepper? 🙂
Because here the "peppers" is plural. Of-course...
September 12, 2012 at 5:46 am
L' Eomot Inversé (9/2/2012)Well, the non-clustered index with included columns is an amusing concept, and I'm astounded that so many people (44% now) believe in such a fabulous beast.
L' Eomot Inversé (9/2/2012)
Well, the non-clustered index with included columns is an amusing concept, and I'm astounded that so many people (44% now) believe in such a fabulous beast.
September 3, 2012 at 3:51 am
Steve in Fairfax (8/22/2012)
August 22, 2012 at 6:55 am
To create an index on a view in SQL Server, the view definition must not contain any of the following:...Nondeterministic expressions
To create an index on a view in SQL Server, the view definition must not contain any of the following:
That will make it hard to implement my suggested optimisation...
August 21, 2012 at 5:15 am
... or using a (pre-CROSS JOIN) UNION of the two SELECTs of course...
August 20, 2012 at 12:06 am
Nice out-of-the-box thinking. Initially I didn't have a clue where it was going.
You can probably speed this up for tables with many rows by having an indexed modified date in...
August 19, 2012 at 11:49 pm
The issue is less about stored procedures and more about optimised code for that environment
Agreed that's it is really about the optimised, non-portable code (that is often, but not always,...
August 13, 2012 at 2:30 am
August 12, 2012 at 10:27 pm
It completely shut off when I saw "your stored procedures would need to be re-written in order to migrate to MySQL, Oracle or another database" since I think...
August 12, 2012 at 9:45 pm
As an alien (i.e. not in the US) I find all of this very revealing on several levels. Please continue the fascinating entertainment.
By the way, the metric system is not...
July 19, 2012 at 5:03 pm
"It is so frustrating: every table that I date turns out to be a relation."
July 18, 2012 at 5:09 am
You might want to consider that there are 5 different definitions of 'CST' (http://www.timeanddate.com/library/abbreviations/timezones/). But even if we did have codes that are well known and unique, I...
July 17, 2012 at 2:24 am
Very good article, thanks.
And apparently I wasn't the only one who must have missed it the first time around, so it is also a good illustration of the value...
June 8, 2012 at 9:40 pm
"every table within SQL Server should have a clustered index"
Fine, but should it then also always be the (preferably meaningless?) primary key? Or an index that is more likely to...
May 31, 2012 at 1:09 am