Even without Profiler, you can still create/use a trace to get what queries are being run in the database. You just have to script it out yourself. Check...

Craig Farrell (5/3/2011)

---

Side topic, has anyone here looked for employee or resume submittals via SSC? If so, what was your quality of recipients? We're running into a dearth...

Are you asking how to write a SELECT statement?

I'd have to see more of the code to help much. Can you post the whole loop?

I've used them. Those and XML columns both work for "user-defined data structures". Which one I use depends on degree of flexibility needed and how it's going to...

Awesome! Well done and well deserved.

Tom.Thomson (5/2/2011)

---

ChrisM@home (5/2/2011)

---

Koen Verbeeck (5/1/2011)

---

ChrisM@home (4/30/2011)

---

LutzM (4/30/2011)

---

Slightly different over here in Germany: if a holiday falls on a Sunday (as it happens with May 1st this year), we won't get...

Craig Farrell (5/2/2011)

---

Brandie Tarvin (4/29/2011)

---

I...

I'm not clear on your question.

Are you asking if the service account should be a sysadmin? If so, no, it shouldn't. That allows rights escalation attacks by anyone...

The error message recommends turning it into a derived table format. Try this:

SELECT ISNULL((SELECT *

...

I tell people that my job description is specifically designed to see how fast a person's eyes can glaze over. The entertainment starts there.

David Portas (4/27/2011)

---

GSquared (4/27/2011)

---

On the circular reason point, saying "all relations are in 1NF, thus this is automatically in 1NF because we say it's a relation", is circular reasoning. ...

Peter Trast (4/27/2011)

---

Steve Jones - SSC Editor (4/27/2011)

---

I may be wrong, and I'll admit that. However the "use" of the data in terms of when/how you might call someone is...

Peter Trast (4/27/2011)

---

GSquared (4/27/2011)

---

Richard Warr (4/27/2011)

---

Nice question and an interesting example. Would renaming the columns "Telephone 1" and "Telephone 2" to "Home Phone" and "Mobile Phone" mean that the table...

Steven993 (4/27/2011)

---

You don't know what is a relation.

You can't see the difference between relation and table......

I actually have Date on Database Writings 2000-2006 under my eyes.

Chapter 8, 30 apges is...