Hi David,

Sorry that was a tupo, its not 10K items , its 100K items. Considering the fact that we have 16MM records and 33 index on the item table.

Rows...

I just did a select * from table in 2005 and 2008.

2005 - it took 35 mins for 16 million rows

2008- took 48 Mins for 16 Million Rows.

I see...

Sandeep,

what details you need let me know? We did an in-place upgrade. Run time comparison is from the application log.

Seems like the table structure. I have a column named 'Source/Class' could this be causing a problem?

Thanks

Dev

Close EM and open new instance.

This seems to be a bug in EM. I have faced it many times.

Thanks

Dev

Reposted with a different question

Hi Gail-

SELECT * FROM SysUser WHERE CHARINDEX('_' ,Name ) > 0 --> Works and gives me 4 records

select * from SysUser where name like '%/_%' --> No...

Wow so quick...thanks Guys that helps. Here is another wasy to do that

SELECT * FROM Table1 WHERE CHARINDEX(@SearchParam , Col1) > 0

Thanks Again..:)

Thanks all for your help.. Appreciate it.

That answered my question.: So if rollback in continuing and we try to kill it it will not do any thing. will jsut display...

This describes what is the blocking and the blocked process.

You can see here both are same. i.e. 65. So this says its a self blocking, on the table as mentioned...

select suser_sname(owner_sid) from sys.databases where name = 'YourDB_Name'

Cheers

Dev

MSDN and books online

I would also like to know if this is possible?

select name as column_name from syscolumns where xtype in

(select xtype from systypes where name NOT IN (text, image, ntext))

and id = (select id from sysobjects where name like 'Your_table_name')

You...

You have to join sysobjects, syscolumns and systypes.

This should give you the desired result.