Speaking of "Assignments", was this all the information your were given? There's no clear information provided that really links each table together. Are you sure you have all...

Yes, handle and govern the whole deal. If I'm responsible for maintaining the data, I'm...

Thanks, I will check those links out today (and there's no rush on the upgrade - even though it was budgeted and approved, it could actually be a year before...

Sounds ugly.

What you could do is create a separate table to store the duplicates "OldPatientRecords" or something similar. Use ROW_NUMBER/PARTITION BY to extract your duplicate records (i.e. Where Dups...

How about this?

SELECT [columns]

FROM Client c

INNER JOIN Services s ON

c.SomeColumn = s.SomeColumn

WHERE s.START > GETDATE()-80

So the 2nd point I mentioned worked for you (great!). If you post your execution plan, we can probably get that thing to run in seconds...I'm still thinking there's...

As Mystery mentioned, do you have CDC (Change Data Capture) enabled? If so, it could be your culprit as it used replication behind the scenes).

They are already parameterized queries and the execution plans are going to be the same either way. To get around the cache bloat (and you may have already configured...

Check for FK relationships, I believe you have to drop the FK constraints first, then try what you were doing.

Try running sp_help on the tables to see what is tied...

Too many statements for your IF...block without proper BEGIN...END

(hyphens added to get around my VPN's proxy, so remove those)

Try this:

IF EXISTS ( SELECT * FROM...

The best answer I can give you is, Latin - "Table" is derived from the classical Latin word "tabula."

Maybe it got its name because it's a structure that you can...

Actually this is the better article (it's the source for the one I previously posted, and is much more detailed)

http://www.mssqltips.com/sqlservertip/1174/scheduling-backups-for-sql-server-2005-express/

You should be able to use sqlcmd without specifying credentials (I just provided a bad example above). Here's an article pretty much outlining exactly what you are trying to...

It depends on the kind of system you're talking about: OLAP/OLTP? What are the demands on the system on daily/weekly/monthly basis? How many databases/applications are supported by...

Curious to know how this panned out for you...did adding the extra log file help?

Wanted to mention another point...since you executed ALTER DATABASE MyDB

SET SINGLE_USER WITH ROLLBACK IMMEDIATE

I think you...