The equivalent with IN would be

SELECT Members.FirstName, Members.LastName

FROM Members

WHERE Members.MemberID NOT IN (SELECT MembersQuizzes.MemberId

FROM MembersQuizzes

WHERE MembersQuizzes.QuizId =...

http://sqlinthewild.co.za/index.php/2010/02/18/not-exists-vs-not-in/

Does this work? (Untested as I didn't feel like converting the raw data you posted into insert statements)

SELECT Members.FirstName, Members.LastName

FROM Members

WHERE NOT EXISTS (SELECT 1

...

@@Error will show you the error code of the previous statement. If the previous statement failed, it will be non-zero.

You can also use the TRY .. CATCH syntax (available from...

Try DBForums[/url]. They have a MySQL section.

This site is for Microsoft SQL Server, not MySQL. Different database platforms, there are differences in the SQL language that they use

What problem? There's no documented way to read the transaction log,...

Recovery models: http://msdn.microsoft.com/en-us/library/ms189275.aspx

Recovery and norecovery: http://msdn.microsoft.com/en-us/library/ms186858.aspx (about half way down)

If you still have questions after reading that, please ask.

Don't forget to set up log backups for all of the databases if you switch them to full recovery.

sysname is an 'alias' for nvarchar of a particular length. so you can declare a variable of type sysname (handy when working with the system tables) and it's actually an...

No worries. I have it in shortcut menu. I don't go searching for it every...

Couple other articles that may be of interest: http://www.sqlservercentral.com/articles/Indexing/68439/ (3 parts)

Plus this may be of some use: http://sqlinthewild.co.za/index.php/category/sql-server/execution-plans/ and http://sqlinthewild.co.za/index.php/category/sql-server/indexes/

Coincidence. Just browsing a bit while making phone calls. I'm still staying mostly away from the forums for various reasons.

Please do post links to my stuff all over the place....

Please don't cross post. It just wastes people's time and fragments replies.

No replies to this thread please. Direct replies to: http://www.sqlservercentral.com/Forums/Topic911504-1633-1.aspx

The ldf is the transaction log, a record of changes made to the database.

Why do you want to read it? It's not intended to be human-readable, it's for...

Part 1: http://www.simple-talk.com/sql/performance/finding-the-causes-of-poor-performance-in-sql-server,-part-1/

p.s. In SQL 2005, you cannot force an index seek. You can force an index to be used but you have no control over how it will be...

Pleasure.