You need to have more patience. This is a forum board of volunteers, not a help desk, who work at their own pace and on...

That's a GIGO problem. (Garbage In, Garbage Out).

You need to go back to the business and get their business rules on this and for what they want. This isn't...

Is this a third...

SQL ORACLE (5/6/2011)

---

We have some SSIS packages on one server. We are request to migrate these packages from it to another server.

We do not have any information on these...

Brandie Tarvin (5/6/2011)

---

Whoot! Did I mention I just got another story accepted? "The Hunt for Liberty Jones," my second science fiction story. And yesterday, I received the edits request.

Editor's Note:

---

...

DBAs: We monitor your packet-size.

DBAs: Scanning the bar, but seeking a date.

... I'll...

kcbeard (5/5/2011)

---

I have 1000's of rows of data in column A and B of table 1 in a database A

example data

ProductID --- ProductName

1...

coronaride (5/5/2011)

---

So even with tuning down the deletes to just 2500 per run, we've run into some lengthy table locks which have already resulted in our website being inaccessible. ...

^ Listen to this man, he's one of your best bets for partitioning help 'round these parts! :w00t:

I'm still re-wrapping my head around partitions atm, but this here looks like a good way to deal with...

The way you were looking...

No, not directly. You'd have to run Alter Partitions on a regular basis. Considering your desired partition scheme, I'd probably do it on weekends.

Check out these urls:

http://stackoverflow.com/questions/5140566/partition-table-based-on-variable-value-sql-server-2008

And a...

Shannon, to confirm, in the end,...

Chad Crawford (5/5/2011)

---

As a result, there were two databases on ServerA with routes back to an "initiator", one pointing to ServerB and one pointing to my box. After...

dg227 (5/5/2011)

---

1. (in SSIS 2008) create a package with a variable set to X ... output this variable name and value to a file, email, or whatever, so that you...