Viewing 15 posts - 136 through 150 (of 820 total)
So let's take an example of a SELECT that does not make any use of indexes.
RBAR fetches more rows from the table. False. It has to get the...
December 9, 2013 at 4:48 pm
"Avoid RBAR at all costs!" Right. Yes it helps, and helps a great deal. Another thing that you will hear is "All software is compromise!". So...
December 9, 2013 at 8:40 am
Jeff Gray (10/17/2013)
Interestingly, SQL server doesn't seem to care what's in the () unless it's a column name. It's obviously not evaluating static numeric expressions, or COUNT(1/0) would...
October 17, 2013 at 3:18 pm
marlon.seton (10/16/2013)
Charles Kincaid (10/15/2013)
October 16, 2013 at 8:56 am
gavansmith (10/15/2013)
can through -> can throw ?
'
Yep. That was pointed out this morning. I'll fix it.
October 15, 2013 at 2:57 pm
roman.asadovsky (10/14/2013)
That is well-known behavior of the COUNT(), but the question I have is this: What makes you think that COUNT(1) in any way superior to CONT(*)?
Right you are. ...
October 15, 2013 at 10:00 am
paul s-306273 (10/15/2013)
Who'd have thought count(*) would generate so much debate...
I take the Microsoft approach to writing. I get it good enough for release and let the community have...
October 15, 2013 at 9:38 am
Brandie Tarvin (10/15/2013)
October 15, 2013 at 9:36 am
I issue the drop ignoring the error if it is not there. Then I add the new one. You can put some effort into error handling for the...
September 27, 2013 at 8:55 am
Yes generalized procedures are harder to write as you have to take everything into consideration. Look at each one of your procedures you will start to see common patterns....
September 16, 2013 at 9:54 am
When it comes to writing data scripts the pain is about the same for CE as standard and Express. Count on there being nothing in CE to help you....
September 16, 2013 at 9:19 am
Nice article David.
Pardon my getting off topic a wee bit but since I see the article hits CLR procedures, test driven development, and SOUNDEX it's just one more...
September 12, 2013 at 2:05 pm
In fact sp_readerrorlog actually calls xp_readerrorlog.
Hey Rudy. Great article. Thanks for firing this off.
I put everything into a single script file, replaced the cursor with the update and...
September 6, 2013 at 11:38 am
Great article.
We have had the same challenge. We overcame it in a similar way but more normalized. We have a table that contains all the options that can...
September 3, 2013 at 9:27 am
Dalkeith (8/29/2013)
Oh boy - flat earthers still exist.
Just like there are still folks who can't get around anything but a flat data model.
August 29, 2013 at 9:42 am
Viewing 15 posts - 136 through 150 (of 820 total)