I am not totally sure what the problem is, can you describe what you want to achieve?

Also be aware that distinct means "return me only rows that have a difference...

Hi John,

Only something I hit with 2005. Prior to that you coukld do ..

select * from foo order by bah

and then change to..

select bah, * from foo order by...

Simple answer is you must name the columns explicitly in the select statement.

You can use something like tablename.* (or correlation_name.*) to say all columns from one table, similarly you could...

Assuming you mean the total length is 5 characters including any embedded spaces then..

select foo from bah where len(foo) = 5

or if the embedded spaces do not count

select foo from...

Another possible implication of two raid 1s would be if they were the same filegroup, with a massive table that was frequently being scanned. If I remember rightly in that...

Some things to try -

If there is no possibility that the two queries (either side of the union) can return duplicates you could make it "union all" which may...

I am not aware of any global setting for this and frankly would not want one. Setting read uncommitted can on occasions be one way to help resolve locking problems,...

Looks like it should work to me - but can you post the full ddl of both tables - are you sure there is an identiity column on the...

Do you need a tool - you can do it in SQL?

Assuming a table called images that looks a bit like this:

create table images (

image_id integer identity primary key,

image_name...

If you chaneg the db option to make it "AutoClose" then you will find messages in the SQl Server log file every tim ethe db get used. This may give...

Very difficult to give a full answer without knowing a lot more about your data, but it sounds like you ahev got the principles right. If you post the create...

I suspect there may be some sort of authentication issue causing timeouts while checkinmg permissions. I would check the account dteails the jobs are under, permissions to those accounts, access...

I have not used the pro edition of sql compare, but have used older versions and it was very good for finding differences between two databases but I would not...

The concept of linked servers sounds what you need - if you really need to copy all the data across. BOL will describe everything about linked servers.

As for how long...

Two things to check ..

What is the data type of all columns in the index?

Are the two databases collations the same?

Reason for asking is if the columns are char/varchar etc...