I agree with Tom. You don't want development and production databases on the same server. A reason he did not mention is that you are trying out things...

Lynn,

I have to say that I would be a nervous wreck if my 18 year old daughter went to Europe alone. Well, if I had an 18 year old...

Indexing is definitely a reason for NOT using IsNull. Any time you use a function on a column in a WHERE or JOIN clause SQL Server has to apply...

GSquared (6/1/2009)

---

Jack Corbett (6/1/2009)

---

Lynn Pettis (6/1/2009)

---

Okay, now tell us what you are trying accomplish. I can't see a correlation between your data and the query from your original post....

Lynn Pettis (6/1/2009)

---

Okay, now tell us what you are trying accomplish. I can't see a correlation between your data and the query from your original post. Possible that...

Luke L (6/1/2009)

---

If I have to query data based on the above, I've found that the OR syntax gets me better index utilization than IsNULL. Beyond that, a computed...

But the question in your original...

I don't see any wild cards in your criteria. Plus wild cards don't work with "=".

Flo,

In this particular application I could do anything I wanted, well, after discussion with the rest of the dev team, but I only provided the structure because I know I...

Grant Fritchey (6/1/2009)

---

Buy my book! Kidding. There are several topics on this in the BOL. If...

This post is mine, but I figure I'll link it here to get y'all's opinions.

You probably need to use the MOVE clause to put the database on the external drive.

Lynn, Can you post a link to the article?

Duplicate post. You can answer the poll if you want, but place solutions to the question posed by the poll here

If you just setup your linked server without a default database in the connection the "view" in Enterprise Manager/SSMS will show objects in the login's default database. You can...