Let me break that down to what I think I understood. I'm going for the simplest format:

1) Find all accounts with a transaction on a date.

2) For that account,...

Yes and no. Not a small order to contemplate, and in-depth work at the architecture level is usually paid well for. 😉

First off, it sounds like what...

tonyppham (8/16/2011)

---

Evil Kraig F (8/16/2011)

---

You can arrange something using the windows scheduler instead,...

Are these DML statements constantly morphing, or are they pretty much the same structure with different parameters?

If they're the same structure, have you looked into Service Broker? Pretty much...

Correct, and this is the older syntax for joins.

Old way:

SELECT *

FROM tblA AS a, tblB AS b

WHERE

a.Col1 = b.Col1

Is equivalent to:

SELECT *

FROM ...

You can arrange something using the windows scheduler instead, but it's not as...

Michael Valentine Jones (8/16/2011)

---

I am fairly certain that Sept 30th is the end of month. 🙂

However, when you add 3 months to November 30, it will return Feb 28 (or...

quillis131 (8/16/2011)

---

Evil Kraig F (8/15/2011)

---

quillis131 (8/15/2011)

---

What makes me Nuts: It was all good in Dev environment, and then deployed it onto Producation ( here it turns out to be crashed)...

Jeff Moden (8/16/2011)

---

A second run without rebuilding the test table shows a slightly different story, as well...

========== DATEADD/DATEDIFF ==========

SQL Server Execution Times:

CPU time = 1326 ms,...

quillis131 (8/15/2011)

---

What makes me Nuts: It was all good in Dev environment, and then deployed it onto Producation ( here it turns out to be crashed) with an errror saying...

I was originally going to call this a bad idea, but I decided a little sample million row...

Steve Jones - SSC Editor (8/15/2011)

---

Craig,

It's not inaccurate. You can sit for the test without having the certs. Multiple people, including myself have done it. You can't get awarded the...

Yeah, this won't be pretty, if I've understood this right.

Your VARCHAR(MAX) is storing standard ASCII coding, but also html tags and the like. Here's a problem with that:

<a>ABC</a> and...

I'm confused here Jeff, nothing bad happens on May 31 + 3 months. August 31st is a...

chandleya (8/15/2011)

---

I want to better understand the correct process of partitioning an existing table and hefty dataset. Once I'm sure that I'm -accurately- creating my partition scheme and process, then...