Designing Partitions to Manage Subsets of Data:

http://msdn.microsoft.com/en-us/library/ms191174(v=SQL.90).aspx

1. To minimize downtime, we recommend Start the rolling upgrade by updating any mirroring partner that is currently the mirror server in all its mirroring sessions. You might have to...

Many options:

Linked Server

BCP

Export Import Wizard

SSIS

Please go through following article.

Factors That Can Delay Log Truncation:

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

Troubleshooting a Full Transaction Log (Error 9002):

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

This is the issue of version / change management. What exactly you need is a process to manage the changes in database and it should be strictly followed at the...

SQL Server reads / executes binaries when it starts. After that it uses memory to refer SQL Server objects. Thus there would be no (or less) read / write operations...

Yup... We all hate to restart the server but most of the times it works well. :laugh:

As you said the replication was running fine since a year so I assume there is no procedural issue in it. I guess there is some issue with the page...

Either you go with multiple schemas or multiple databases the DEV effort would be the same. However I see few manageability benefits in both the approaches.

If you choose one database...

Use a service account for SQL Server Service, which has access to UNC drive. However a bad example but if you can access UNC drive with 'domain\user' account configure you...

Please go through following article. It will answer all your questions.

Files and Filegroups Architecture:

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

When you create an object (say a table), it goes to PRIMARY file group (unless you specify any different). SQL Server decides how to manage data of this table in...

In Replication you define the articles for publication which could be a subset of database e.g. few tables. Log Shipping works on a database as whole.

You may find it an out-of-track suggestion but have you considered creating a new table splitting it into multiple files (may / may not be partitioned) with clustered index (may...

Please post your query here for analysis.