Statistics are the big thing, but it also depends on the size of the table. For example, if you have a table with 100 rows, it probably will just scan....

I'll say that I don't think that's appropriate. Denigrating an entire group is bigoted, and not necessary.

I agree with Gail. Work on one, then the other. No reason to do them together.

You're updating all rows, no reason to seek. Need to scan to hit all the rows.

Apologies, maybe a little patronizing. Nothing wrong with those jobs, but for the most part those aren't skilled jobs. Anyone can do them, and that's usually why the pay is...

You should be able to re-run setup and add in additional features.

If you have a database backup, that's good, but an uninstall won't mess up your mdf/ldf. You'll just have...

Yes, if you don't know what to do. Even if you have staff, hire someone for a couple days to examine the system and train someone on your staff.

I tend to agree with you that they need to research, but I can see both sides. There are plenty of people that don't "want" to learn SQL Server. They...

Good editorial. I'm not sure what I'd want fixed more, though I think partitioning for sure could use an easy way to manage it (and then generate the scripts).

I might...

It was more of an oversight. I woke up to find the site live and an email asking me to get something up.

I've added an announcement, and I expect that...

Nice post.

I heard someone speaking last week about iPhone development. Said the iPhone has the capabilities, though not the storage (yet) of the old G3s, which aren't that old!

Or maybe they've changed the rules now that Jeff isn't serving :-D:-P:w00t:

George,

Honestly, I'm not sure. I have some thoughts coming Monday, and I think we'll end up with either

A) a split audience, some choosing one format over the other

B) different...

I think it does count in interviews, you should bring it up.

You might be able to install the runtime for DTS on that edition (http://msdn.microsoft.com/en-us/library/ms143755.aspx)