I use a free plug in for SSMS... http://www.tsqltidy.com/ It works pretty good.

You are not alone. I have not gotten one in a few days.

It appears that you are missing a ) after the fields you have listed

Insert into table1 (field1, field2) select fielda, fieldb from table2

http://www.w3schools.com/sql/sql_insert_into_select.asp

WITH DEFAULT_SCHEMA=[dbo]

Users based on logins in master

CREATE USER user_name

[

{ FOR | FROM } LOGIN login_name

...

You are using the Distinct in a sub-select in the where clause using IN, why use distinct at all? Whether you have 1 record that matches or 100 records...

Restart sql and it will create a new tempdb the size it was originally set up as. However you need to find the root cause of what made it...

We were able to resolve this by in the Failover Cluster Manager navigating from the cluster name to More Actions -> Move Core Cluster Resources -> Select Node and picking...

- You have a three node Windows Server Failover Cluster -- Yes

- You have three SQL Server instances - one per node? And are they standalone instances or Failover Cluster...

Yes to a network share, and the wizard creates the full and tlog backup, they are both on the share, but when it goes to restore the tlog it says...

The servers were listed in the SETSPN -L. Somehow the problem is resolved, we still aren't sure how. We removed and registered some of the servers in DNS...

Brent Ozar has a good checklist for availability groups:

http://www.brentozar.com/sql/sql-server-alwayson-availability-groups/

Have you tried union all? The columns just need to be the same, so you will need to add a dummy column of the same type to your second...

I should have been more clear, we use sql and litespeed to back up and then back up the backups to tape. So this would just be the secondary storage.

This is probably over kill, but if you might not have the same id in both tables this will give you all:

select a.id, a.e - a.f as Diff

FROM (select id,...

Unfortunately we have a mix of 2000 and 2005 here. We haven't moved anything to integration services yet. I was hoping to utilize some of the better 2005...