Mike,

I don't have access to Publisher and distributer server, we are only subscribers and don't know what kind of replication they configured to provide data.

By my guess i had created...

Mike,

I don't have access to Publisher and distributer server, we are only subscribers and don't know what kind of replication they configured to provide data.

By my guess i had created...

Thanks again for your support.

[Much of this depends on how you want to use the database and how much resources you have available for making changes. If all you really...

First of all thanks for your reply and help. I am giving you reply to your questions in steps below:

[Some of that depends on how you will be using your...

Although this is not a best practice but for the sake of saving time, you can start publication wizard and when selecting Tables for publication (articles) it will mark tables...

i have fixed my query;-)

select object_name(id),

case when patindex('%Media%', [text]) > 0 then 'tbl_Mediaelse '' end as Media,

case when patindex('%MediaDetails%', [text]) > 0 then MediaDetails' else '' end as MediaDetails...

Following are my replies to your question:

"Option 2 (Filegroups and RAID1+0)"

http://msdn.microsoft.com/en-us/library/ms187087.aspx

Improving Database Performance

Using files and filegroups improves database performance, because it lets a database be created across multiple disks,...

Is the "excellent script" from blog related to FullText Index? Please help. Actually, we have just started working on FullText searching enabled application and have no idea how to managed...

I think there is another way to check it if its working or not. Sometime ago i read that in a forum and i forgot to save that informartion in...

from the replication monitor, your desired publication, see there are three tabs on right side, click on "Warnings and Agents" Table.

Under the "Agents and Jobs relarted to this publication" ,...

Your question is too specific. Please write some details about your problem to understand and give right answer.

Shamshad Ali

Yes, you are right and i would appreciate to have comments from everyone and get idea which one will best suite in my scenario mentioned above.

We actually want to keep...

Thanks for your suggestion, I never worked on replication which do NOT apply deletions to subscribers and Need to test this as a solution- if it works and has not...

Actually we are doing this technique (archiving) only becaues of Performance issue. i would like to know which option will be best? either archiving or table partitioning?

here a guy has...

Thank you all for your reply. You are right that we only need data warehousing only for the purpose of reporting, nothing else. We have slightly changed our plan, that...