What about:

UPDATE

[Northwind].[dbo].[Orders]

SET [ShippedDate] = x.myshipdate

FROM (

What error are you getting? You can run a backup command from just about anywhere (a linked server isn't really necessary), but the real issue is usually one of disk...

Assuming a clustered index on the UniqueRowId (or a combination of the other columns used in the aggregate query), in a similar situation we've found that using TOP(1) with an...

You can store all those columns, but the question is, why would you need to? For example, I've done exactly what you're laying out because we found that all our...

Some of that information is available from sys.syslogins. I think the more dynamic stuff, like the number of logons, isn't going to be there. You may need to set up...

Pig Pile!

Seriously though, everyone got it right. Replication has the type of behavior you're looking for. It won't seriously impact your performance (configured correctly) and it's a lot more fault...

Very interesting stuff. Thanks for sharing. I'd love to know if you do find any kind of memory leak since, from a performance stand point you already proved that it...

Yeah, I've read a lot of that stuff. I was just wondering if anyone had come up with a compelling, real-world, example of using CLR and getting more or better...

Can you post the query plan as XML? It sounds like you might be missing an index which is why you're getting the work table in tempdb. Possibly in the...

I'm not entirely sure what you mean, but I think you you're looking for something along the lines the OPENROWSET command. Look it up in Books Online.

What about sys.server_principals & sys.server_role_members? You can also go to each database and look at sys.database_principals and sys.database_role_members on each database.

Hate to say this, but, it depends. There's no inherent advantage of a stored proc over a SQL statement. It's execution plan re-use that you're actually shooting for. However, Agent...

Crud. I should have read more closely. Good job. Man I feel stupid.

That is odd. Try running Profiler against the table as you do the work. Use the statement starting and statement completion events in addition to the normal ones. That way...

I don't know. I copied down all your code and walked through it. It's working fine. No issues. No errors. I was able to insert values using your script (with...