Donalith (10/12/2010)

---

Thanks all. What I gather from the responses is that there really isn't a faster way to move/copy the table.

For example, in MySQL I could just go into the...

My gut tells me to convert his process to inserting a record for each request and then running a scheduled job to get the counts and update tableA with a...

Donalith (10/12/2010)

---

Derrick,

Unfortunately, we've grown out of control on the production database (happened before I came on board) and we can't replicate it due to storage issues.

Alvin,

How do you export in...

This part is the issue:

AND (NOT email IN (SELECT email FROM failures))

AND (NOT email IN (SELECT email FROM removes))

AND (NOT email IN (SELECT email FROM contacts));

I'd be willing to bet...

If you're deleting all data out of the tables, why not just drop/recreate them? Drop/recreate is MUCH faster than doing a full delete on everything.

You have a few options.

If you're using enterprise, you could take a database snapshot and then read from the snapshot without blocking production.

You could also replicate that table to another...

If it's always .abc (period, 3 letters) then you can just do this..substitute with column name if selecting from a table or CTE.

select left(fieldorvariable,len(fieldorvariable)-4)

He explicitly named the column transactiondt in the first CTE, but then specified an AS LastRODate in the select..and then tried to call it by the LastROdate, so it wasn't...

Separate spindles is ALWAYS better..although not always possible due to SAN storage being shared/spanned, cost, etc.

There is no true active/active for SQL. You have one instance on one node, and another instance on the other. They're essentially two separate servers, so change the password on...

Just a note in addition to Gail's post:

Create the login on both servers, preserving the SID, then grant the user whatever read permissions you want them to have on the...

Just a note..that whole thing about 1 tempdb file per cpu core is outdated. It was probably true back in SQL 2000, but nowadays it's bad advice. You should have...

I would go with log shipping..It's very easy to reset a target database with log shipping because you have all the physical files available and ready to go. Replication/mirroring require...

I'm a huge fan of Michelle Ufford's script, if you're looking for another option:

http://sqlfool.com/2010/04/index-defrag-script-v4-0/

Yeah..if it's an insert, and he's using the british method of YY-DD-MM (I think that's what they do) and both DD and MM are < 12..there's a chance it would...