No replies at all..!!!!

None has come across such a pbm .??

Thank you somuch. Am clear now.

Thank you somuch.

Infact I had used the second option...

The exact requirement was I had to select all those emps with all those 3 components and from that list I...

Thanks for your reply.

Requirement is simple...

Want to pick those records from EMP table which has got all following components in the second table.... nothing else...

Cmp_1, cmp_2, cmp_3

Thanks aagain

Thanks for your replies..

So what's the workaround..? Will it work perfectly if I convert both the values to uppercase...?

Thanks a lot once again.

.. Still awaiting for responses..!!!!

WISH YOU ALL MERRY XMAS...

Wel, I dint like the question much becos there was no any clue to guess at all...

or may be bcose I lost 25 points. 😉

Hi,

Thanks for your response.

I am sorry that I can't post the query here.

I tried to simulate the issue in test, but couldn't.

But beleive me, it's a strange problem. And...

Thanks for your quick reply.

Problem resolved. First query is Grouped By "AppName"

and second query is Grouped By "Server".

When I made first query to be grouped by "Server, AppName' result...

Ok. I dint capture it last week, since it's a production server, manager will allow to get this data only on saturday.

Wel, What information we get from the details...

Yes sure, as given below.

record_countghost_record_countfragment_count

===================================================

838864 2077 ...

Hi Gila,

Default fill factor is '0'.

Hi Gila,

Below query is used for getting fragmentation details,

SELECTOBJECT_NAME(i.OBJECT_ID) AS TableName, i.name AS IndexName

, IDS.avg_fragmentation_in_percent

, IDS.avg_fragment_size_in_pages

, IDS.avg_page_space_used_in_percent

, IDS.record_count

, IDS.ghost_record_count

, IDS.fragment_count

FROMsys.dm_db_index_physical_stats(DB_ID('dbname'), object_id(@tb_name), NULL, NULL, 'DETAILED') IDS

INNER JOIN sys.indexes i ON...

Thanks Adiga.

YES.... I am using the same..?

Any problem with it..?

by the way "rbuild" took 2.30 hrs to complete.