The default database set up for your login is not working. Before clicking "Connect", choose a database like master in the options tab.

Keep in mind that it's not the size of the db, it's the load, the number of transactions. Look at your log backup sizes and see if the bandwidth between...

top of the hill would be nice, edge of the gully better. Unfortunately some seem resistant to that training. Like in business, some are happy to drop where they eat...

First I'd be consistent with != and . Choose one.

Second, why the right join? Why not an inner join on the update? I suspect the problem is there, but I'm...

What are the data types? Is this 1 row only with 607 for Col4?

Perhaps a bad installation of it. I haven't seen this to be a problem on other machines.

It's not likely anyone uses this, but it's a valid extension of the operators. You might want two of them (or 3) for some reason, but you typically wouldn't use...

I'd double check indexes as well. I've seen people assuming they're the same when they aren't.

Hugo,

As always, thanks for catching the mistake. I have clarified the question.

It is a deprecated feature, but there are plenty of 2000 instances out there and I wouldn't be surprised...

The humor questions always have a disproportionate number of points. They're fun, and hopefully everyone gets them right so it doesn't matter.

13 being a bad luck, spooky kind of number...

you can still use the scripting or the T-SQL, but do it in an SSIS package.

You use BIDS to create a package, add a T-SQL task, and include your T-SQL...

SQL just doesn't work well with large strings. I'd suggest that you take another look at what you're doing.

Perhaps post what you're trying to accomplish with this string and we...

I'm not sure it's a cliff jumping, and our OP feels her thread was a little hijacked.

Please debate this elsewhere. Although it's a good debate, it appears the question was...

I favor the offline approach, but you're likely to upset some people. Instead, if you suspect something isn't being touched, set it to autoclose. It will close, but more importantly,...

You likely have subscribers not picking up the updates, which is why the distributor is so large.

Replication Monitor should help you determine where the holdups are.