does the\\ is the problem... that what it is showing in error msg. There should be one \ for fixed drives. It is a mapped drive so i...

Thanks for information. I got the point.

yes Gail, mostly less than 100 pages .can you explain what it actually mean. rebuilding indexes are not effective for indexes with less number of pages.

Thanks for your suggestions

is your service broker enabled in msdb

SELECT OBJECT_NAME(OBJECT_ID), index_id,index_type_desc,index_level,

avg_fragmentation_in_percent,avg_page_space_used_in_percent,page_count

FROM sys.dm_db_index_physical_stats

(DB_ID(N'AdventureWorksLT'), NULL, NULL, NULL , 'SAMPLED')

ORDER BY avg_fragmentation_in_percent DESC

I used this script to found Fragmentation before and after rebuilding indexes.

Thanks for your information.

Yes you can get a idea by seeing the table.

First of all know the normalization forms and see whether they are implemented in table or not.

example: In your table there...

As you said it depends. Sql itself creates VLFs and it determines the size. what we have to do is we have to keep this VLF count as...

Thank you. I got the point.

windows 2008 r2 and sql 2008r2

Capacity for existing

Thanks for our help....

Thanks Gail...

If two databases in a instance are in different collation . Can we implement replication in between them and any other tasks related to those databases.