Paul White NZ (5/3/2010)

---

Is...

dubem1-878067 (5/1/2010)

---

Hello

I am looking for a software that will check (analyse) my stored procedures and tells me if there is missing index on tables, or if the stored proc...

these are the tables present in msdb

use msdb

go

select top 2 * from sysmaintplan_logdetail

select top 2 *from sysdbmaintplans

select top 2* from sysmaintplan_log

select top 2* from sysmaintplan_subplans

select top 2* from sysdbmaintplan_history

select...

What exactly you want here ? elaborate your requirement.

Refer this http://www.sql-server-performance.com/articles/per/detect_fragmentation_sql2000_sql2005_p1.aspx

Niths (5/2/2010)

---

But still am not clear with the output.. u are comparing 2 expressions in ur query... one is int with value 0 and the other is null... both...

But on the same server, different databases have same query with different results, it means that there should be some different database settings. if not then what else could be...

CirquedeSQLeil (4/30/2010)

---

To follow up what Grant said, do you have a way you can limit the results to be deleted? Add a range to the query or something that...

One more thought from my side , you are using table variable instead you should use temp table with clustered index on it as you are using these tables...

post the SP run sample code which you are using

Did you get solution ?

Also post

what below statement @sqlstr prints ?

post...

Post your script along with table/index defintion , may be we can help you

Can you elaborate your problem ? how do you think tempdb is culprit ?