However this isn't that much better.

BEGIN TRANSACTION

DELETE FROM table1

DELETE FROM table2

DELETE FROM table3

DELETE FROM table4

DELETE FROM table5

DELETE FROM table6

COMMIT TRANSACTION

What do you think will happen if the delete from table3...

Yes you can. No there isn't.

Yes, absolutely yes.

As you have it, it's a security risk (SQL injection) and subject to poor plan caching and reuse.

Is the delete getting blocked?

Err.. everything. 🙂

That's a create table statement's form. Alter has very different syntax: http://msdn.microsoft.com/en-us/library/ms190273%28v=SQL.100%29.aspx

What are you trying to...

http://sqlinthewild.co.za/index.php/2011/11/11/sql-university-advanced-indexing-indexing-strategies/

http://sqlinthewild.co.za/index.php/2011/11/11/sql-university-advanced-indexing-indexing-strategies/

Do you want to start by crippling the server and...

Grant Fritchey (2/5/2013)

---

Other than that, I'd say recognize the access patterns and then build indexes to support them. In most circumstances, compound keys and included columns work much better than...

How would you get an incorrect checksum in the log anyway?

Checksums are on database pages in the data file.

There are instances of log corruption, that's not one of them.

Absolutely do...

Either db_datawriter role or UPDATE, INSERT and DELETE granted on the table.

Have you fixed the errors in MSDB yet? If not, that's probably why you can't create a maint plan.

erics44 (2/5/2013)

---

i assumed it was because the ssis package used the tempdb differently

the sql is identical in both, originally it was better in a ssis package because data was coming...

I mentioned those:

or have complex select/from portions to those insert/updates that does hash joins...

Don't suppose you could post the graphical plan? There's not enough info in that text plan.