Frank, yes, continuous certification. Laughing. Now that is a scary thought.

I don't know that the certifications are a must-have. I have heard from recruiters that the MCSE, while it...

Ok. "Be wary quiet, I'm hunting wabbits."

Upsizing Access to SQL Server does give you some advantages, but there are costs.

The two-tier approach would probably be the easiest...

This could be related to virtual logs and logical logs. Just a guess. Virtual logs that hold part of the logical log cannot be freed. If all the virtual...

Normalization is used to reduce redundancy in the database. Redundancy is when the same information is kept in several different places in the same database. The problem is that...

What happens if you close this connection manager?

I evaluatated an earlier version and it was annoying but after I closed it (and ignored it) the application was great.

Dr. Peter...

It may be slow because it is writing everything to a log. What type of recovery do you have on this?

I had luck with doing a full backup and...

Why end up with a database for each business unit? That seems to be your strategy. Is there not any information that they would share? Address? Customers?

Making it...

If the order of the columns meant anything you could create a view and use that instead of the base table. Then you could re-arrange the view columns any...

It's a good magazine. I used to buy each issue (and I have stacks of them at home), but I realized that I didn't refer back to the articles...

noeld, I did not say that they already had SQL 7; I said that as a consultant I would not recommend that they BUY SQL 7.

And, no, if the...

Basically they are pulling them off the market. Microsoft is supporting them, just not selling them.

That's their perogative. With Yukon on the horizon, .NET being available for a year,...

One of the first lessons from my mentor was to answer "No." to any question.

Seriously, Oracle guys are more protective and I understand that. I've worked on several...

The wonderful thing about standards is that everyone has different ones.

I'm glad that we are not forced to use them.

Dr. Peter Venkman: Generally you don't see that kind...

Yes, the posts are great. I usually check at least once a day to see what Frank is up to.

Dr. Peter Venkman: Generally you don't see that kind of...

Are you updating this table constantly?

Does it use the same index for both Count statements?

You might try DBCC dbreindex.

Dr. Peter Venkman: Generally you don't see that kind of...