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...

"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...

Jeff Gray (10/17/2013)

---

Hmmm....Try this

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...

marlon.seton (10/16/2013)

---

Charles Kincaid (10/15/2013)

---

Almost to the same level of performance boost that can be obtained by moving some predicated to the JOIN instead of leaving them in the WHERE (but...

'

Yep. That was pointed out this morning. I'll fix it.

Right you are. ...

I take the Microsoft approach to writing. I get it good enough for release and let the community have...

Brandie Tarvin (10/15/2013)

---

Interesting results on the execution plan. All plans but the COUNT() on Name came backup with only an expected 9B in the row size. The Name count came...

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...

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....

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....

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...

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...

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...

Just like there are still folks who can't get around anything but a flat data model.