Thanks. I ended up opting for creating a new database, since the data on this database would have a different concept, even though they would have some tables and IDs in...

I see. Would be a reasonable idea to replicate these tables with static data also in the new DB, so the distributed transaction does not need to exist, and this...

Thanks for your help!
What do you mean by 'three-part-naming issues'?
If I just add the new tables to the existing database in a different filegroup, the read/write operations will...

Seems a good solution. Thanks!

Ok, thanks.

Want to delete several rows from a table (several gigabytes) (not truncate) and avoid that to be logged to ldf file, to avoid its growing.

It's solved.

The connection string format is correct.

The sql server instance to which I was trying to connect was stopped..

Thanks for all your answers!

Besides it would work, I will use dynamic sql and read the link recommended!

Regards

Thanks!

Following the links you suggested, I was able to open it using InterBase XE3.

Thanks! I will look.

I think I will need to study execution plans to accomplish this. Any advice where to start?

Thanks

The execution plan with group by is using a 'Index Scan (NonClustered)', so I think the index seek in the correlated query is better.

Thanks

Thanks.

Would the 'group by' solution, grouping all results from MyTable2, be a better solution than the correlated query?

It is not an OLTP database and the query is executed frequently, although...

Yes,

Index Seek (NonClustered)

This error does not happen always.

Looking at the execution plan it displays among others:

Nested Loops(Inner join) 0% < compute scalar 0% < stream aggregate 0% < Index Seek (NonClustered) 8%

Any...