Not really a good test.  On my desktop system the numbers were a lot closer.  But what is also interesting is if you look at the execution times of each...

Actually, #tables and ##tables are more like database tables than table variables.  Yes, table variables and #tables are created in tempdb, however, SQL Server does not handle them the same...

Ninja, I agree.

Like I said, arguing is pointless.  Neither of us is going to be swayed to the other side.  You can continue to write your code your way and I will...

Don't do an explicit log truncate after a transaction log backup.  You may truncate a transaction that completes after the transaction log backup.  Let the transaction log backup handle deleting...

Sorry to disappoint you, but I am knowledgeable about the subject, although I may not be an expert.  It is better to explicitly destroy that which is explicitly created.  It...

The other issue to consider: system performance and scalability.  When does SQL Server destroy your #table temporary tables?  Do they automatically get destroyed and free up disk space in tempdb...

In a properly designed system, if you create a temporay table, you should drop it.  You should not rely on the system to clean up after you.

Try this:

select count(*) from (

select

    a.IDP,

    a.IDQ,

    b.IDQ

from

    dbo.ENC_ANSWERS a

    inner join dbo.ENC_ANSWERS b

        on (a.IDP = b.IDP)

where

    a.IDQ = 'Male'

    and b.IDQ = 'Office'

) t

hth

Agree. It is always a good idea to drop the temp table rather than relying on SQL to clean up when the table passes out of scope.

Definately sounds like a permissions issue.  As above, look at the account that SQL Server is running under on the server.  It needs to have access to the Linux server...

I think that depends on how you do authentication.  If you will be using Windows Authentication, then the answer is most likely, yes.  If you are using SQL Authentication, then...

The two methods I have had success with are the detach/attach and backup/restore.  I have not had any success with the Copy Database method using SQL Management Object method.

hth

Luke L,

One thing in your explaination about backups: full and differential backups do not truncate the transaction log.  That is only done by the transaction log backup.  Full and Differential...

When you truncate the transaction log, you are deleting all commited transactions that have been checkpointed (written to the database).

If you are no doing transaction log backups, and only truncating the...