How the heck will that work with a country like USA or Canada where you have 1000s of cities?

Ya I'd like to know to!

Atif Sheikh (4/29/2010)

---

You can also use Triggers for parallel insertion but it can slow down the Insert / update process. Using Service Broker can be helpful in this regard. Just...

Has nothing to do with truncate or delete... if the user shouldn't have access to the data, then don't grant it.

hedera (4/28/2010)

---

Yes, I understand that I need a PK composed of 2 fields, each of which is an FK for another table. But my question is: in MS...

You don't need 2 pk in the MM table. The PK is both columns at the same time. Then you have 1 fk for each of the table...

This...

Grant Fritchey (4/28/2010)

---

Ninja's_RGR'us (4/28/2010)

---

From instinct here...

Assuming this job has already run succesfully in the past :

1 - Either the permissions changed (NTSF or sql login)

2 - You're out of...

Check out this QOTD, also check out the discussion that follows, all your questions will be answered there :

http://www.sqlservercentral.com/questions/T-SQL/69738/

http://www.sqlservercentral.com/Forums/Topic908285-1198-1.aspx

Are you using a reporting engine for this? Most, if not all of them, will handle that quite easily for you... such as a matrix in Sql Server Reporting...

From instinct here...

Assuming this job has already run succesfully in the past :

1 - Either the permissions changed (NTSF or sql login)

2 - You're out of space on the...

Here'a another way to look at it.

Let's say each row of data contains 24 bytes.

60 000 * 24 / 1024 / 1014 = 1.39 MB... maybe 3 mb if it's...

Apparently you're not to keen on reading full articles which would give you all the info you need to do this job so here's a "safe path"...

Ask for a maintenance...

Tao Klerks (4/23/2010)

---

I'm not sure my theory is that interesting, I suspect that I just misunderstood what Hugo...

Paul White NZ (4/24/2010)

---

Always good to see this question - the myth that TRUNCATE TABLE is non-logged (and so cannot be rolled back) is a persistent one.

Quite clever using 2008-only...