Jeff Moden (5/9/2010)

---

Keeps the locking localized to just a...

I think you're over thinking this a bit - if I am understanding the relationship correctly. Since the ID's in both tables match, you really don't need to track...

brutsoft (5/9/2010)

---

I would like to confirm that I got my problem resolved. Copying data from the master database took around 2 hours. Another 8 hours - shrinking the database, and...

How are the SSIS packages configured to run? Are they setup to use windows authentication?

If so, does the network account have a separate login to SQL Server with the...

I answered this over on SQL Team also, so check back there for that response. Basically, your trigger is going to fail for multiple rows on this:

IF (SELECT Age...

What account is running SQL Server?

And, you also want to make sure you run DBCC CHECKDB {database} WITH DATA_PURITY and get a clean result. ...

One you can use an update statement to update the data, the other you can't. 😉

If you need additional information, please specify exactly what issue you are having and...

Yes, you are right in assuming that views don't have cached plans. The queries that use the views will have a cached plan - but not the view itself.

Probably neither - since the view will be expanded into the calling query there wouldn't be any difference in the actual execution plan.

I would create a view if the logic...

craig-404139 (5/6/2010)

---

To add I understand that the application is setting database level security. My confusion is how that database security is tied to the sa account used in the odbc...

Yes - the utilities in SQL Server to remove backup files will only remove actual SQL Server created files. You could try setting up the job to remove text...

Grant Fritchey (5/5/2010)

---

I agree with Jeffrey, but not because I'd be sweating the SAN just going down. By and large those things don't go away. I'd do it because you...

What is the full error message? It is not showing up in the title.

I suspect, based upon a quick google search that your problem is because you don't have...

I've got to say that with that much memory and cpu's, with only a 28-30GB database, if you are still having performance issues then your problems are either IO related...