I'd look at two different ways of doing this, and neither is moving the whole thing and then deleting.

1) You can use transactional replicatoin with filters so that only...

I've never heard of either of those backup softwares. Just curious, what is it that you're trying to get that you don't get using the native backup capabilities?

I remember one time we had a requirement that we had to return 100,000 rows in 3 seconds. I'm sitting there with my jaw on my chest asking why on...

Tim Walker. (9/27/2011)

---

I started this thread more than a year ago now. Thanks very much for the replies to date.

We're now about to kick off another round of evaluation (partly...

Not jargon, but unavoidable technical terms.

You can identify blocking processes by looking at dynamic management objects (DMO). The one that most concerns you is sys.dm_exec_requests. That shows active queries in...

opc.three (9/26/2011)

---

Sorry Grant and Gail if I am being dense, but I am still not sure I got an answer for my original question. Maybe I am incorrect, but it...

I don't know what TWS is either. I tried looking it up online but I'm getting crazy stuff like Texas World Speedway. You have to help us. We're not sitting...

If I were looking at starting an upgrade process right now, yeah, I'd jump on to Denali & skip 2008. Think of it like this, 2008 is already almost 4...

You can reference a unique constraint when making a foreign key. It's that or a primary key.

Clustering is all about availability in SQL Server and has nothing at all to do with performance.

If your query is slow, why is it slow? What does the execution plan...

The traditional mechanism is to move only the data you need to move, when you need to move it.

I would not go for the "move everything, we might need it"...

The difference is how they're called. If you called a procedure through an execute SQL statement in your code, it'll come in as a TSQL batch. If you explicitly call...

The two indexes that both start with FiscalYear are questionable. Is that the most selective of the two columns in each index? Meaning, does it have the most unique values...

Not during a restore operation. You'll have to restore the database first, then drop the number of files.

By the way, I'd suggest leaving a few file groups, even if...

It sounds like something is pegging the resources. Do you have scheduled events in SQL Server? How about in the OS? Do you have any form of monitoring in place...