Both approaches have advantages, both have drawbacks. Which is best depends on a lot of factorsd in the system you are building, and it may be that given your...

The only time I would use isNull is where I have a very simple case, I would never try to do anything at all complicated with isNull (like nesting it)....

Ouch! I didn't know this had changed in SQLS 2005.

I wonder how much code (if any) the change has broken?

Jeff Moden (12/5/2009)

---

I like the all-in-one aspects of SSMS... what I don't like is all the functionality that is no longer available. Things like easily being able to do...

In SQL Server 2008, SSMSE does not support scheduling administrative tasks by using SQL Server Agent (http://msdn.microsoft.com/en-us/library/ms365247.aspx). So in effect there is no support for jobs - they can't...

It would have been a good idea to reference http://msdn.microsoft.com/en-us/library/ms187330.aspx as well as the coalesce page, because people thinking that if no value is returned the value is set to...

I'll start off by declaring total agreement with Geoff.

But some other posts were very intelligent so are worth discussing.

I very much liked the first comment (from Keith) because it makes...

Brandie Tarvin (1/26/2010)

---

I did read the whole comment. It's just that the first paragraph of any email or post sets the tone for the rest of it. Which means your...

Brandie Tarvin (1/26/2010)

---

Tom,...

Steve Jones - Editor (11/20/2009)

---

The answer, based on LIKE, is that you are looking for 3 character matches without the %.

So you have possible:

John

Jonathan

Jon

Joe

Jack

Of these, the 3 character ones...

Gift Peddie (11/20/2009)

---

You want to explain why there are no roles in Windows and there is roles in SQL Server from the time I have been using it which is...

Ben Leighton (11/20/2009)

---

majorbloodnock (11/20/2009)

---

I agree, and I must admit...

This response is directly to the editorial - I haven't read any of the other comments yet.

I don't know why anyone is looking at DB security as something...

Elliott W (1/23/2010)

---

I can think of a couple reasons, the first one is an organization with dozens of SQL servers, the CAL is applicable to ANY SQL server of the...

Perhaps instead we could ensure that all questins specify which resions (7, 2K0, 2K5,...