Bandwidth is only one of the considerations for choosing the repication topology. The frequency of changes in the publisher and the data staleness will also matter.

e.g if you have a...

http://msdn.microsoft.com/en-us/library/aa933154(v=sql.80).aspx

Read this , any doubts after that can be explained on this forum

Look up resource governor

http://msdn.microsoft.com/en-us/library/bb933944%28v=sql.100%29.aspx

/*

Declare a common variable which accepts both regionid and department

Left outer join to department table on regionid

where clause should now have filter for both regionid and department based on OR...

Nice !!! , I can easily see the data volumes increase to that level and beyond over the next few years. I think the majority of the data is going...

the packages should run fine own their own as seperate process. However you might want to consider using checkpoint files to make sure that any unexpected failures in one package...

Is this a one time report or something your using to track the usage over a period of time ?

you could use any of the following depending on which version...

Have u checked for any blocking issues?

Are you using any hints in the procedures ?

in order to send out email alerts you have no choice but configure DB Mail.

The only time you can use the operator without setting up DB mail is if you...

Since ur using SOAP request , are you looking for total request response time or just the query execution time ?

If you want to monitor the actual procedures being called...

Database mail is configure to let sql server know which account to use to end emails

The operator is used to configure the to list as well as it supports...

How about simply running DBCC FREEPROCCAHCE

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

It should be sufficent to identify which proc is the reason and then specifically set it to recompile . FreeProccache is gonna wipe out all plans and that could hurt...

Silly question but have you restarted sql server service after making the above changes ?

A cte like a table should be considered as a placeholder ( an array in which data i stored for further manipluation e.g order by) for the data.

As such; these...