Sean Lange (4/10/2012)

---

Lynn Pettis (4/10/2012)

---

Sean Lange (4/10/2012)

---

Please stop posting the same questions over and over. These are all very basic questions and they continue to have the appearance of either...

If you rerun the package to an empty table, do all the records appear? You might try debugging the package and put a data viewer before the write to...

Brandie Tarvin (4/10/2012)

---

Stefan Krzywicki (4/10/2012)

---

Brandie Tarvin (4/10/2012)

---

Stefan Krzywicki (4/10/2012)

---

I just registered for the SQL Server Saturday in Waltham in May. At the end is the ubiquitous "captcha" to verify authenticity....

Actually,...

Stefan Krzywicki (4/10/2012)

---

Brandie Tarvin (4/10/2012)

---

Stefan Krzywicki (4/10/2012)

---

I just registered for the SQL Server Saturday in Waltham in May. At the end is the ubiquitous "captcha" to verify authenticity. The word...

Pretty sure it isn't doing it to itself, someone has to be making a change. Your choices going forward are to setup some form of audit (trace, extended events,...

I'm sorry, but you aren't new to ssc. Please post the DDL (CREATE TABLE statement) for the table(s) including all defined indexes and your code you ran through DTA.

Without seeing the DDL (CREATE TABLE) statement for the table(s), including all existing indexes; the code you ran through DTA there really is no way to answer your questions.

TravisDBA (4/10/2012)

---

For off-hours issues they're the first one called but since it's not an official on call (ie not paid for it and don't carry pager) we're not...

Also, the DDL (CREATE TABLE statement) for the table(s) used in the query. Looking at it I am pretty sure this can be rewritten to be more efficient.

Would you please post the code for this function: dbo.dateserial. I think I know what it does, but I would like to be sure.

That's great. Now all you need to do is tell us how the problem was resolved. It may benefit others with the same...

I don't know about others, but it makes the code harder for me to read.

Just one question to start, why all the quotes? I don't see any reason for them just looking at the code.

Not really, same topic title, different question.