Okay - so you need a 4 node cluster with one of the nodes in a separate DC.  The first step is to create the 4 node cluster - if...

This is a very wide subject - and it all depends on what you are trying to setup and configure.  Is there an existing system already setup - or are...

I changed both queries to use the Not Exists, and so far looks promising in the performance category.  I have a archive process setup to keep both Quality,the Detail...

I don't see how Powershell would give you more options - you are looking at secure FTP which is simple FTP over a secured connection.  Even with PS - you...

Temp tables are local to the connection/process that creates them - multiple 'threads'...

Don't use a process task to call this - use a script task and invoke Powershell in that script task.  Or - do what most others have done and use...

This really should be done in the presentation layer.

With that said - not having any consumable data to test/validate, what I would do is include a column with the total...

But any lookup table does NOT need to contain a list of all zip codes as originally stated.  If the "slab" is what is significant, the lookup only needs...

Have you tested the query with the proposed changes?  The suggestions on the changes to the EXISTS should help quite a bit - and you really need to know what...

Nope, just examples I found.  A vendor system I support does use service broker and has conversations set up.

Here are a couple more that won't have a corresponding END.

• BEGIN CONVERSATION TIMER;
• BEGIN DIALOG CONVERSATION;
• BEGIN DISTRIBUTED TRANSACTION;

Are you looking for a way to build a new database with no data - or do you need data also?  If you want a database with the schema only...

We are a shipping logistics company.  So naturally we deal with zips A LOT.  U.S. shipping zones are typically based off the first 3 zip digits, like 100 (NYC)...

Because the...

What is the DDL for the Quality_Attribute table?