Lynn Pettis (3/2/2008)

---

....

I appreciate the compliment. Now you've set the bar for me even higher. I would be lucky to put myself at 5 out 10 on...

I did some tests on the use of IsNull in the Where clause and found the following:

If the column being tested allows nulls, it will use an index or table...

I have a smartphone (T-Mobile Dash) with Windows Mobile. It's not company issued, but I do use it for business as well as personal needs. The ability to...

Good article.

One thing I like to include in parameter names is the direction. For example, "@Date_in" would be an input parameter, "@Date_out" would be an output parameter, "@Date_both" would...

Feifarek (2/28/2008)

---

I agree it is a bad idea to grow corn to make alcohol. But it is possible for biofuel generation to be beneficial: the idea would not...

George Heinrich (2/28/2008)

---

Great article! I'm glad I read it, but now i'm having trouble writing one of my queries...

I need to join 2 tables on smalldatetime columns. One of the...

Good article.

One small quibble with it. In one of the examples, you use "((FullName1 = 'Ed Jones') OR (FullName1 IS NULL))", as an example of how to get Index...

It looks like the first one should work.

Personally, I'd have done it as a join instead of having the subquery on the company number, but it looks like it should...

Does it always have a comma between the elements of the name? (Your samples do, but I'm not sure if that's a coincidence.)

Also, does it have entries like "Bob...

Luiz (2/27/2008)

---

Thank you for all your answers.

I agree with what you guys told. But it seems that other people don't. See, for example, the discussion in http://www.sql-server-performance.com/tips/views_general_p1.aspx. Does anybody...

Can you post the code of the query that performs well and the query that doesn't? That would help.

Where I've seen views slow things down is where a view that pulls a large number of columns from a large number of tables is used to grab a small...

You might have to add:

if not exists (select * from SYCFStore where store_key = @store_key)

select 'Y'

That might do what you need.

I like the ideas in the article at the end, about adding the editorial to the front page, and so on.

I don't think a lot needs to change in the...

James A. Lawrence (2/26/2007)

---

Here's an example, visit

This (somewhat new) SQL site is pretty cool from the aspect of design... and the articles and 'How To' items are very...