Phil

If it's zero already then it won't matter if you update it to zero, so this will work just as well:

UPDATE [Database].[schema].[Table]

SET column_name = 0

John

Since you're doing this all in one transaction, I don't think it'll make any difference what your recovery mode is.

The first part of your clustered index key is PocketPCID and...

Karthik

If you're working in the UK, you'll be paying your umbrella company fees in pounds. As I said, you shouldn't be paying more than about £100 per month. ...

Yes, there is. Don't use your command 2, but use the exact command that Andras and I both posted above. That should work for you... in seconds.

John

RESTORE DATABASE MyDB

WITH RECOVERY

John

It's difficult to understand what you're trying to do. Please will you post a sample of the results you're getting, and then show how they should look?

John

£480 per day is an excellent rate for a first-time contractor, so congratulations! £350 per month is a lot for an umbrella company to take, so take the time...

Alt-X? Ctrl-E? I wasn't aware of either - I use F5!

John

Please will you post DDL in the form of CREATE TABLE statements and sample data in the form of INSERT statements, together with the results you expect. How is...

But you can't divide into four filegroups anyway, since one of your tables is 39GB... unless you partition the table.

John

Yes, but you're not comparing like for like. You need to compare the code that Sergiy and I suggested against the code in your original post.

John

I'm sorry, but I still can't work out what you're trying to do. Please will you describe in words what your query should achieve?

Thanks

John

No, not unless you give us some more information. Please post DLL in the form of CREATE TABLE scripts, sample data in the form of INSERT scripts, a brief...

Then I think your original code should be OK. But check the execution plan to see whether it is using any index that you expect it to, and if...

So you're only testing for the NULLness of @Param1 and @Param2? That doesn't relate to the columns at all, and so you're either going to get all the rows...