I don't think anyone knows. The guys over at MS are being...

There are three different ways that the query processor can implement joins, loop, merge, hash. They're each good in specific conditions. If you use a hint, you are forcing the...

If you're running SQL 2005 SP2 or higher, you should be able to do this with a logon trigger. Within the trigger you can check the user name and the...

I thought Vue had discontinued the MS exams a long time ago. Was that just outside of the US? Down here it's only prometric now.

Farhad: http://www.prometric.com You can find a...

How long is a piece of string?

Without a lot, lot more info, there's no way to say. I've had everything from...

Yup. I can see the problem.

Look over the example I posted above and look carefully at which variable have the _ and which don't. While I prefer the names more...

Are there any other queries running against table1? Inserts? Updates? Deletes?

select c.name, t.name from sys.columns c inner join sys.types t on c.user_type_id=t.user_type_id

Actually, you want to take a full backup after running this, as you are truncating the log and breaking the recovery chain. After running this you will not be able...

Please post table schema, index definitions and some of the more frequent queries

Talking about table optimisation in the abstract is difficult at best.

I would recommend that you don't and rather look at patching the server to SP2 at the...

Make sure they don't have any rights to the database. (and make sure they're not sysadmin)

I do hope you're taking a full backup afterwards, since you're also breaking your log chain doing this.

When you say "It's not working" What do you mean? Error? Not doing...

What did the xp_cmdshell return for him? I know it will work, I'm interested in what it shows when you try to do a DIR of the serverA.

What error are...

But if you put the database on each user's PC, then each user can only see their own information and not anything that anyone else adds/changes.

Is that what you...