Viewing 15 posts - 14,761 through 14,775 (of 49,552 total)
Because there has to be an entry in there for tables without clustered indexes. Heaps get an index id of 0.
January 17, 2013 at 2:40 am
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...
January 17, 2013 at 1:19 am
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,...
January 17, 2013 at 1:18 am
Please post new questions in a new thread and give as much information as possible. Thanks,
January 17, 2013 at 1:00 am
That should just run on the indexes in the specified database.
January 16, 2013 at 1:14 pm
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...
January 16, 2013 at 1:10 pm
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...
January 16, 2013 at 12:59 pm
What's the definition of AX_ASSYST.dbo.jptsys_isel and what indexes does it have?
January 16, 2013 at 11:32 am
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...
January 16, 2013 at 11:24 am
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.
January 16, 2013 at 11:23 am
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...
January 16, 2013 at 9:23 am
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
January 16, 2013 at 8:03 am
Script the restore that you used. Post the script.
January 16, 2013 at 7:27 am
No. Repeatedly shrinking and letting it grow might lead to file-system fragmentation.
January 16, 2013 at 7:26 am
Viewing 15 posts - 14,761 through 14,775 (of 49,552 total)