I agree. Consolidating the forums is a great idea. There really are too many to manage or browse through. I still think you should seperate them by version though. Even...

Jeff Moden (12/27/2008)

---

Heh... let's put it in terms of common sense... whether it's legal or not, would YOU want you SSN in clear text along with other personal and financial...

It looks very good. Nice job.

Ah... perfect. Thanks.

jpatevans4651 (12/24/2008)

---

Hi,

Is there no limit to stored procedure parameters because when I use ado.net I get the following when trying to call a stored procedure with 12 parameters:

Procedure or function...

Michael Valentine Jones (12/23/2008)

---

If there is someone doing a DBA interview that doesn’t have the technical understanding to be able to weed out a bogus DBA, then they probably shouldn’t...

J (12/23/2008)

---

This is interesting. Though I am a bit surprised a law would cover such a specific technical detail (primary key).

The OP has not confirmed if this is indeed the...

Don't mess with the magic... Pay no attention to that man behind the curtain...

It's just an illustration I've used for years to show beginners how joins work. If you really...

For the full list of sqlcmd settings and commands, please consult the Books Online.

I'd also suggest getting your DBA into the discussion here. They might have a good reason for using NOLOCK, or, more likely, they need a better understanding of what it...

Draw two intersecting circles. Circle 1 is your first table and Circle 2 is the second.

An inner join is the area within the intersection of the circles.

A left join is...

Glad I was a bit helfpul.

Yeah, I learn something new from Gail almost daily. On the rare occasions she doesn't teach me something new, she asks a question or makes...

magarity (12/22/2008)

---

Sorry, I don't...

I agree with the rewrites. The simpler and clearer you can make the query, not only will it be easier for you, and those that come after you, to maintain,...

All the basics work fine, no issues. Intellisense doesn't work. There are some other newer bits & pieces that won't work.

For what it's worth, it works well on SQL...