I think, I have not tried this recently, you can do a calculated field for age in the dataset like you are doing in the report, then you can reference...

First of all, I'm not sure you really mean Deadlock because deadlocks will resolve with an error that tells you that your process was deadlocked with another process and your...

I agree with Ken on all his points. Your mistakes are common ones when dealing with triggers in SQL Server. Ideally, IMO, all of this should be handled...

In addition to what Jason has shared I'd also investigate indexes and triggers. Too many indexes can slow down inserts and triggers can definitely be a killer.

I'd also...

I'm not sure exactly what you mean by add a red dot on the top of the column. Do you mean you want a red dot at the column...

WayneS (4/7/2010)

---

RalphWilson (4/7/2010)

---

Whil;e I agree that data should not be changed without careful consideration, I also have to deal with the very problem discussed in the editorial and yet I...

James Goodwin (4/7/2010)

---

In this respect it is not necessarily pain and/or punishment...

These kind of issues arise all the time when migrating from a legacy system to SQL Server. As part of my current project I have written an SSIS package...

I think the survey is okay. I'm not a big fan of question #2, but I don't think that is a reason to move it out of the survey.

I'd...

WayneS (4/2/2010)

---

Grant Fritchey (4/2/2010)

---

I'd say the cert can be tied to a product version. Say you get certified for SQL Server 2000. You'd still be fully employed here where I...

CirquedeSQLeil (4/2/2010)

---

Lynn Pettis (4/2/2010)

---

I also believe that the certification should be renewed periodically, minimum 3 years, maximum 5 years.

Recertification should include testing, presenting original material at users groups/conferences, attending appropriate...

CirquedeSQLeil (4/2/2010)

---

Very...

CirquedeSQLeil (4/2/2010)

---

Jack Corbett (4/2/2010)

---

To this point I've stayed out of the more detailed discussion, but I'll weigh in on the TIS.

I think it needs to stay in. I agree...

To this point I've stayed out of the more detailed discussion, but I'll weigh in on the TIS.

I think it needs to stay in. I agree that it would...

That's totally annoying. Even Google has gotten into the act. Google is now Topeka. They...