Jay is right - NVarchar will be double the size. For example you can have a varchar(8000) but you can only have a nvarchar(4000).

Create views for your Crystal Reports -...

well you have to be a member of sysadmin to run profiler. And I would think long and hard before I gave a developer that kind of authority.

So, no....

Thanks Randy - I was really stretching to figure out what that was.

Patrick

And after several visits with Europeans - Germans especially - I have a rule to never, ever try to out-drink them. Not going to happen.

Patrick

Laughing, ich haben kein problems mit der project managers.

With the cheerleaders, they are ok, as long as they listen when you have a problem. And they usually have very...

I've had problems with the machine falling asleep and not wanting to be bothered if I put more than 100 queries in the evaluation. 50 and 75 work quickly.

The evaluations...

I agree with Steve - ER/Studio. I have used it at two different jobs and it is my favorite tool for design.

I have tried ERwin also.

I have used Visio...

It depends also on what level the Project managers want to stay.

I have worked with several project managers who maintained this facade of not dealing with the day-to-day grind...

It's also a matter of what you are comfortable with.

I worked with Access for years, but my mentor did not use visual tools and I learned to hand code my...

That's a good point. It depends on what type of DBA you want to be. I have years of experience as a programmer before I became enlightened and became a...

I had luck with the Sybex, Microsoft, and Exam Cram books. I would read a chapter at a time and compare the information.

It's more important to understand the concepts than...

I am a big fan of the "deleted" flag. Not a big fan of anything that actually deletes the record.

I also will use the archive database - mark the...

I just had a meeting with two Oracle DBAs who pronounced char (to me Char) as car. I finally had to ask what "car" was. I thought it was some...

Sybex and Microsoft. The Microsoft presented much more information than was necessary - but the Sybex presented just the basics. I would read the chapter that deal with the same...

I agree - I also took your path. I took my first SQL test based mostly on studying Transcender. Not enough. I studied using two books and especially those pieces...