sys.dm_os_sys_info gives cpu information, but I don't think it's accurate for hyperthreading.

Not to my knowledge. Why would you want to do that?

Are you sure that nothing else is trying to log in using this account? I had the same problem the other day, same cause as Lucky posted above. ...

Note that you have...

Asynchronous is Enterprise-only, I'm surprised that you got it working as much as you did - useful to know though.

I wouldn't say that statement terminators are a bad thing ... I would imagine that it's quicker to parse a statement if you know where it ends.

Are there any...

Other than costing you a lot more?

I can't think of any - perhaps automatic substitution of indexed views could cause some difference in rare cases, but it's unlikely. Really...

I saw this and wondered how nulls were stored in an index, so I had a play and - it seems that having a column defined as nullable ADDS 3...

The version you are using now applies hash joins to the whole query, I was referring to the ability to apply the hint to a single join. Looking through...

Does it work if you use a hash join hint on the appropriate joins?

Do you have an indexed view referencing the table?

My (limited) understanding was that the NS functionality was going to be moved into Reporting services. Whether that functionality changes or requires a different edition I couldn't say.

No. Pages are only copied from the source database to the snapshot as they are changed (the pre-change information is copied). Reads from any pages that don't exist...

cjudge (4/1/2008)What you guys have to remember - and the above quote is perfect - is that the only reason you are managing the database is so that someone can...

Storage and collation are distinct - for storage purposes you already have what you need - the unicode types that allow you to store the Japanese character set. Collation...