Thom

I think you just use the "SID=" option in your CREATE LOGIN statement.  You get the SID from sys.sql_logins.

John

This doesn't use a correlated subquery, so it should perform better, especially if you have an index on Date1.  Parts of it are shamelessly borrowed from this article.

In your case, I don't imagine there'd be much difference.  If you need to join tables, you need to join tables, whether you do that in a view or in...

Thom

If you're rebuilding the same server on similar hardware but in a different place, then I can't see much harm in that.  But even then you'd want to...

Vin

I can't reconcile your two statements "It all works fine magically" and "the process will fail as it's meant to".  Why would anyone deliberately set up a restore...

Chris is right.  Look at the differences between the servers - both the environment and the actual SQL that's running.  I think you're barking up the wrong tree with MAXDOP....

Does your UPDATE statement have a WHERE clause?  If so, it's likely that it'll update some, but not all, rows in the table.  I wouldn't call that a discrepancy.  ("5039...

You're welcome.  Let me know if you find a database where file_id 2 isn't a log file - I couldn't!

You never answered my question about why you're doing this...

When was that second memory calculator posted online?  Technology changes, and MemToLeave isn't an issue in modern versions of SQL Server.  The memory allocated to the plan cache is included...

Yes, I think that is correct, although of course you could try it for yourself by clearing the plan cache and then running a statement that you know won't be...

Using a mapped drive won't work: the drive is mapped in your user context, but the xp_cmdshell statements run in the context of the SQL Server service account.  Is the...

I don't think you can do that easily.  This article explains how you can query the package XML - that may or may not help if your SQL...