UPDATE tblRegNo

SET RegistrationNo = Replace(RegistrationNo, 'I', '1')

WHERE RegistrationNo like '%I%'

This is completed..

It might be the silly question....but, why we are not able to display e ??

select 1.a -- gives the column name a and prints 1 , which...

Awesome...Thank you very much for your help and patience...

yeah...exactly I got the same results as you told...in LIMITED, I returned only 1 row with page count 500000, index level = 0 and fragmentatoin is just .2% which is...

This is the result I m getting:

...

If I replace Detailed with LIMITED, I don't get any fragmented indexes....What does it mean?? we don't need to worry about this or what??

Thank you

No it is not upgraded....it is SQL 2008 ....there are 8 indexes on that table. out of 8, I m getting 3 indexes showing around 50% fragmentation, 1 clustered and...

The table has 5 million records....But in dm_db_index_physical_stats, it shows page_count = 6 and record_count = 1503!! Is that sample data or am I missing something? I m using...

Shrinking Database or just the log?? I think you can schedule a job to truncate and shrink the log file and take a full backup immediately...Just an idea, I don't...

you don't need to rebuild the indexes of all the tables in a database....you can use a script to re-index the tables which have fragmentation >30% and reorganize the indexes...

Thanks to both of you...

@GURSETHI -- This is not regular, just 1 time task. We are bringing a new server to our production servers and we just created...

I logged in as both sa login and Windows...I can't see them either...

Thank you

I didn't get that....

But, Directly If I login to the server i couldn't see the tables....If I connect to that server from my local SSMS, I can see...

Thanks for the quick reply....

do we have to Restart the SQL Server??? I just refreshed, disconnected and reconnected to the server...none of the developers or DBA can see the...

If you want to know the files in the Backup, execute the following query...

RESTORE FILELISTONLY FROM DISK = ' backupfilepath.bak'