Hi frederico_fonseca,

Thank you for the sample script. I'll try to implement it. Thanks again.

It's worked. Thanks allot.

Hi frederico_fonseca,

Thanks allot for your help. Actually, I'm new to development and  I have multiple requirements with the same case\data. I can't post multiple requirements individually. So, included all of...

Hi Kherald,

Thanks allot for your response. I have an issue with your sample query.

SELECT COALESCE(a.id, b.id, c.id, d.id) id

, a.name, b.dept_id, c.mail, d.contact

FROM #Table1 a

FULL JOIN #Table2 b ON a.id=b.id

FULL...

Hi @frederico_fonseca,

If we use below statement,  only identical values are displaying. I need identical values based on id and union all should display. Could you please help me...

Thank you. It's worked. I need to insert the output into separate table. Could you please share any idea on that please.

Thanks again for your input.

Thank your for your response Steve. Will do and let you know the outcome. Thanks again.

Thanks for your reply.It may be some issue with the ports then.I will check with my network team.Thanks again for your reply..

Thanks allot for your reply Gail.

Still i am in confusion,

In the first case, less than 1000 pages--> we can ignore

second case : less than 8 pages ---> we can ignore

**************

Second...

Can anyone please reply to this post..

Yes, i am able to restore the copied logs manually.

Thank you very much.It is working perfectly..

DECLARE @Exec VARCHAR(MAX)

SELECT @Exec = ''

SELECT @Exec = 'UPDATE STATISTICS dbo.[' + CONVERT(VARCHAR(200),name) + '] WITH FULLSCAN ; ' + CHAR(13) +...

i need that query which has to be work on SQL server 2005

Thaks allot for your reply Gail shaw, I am executing the below query to check the fragmentation level in SQL server 2005.We need to follow with Average_Fragmentation_In_Percent

*Index should be rebuild...

Thanks allot for your help