If someone put 20 indexes on a heavily-updated table it would kill performance, but that doesn't mean all indexes should be avoided.  If every update kicked off a cascade of...

You can get SQL Server to do the translation for you.  Open the table as a query in Enterprise Manager and drop your old-style query into the SQL panel.  It...

I once showed up for a job interview where the development team showed me the scariest database diagram I had ever seen.  Suppressing the urge to run away, I asked...

SQL Enterprise edition with only 2GB of RAM?  You should at least be at 4GB, more if your hardware & OS support it.  You should have the log files on separate drives...

SQL 2005 manages memory more flexibly.  If your app has a lot of stored procs it may enlarge the procedure cache (at the expense of buffer pool) to keep more...

In the Dec 2005 updated Books Online, look for "diagrams [SQL Server], upgrading" in the index.

It says, "Database diagrams created on previous editions of SQL Server databases are upgraded automatically...

If you wanted to prove whether this conversion in taking place in the database or in the client software, use profiler to see exactly what is being inserted.

Another question is...

If you're seeing a question mark, my guess is that it is not just a code page issue.  The character is probably being converted either before insertion or on display. The euro character...

You could alias the original column to a different name in a derived table, then the 'Date' alias in the main select field list is unique.

select