AWESOME! :w00t:

What is the isolation level you are using?

Can you show me the code you used for batch deletes?

Megistal (1/13/2010)

---

Thank you for your post Lynn

However, my issue is not with the log file (this is handle separately), it is the tempDB mdf file size.

If I'm deleting half the...

You can save the plans graphiclly as a .sqlplan files and upload those. It would be easier to read.

Play it safe, use VS2005.

Could you post the two actual execution plans?

You may want to read this article, http://www.sqlservercentral.com/articles/T-SQL/67898/. It is meant to manage the growth of a databases log file, but it may also help you with the growth...

No.

Yes, I am recommending the the Primary Key be changed to a nonclustered index and that currentdateout be made the clustered index.

If you look at your actual execution plan, you...

Thank you for the feedback. I'm glad I could help.

I'm not PC (political correct), I'm PC (politically comfortable).

Run the following substituting your database name where indicated.

select

database_name,

is_copy_only,

type as BackupType

from

msdb.dbo.backupset

where

...

Gatekeeper (1/13/2010)

---

Whoops, wrong window on the copy and paste but makes me wonder if the initial FULL was done with the improper arguments. But had that been the case, wouldn't...

Gatekeeper (1/13/2010)

---

Today, one of my tests failed for checking database backups. I tried restoring via SSMS by selecting the FULL and most recent DIFF in the history and restore on...

A count of unique email addresses, I am assuming as well. Does the user have the option to restrict the date range on the search?

If so, I would also...