Viewing 15 posts - 1 through 15 (of 16 total)
I agree 100%. Any developer who fails to understand the importance of the cost of code development and maintenance and standardization related to it is really making a career limiting...
February 11, 2015 at 11:17 am
Nothing is perfect, but that doesn't mean we shouldn't try to do our best. It doesn't make sense to me that a developer would say, "I don't want to follow...
February 6, 2015 at 10:33 am
There is nothing wrong with having *'s in your code. That is the most perfect SQL standard code as intended by the scientists who developed SQL. For example COUNT(*) and...
February 5, 2015 at 6:51 pm
count(*) requires 9 key strokes
count(1) requires 10 key strokes
...and we don't want to wear out the shift key, also consider that the *() line up next to each other vs...
February 4, 2015 at 5:33 pm
I think the count in sysindex is not guaranteed to be correct. So you can't depend on it 100%, but it is okay for an estimated number. COUNT(*) is more...
February 4, 2015 at 1:54 pm
I think the count(1) myth started some 20 years ago when at some point there was an old version of Oracle that actually performed better with COUNT(1), but all modern...
February 4, 2015 at 7:43 am
I was somewhat surprised too that people would take this so personal - it is only SQL code after all. To the new question you posted. The number of columns...
January 31, 2015 at 7:10 pm
If someone asks you how to do something, it is usually best to just provide the correct answer. Most people get confused if you first explain the wrong way and...
January 30, 2015 at 4:36 pm
I think someone wanted to know: what is the best way to determine the number of rows in a query?
Like I said, there are many ways to answer it, but...
January 30, 2015 at 3:09 pm
From MS SQL Server help. Also see p 124 of ANSI92 SQL standard.
Okay, now I want to see a reference where they state that COUNT(1) is better or preferred...
Syntax
COUNT (...
January 30, 2015 at 2:41 pm
Yes I can, actually all books and standard reference SQL documents states that COUNT(*) is the correct way. Check it out yourself, look for example in MS Help file, ANSI...
January 30, 2015 at 1:51 pm
Can someone post a reference from any SQL Standards book or academic research or similar work that states that SELECT COUNT(1) is the standard or intended method or syntax to...
January 30, 2015 at 12:23 pm
I don't get it. There are thousands of ways to get the correct answer, but why make it complicated? There is only one correct standard SQL method. SELECT COUNT(*) provides...
January 30, 2015 at 10:48 am
I get an error with SELECT COUNT(NULL), but that's probably the worst suggestion I have seen so far. I am not sure why some of you wants to do something...
October 17, 2013 at 4:58 pm
I think we have beaten this horse to death, but here are a couple more considerations to enjoy 🙂
As much as possible I try to make the code self documenting....
October 17, 2013 at 3:32 pm
Viewing 15 posts - 1 through 15 (of 16 total)