Its possibly more dangerous to have a user defined objects in your Master database.

However, I dont think its an issue when you consider it logically the sum indacates that you...

It is, BUT it depends on the data in the streams and how you want to merge the streams.

You could use a UNION task if you want vertical integration,...

Scott,

Do you have a link to that, as I didnt think that either a unique or PK were required for CDC as I cant find anything on Technet or in...

That may be true but you...

Check the index sizes on the source tables, as they can sometimes be left off the target database when archiving.

You could also investigate the use of Page level compression on...

Thanks for this, I did consider this as an option, but found that it wasnt that performant overall due to the structure of the source tables that I was reading...

To my knowledge the inbuilt CDC component in SQL server doesnt require a Primary Key column.

The reason is this is simply a log of the activity, so if you...

As a general rule Way 2 would most likely perform better and is also easier for people to understand down the line.

Cadavre,

The changes I suggested were to create a seperate table for tax rates and reference it from current taxes table with a possible name change to company_order_taxes and reference the...

Glad to help,

There are a number of concerns in your design, though I dont know how much scope you have to change the design, it would be worth considering the following,

1)...

It should be fairly straight forward, this query will return all rows where the Startdate is greater than or equal to the current datetime

Select

Resources.DisplayName,

Bookings.StartTime,

Bookings.EndTime,

Users.LoginName

From

Bookings

Inner Join Users

On Bookings.BookedBy =...

1) The parameters at the beginning are probably there to allow some sort of debugging to take place or to be able to run it outside the confines of the...

You should be able to send a test email from under the Database mail option in SSMS, though I believe it uses the Users credentials rather than the server service...

In terms of SSIS you may also have to apply the DataBaseMailUserRole permissions on MSDB to the SQL server Agent login or the account used in any proxy.