Because there has to be an entry in there for tables without clustered indexes. Heaps get an index id of 0.

Index on IsDeleted, SubmitDate DESC

Probably won't be used unless there's a small number of rows that qualify or you can get rid of that SELECT * , retrieve only the...

Only Enterprise edition allows piecemeal restores (a database restored and online with only some of its filegroups). Since you're not running Enterprise edition, you'll need to restore the other filegroups,...

Please post new questions in a new thread and give as much information as possible. Thanks,

Enterprise Edition? Or Standard?

That should just run on the indexes in the specified database.

Agreed on changing the pk to clustered.

Can't tell without lots of analysis, but single column nonclustered indexes are typically not very useful. Maybe check how often those are used?

The index...

You can't.

You can encrypt the entire DB with TDE, that's protection against backups been stolen. Otherwise, secure the server, limit access to SQL and make sure you have your...

What's the definition of AX_ASSYST.dbo.jptsys_isel and what indexes does it have?

Deadlock graph without the mess from traceflag 1204.

deadlock-list

deadlock victim=process770db88

process-list

process id=process770db88 taskpriority=0 logused=0 waitresource=RID: 26:7:26464:0 waittime=1130 ownerId=1198846832 transactionname=implicit_transaction lasttranstarted=2013-01-16T09:09:52.350 XDES=0xc9843950 lockMode=U schedulerid=5 kpid=6528 status=suspended spid=479 sbid=0 ecid=0 priority=0 trancount=2 lastbatchstarted=2013-01-16T09:10:00.910 lastbatchcompleted=2013-01-16T09:10:00.910...

It's not actually encryption, it's obfuscation. Give me a DB with encrypted procs, I'll give you back the decrypted versions in maybe 10 minutes, if that.

Edit: nm

For future reference, just traceflag 1222. You have 1204 on as well which resulted in a mess of a mixture of two deadlock graphs that's going to take far...

There's no such thing as a virtual table in SQL. You could write your code to insert into temp tables and later into the main table, probably over-complicating things

Script the restore that you used. Post the script.

No. Repeatedly shrinking and letting it grow might lead to file-system fragmentation.