You can view the execution plan in SSMS for the query and see the order in which things are applied. The short answer is "it depends". The optimizer will consider...

I'd like to think that MS has credited their code where needed, but that's a good point. They used to give credit to the BSD TCP stack, which was used...

I'll take a look at see what happened.

Is that more than 16 data files? Or is it with log files?

sp_attach_db has hardcoded 16 file limit because of the parameters. Look at the code. If you're doing more...

Thanks for the note.

We have asked that people whitelist, which should help. Not sure what else we can do here. The newsletter is fairly simple, though my editorials ramble...

There is no global public role. There's only a public role in each database and you can't remove that role. I wouldn't think any system functions relied on that, but...

Hey, thanks for the chemistry notes.

I think I'll volunteer to help calibrate the breathalyzers around here. Bring them to my house between 6 and 7 on Fri and Sat. I'll...

Lobbying successful. Points awarded back and I agree this was poorly worded.

Try adding two SQL steps in the DTS package.

First: drop table with the name for the first.

Then do a create table, you can get the SQL from the transform...

It is open to anyone, but really geared for people in MCS or MS Partners that can bill it out.

It's so new as well, I'm not sure there's a value....

Sorry, forgot that was for log space only.

One thing you could do is track the space in tempdb using a proc and either store it in an admin table somewhere,...

Please post in the appropriate forum for your version. Moved to ss2k5 as a guess.

Is there something in the error log? Was a maintenance plan run that looked to repair...

I heard this was an Antigen issue that is fixed in SP1. Why it started yesterday, no idea.

I'll check on the RFC compliance. I thought we were. If you have...

Great debate and good to see everyone fired up. Wasn't sure if anyone would like this one 🙂

We all have our own perspective and I'm sure some people conjure up...

As Matt mentioned, there isn't a good way to do this in SQL 2000. There are some complicated queries, but they often don't perform well. A temp table can work...