Have you looked at:

[*]How much free bandwidth there is between the datacenters

[*]How much data is to be transferred

[*]Your time requirement

To see that it is actually possible to transfer the amount...

For the partitioning to work as intended, you'll have to ensure that the partitioning key is included in the where clause of your queries.

Works just like a charm here:

use tempdb;

go

create table MenuTest (

xmlMenu xml

);

insert into MenuTest values ('<menu xmlns="http://xxx">

<menuItem name="Menu1">

<menuItem name="SubMenu1">

...

Is all your nine data files in the same filegroup, or in different filegroups? SQL Server use a kind of round-robin algorithm called proportional fill to allocate disk space to...

First of all, your requirements don't makes sense to me. It is not so that 15 + NULL = 15. NULL is an unknown value, not 0. But, this is...

In my humble opinion, the only option here is to have the Witness Server on a third host. No matter what server you have the witness running on, if that...

Have a look at the merge statement.

Quite common scenario. Permissions are set at two locations in Reporting Services, at the folder level and at the server level (top level view of reporting services web site). I...

Truely, there is no single "correct" answer to when statistics should be updated, and your post reminds me that I've thought about writing a few words on statistics. Kimberly Tripp...

If your queries typically access data...

For more information: Using Files and Filegroups. The algorithm for distributing data across files is commonly called proportional fill, and is as Gail stated based on round robin.

Honestly, it makes sense that roles and server level permissions are not included in this script. The script is intended for transferring logins, and is mainly used when you transfer...

Not trying to be rude, but have you tried Google?

Well, first of all I start off with formatting the code in a way so that it shows a bit clearer what it does:

SELECT

INVOICE.INV_NUM,

INVOICE.INV_AMOUNT,

(

SELECT

AVG(INVOICE.INV_AMOUNT)

FROM

INVOICE

)...

I can't remember it at all, is it really a part of SQL server or a 3rd party tool?