No difference at all. The IN is expanded into ORs in parsing.

ORs don't cause scans. ORs with inadequate indexing however have no way to execute other than a table scan.

http://sqlinthewild.co.za/index.php/2011/05/03/indexing-for-ors/

GRANT is for granting permissions to a role, user or login, not for adding a role, user or login as a member of a role.

From BoL

sp_addrolemember (Transact-SQL)

Adds...

Anyone want to help on the blocking thread?

What do you mean there's no chance? That's how you stop the SQL Server service, from there (preferably) or from services.

Not enough information to help. Exact statement that is being blocked. Exact statement (not batch) that is causing the blocking. The Wait time. The exact lock types. The object names....

Ok, so something (unknown) is causing something else (unknown) to be blocked for (unknown) duration with (unknown) lock types requested and (unknown) lock types held on (unknown) objects.

Good luck fixing...

Jack Corbett (9/30/2013)

Okay, I need some more info on this one. I don't see anything on...

Stop shouting at us please.

Yes, blocking is possible. It should be short-lived. It's very hard to help you as you're not giving us much in the way of details. No...

Wish it was like that here. Was an unexpected slump late May, early June. I'm not the only one seeing it. Have two friends, one has just found his first...

?

It's got nothing to do with recompiles, the schema change did invalidate the old plan (schema changes always invalidate all plans relating to that table) and SQL did compile a...

The message implies that the database was in single user mode at the time the backup tried to run. Check for other jobs setting it to single user, check in...

Master is damaged. You'll need to rebuild the system databases, then once SQL starts restore your backups of the system databases to get all your logins and other stuff back.

http://www.simple-talk.com/sql/backup-and-recovery/the-sql-server-instance-that-will-not-start/

*sigh*

🙂