I have learned to detest code that builds dynamic SQL by repeated concatenation, especially with char functions for line breaks and tabs.  A complex statement is difficult to read when...

The situations I've seen where one database can screw up a maintenance plan and affect other databases I think are covered by automatically removing databases from plans where they don't...

You can use this: 

ORDER

BY CASE Letter

        WHEN 'B' THEN 1

       ...

You need to break the insert into chunks.  Is there something in the view that could be used like a key (doesn't have to be unique), preferably a field that...

I think maintaining a separate plan for each database is overkill.  That would be way too much trouble to maintain IMHO.  I can't imagine having to juggle the scheduled time...

I have also seen inexplicable errors importing text files in DTS, and no amount of analyzing the file could find any strange characters or invalid EOL sequences.  Of course, the...

Is it a permission issue?  Does the login used by the Oracle connection have select permissions on the view?

Are the tables and views owned by the same user?

Maybe if I was getting paid like an Oracle DBA.

Read the first post again.  He said "Wait a year before CONSIDERING" using it in production.  Not deploying for a year may be the right answer in many cases, but only for...

Sheesh.  Where was the damn Internet when I was doing homework 30 years ago?

SQL Server is going to do disk I/O in 64K chunks.  Forget anything else you've read about NTFS, use 64K clusters.  And try to keep everything except SQL files off the...

I'm a DBA in a small organization that also has a system admin.  He's responsible for server hardware, operating systems, networks, and tape backups.  The job responsibilities are pretty clear, but...