winston Smith (1/8/2009)

---

im thinking the optimizer will pick the (string, dt, id) index as it has less rows to return with the string, max of 100, rather than 5000 or...

Why are you storing and modifying large pieces of xml in a database? Why are these claims not in their own table?

When's the last log backup from before the full? Full backups don't truncate the log, so you have to look at the activity from the last tran log.

Full recovery? Bulk...

Please don't edit your questions away. It just makes it confusing for everyone who reads it afterwards.

It's also polite to let us know if the solutions worked or not.

crfenix (1/8/2009)

---

but unfortunetly this approach isn't handle ALL error types and some times somethig wrong happens in the middle of the execution and there is no rollback with the...

I hate it...

There is no config switch that treats a real table as if it were a temp. If you're doing a select into a permanent table, it's a permanent table.

Are there...

Excuse me?

SQL absolutely has the ability to lock rows been modified. It's an essential part of a relational database, isolation, the requirement...

That's internal objects (worktables, table spools, index spools, etc), not temp tables

Jack Corbett (1/7/2009)

---

GilaMonster (1/7/2009)

---

SQL 2005 caches the structure of frequently used temp tables. It's an optimisation to reduce the impact of frequently creating and dropping the same table. That may...

sampathsoft (1/8/2009)

---

i'm making transaction base software using sql 2000 . In my program i want to stop insert,update and delete when another user modifying same record set at same...

Can you please post exactly what you get by running the following:

DBCC CHECKDB('msdb') WITH NO_INFOMSGS, ALL_ERRORMSGS

Correct, all the info is in the index.

if this is the only index on...

What does the error log say? It should have some info about the shutdown, and it will have a lot of info about why the service won't start up.

Turn traceflag 1222 on (DBCC TRACEON (1222,-1))

Any deadlocks that occur will have the deadlock graph written to the error log. The deadlock graph will have enough information to locate...