SELECT 'Y' as MissingFromTableName

, x.A, x.b

from X

where not exists

(select 'any old constant'

from Y

where Y.a = X.a

and Y.b = X.b

)

UNION ALL

SELECT 'X' as MissingFromTableName

, Y.A, Y.b

from Y

where not exists

(select 'any...

"But a file is not necessarily all contiguous. What if an IAM has extents from different areas of the file that are not physically contiguous"

Instead of "different areas of the...

Each object has at least one IAM for each file on which it has extents.

An IAM page is 8K bytes which is 65536 bits ( 8 * 1024 bytes *...

It is not clear from your post what you are attempting to do.

Some alternatives:

1. Populate a table on ServerA from the result of a SQL statement run versus ServerB.

2....

Did you change the SQL Server and SQL Agent Account using the Services Manager? If so, you will encounter a lot of problems.

Change the accounts using Enterprise Manager, restart...

See

http://www.sqlservercentral.com/forums/shwmessage.aspx?forumid=5&messageid=235185

Regarding performance

Look in the system event log for any hardware failure events.

Next, use performance monitor and look at these counters:

Network - Bandwidth vs bytes/sec - bandwidth should be much...

Please be aware that neither IF UPDATE() nor COLUMNS_UPDATED() will indicate if the column value has changed, only that column is "set" in the update statement.

See http://support.microsoft.com/lifecycle/?p1=2862

Extended support will end in 2010.

Mainstream support will end on 12/31/2005 (less than two months!).

WARNING - from the MS site:

Hotfix support that is not security-related requires a separate extended...

I absolutly agree with "GilaMonster".

Having a column with parts violates the principles of relational databases and will cause a significant number of bugs. For example: There was...

It is in BOL: in the index, enter transactional replication and then select planning. About halfway down in the page will be:

Primary Keys

All published tables in transactional replication must...

For reference on the trace events and trace columns, see in BOL sp_trace_setevent.

As sqlmaint.exe is a program, not a SQL statement, so "sqlmaint" might be in the "ApplicationName" field but...

One can get sqlmaint.exe or xp_sqlmaint to write to the maintenance history table by including "-WriteHistory" as an argument. When no maintenance plan is specified, the results appear under...

P.S.

The example uses the Northwind database

Think of an indexed view as an table where SQL Server automatically syncronizes any updates made to the underlying tables.

Maybe

If you are running either Enterprise or Developer Edition

- or...