When you create a view, an entry is made in the syscolumns table for each column in the view.  This is true even if you write the view with SELECT...

Why are you shrinking the database every month?  If it's just going to grow again, then stop shrinking it.  You are just forcing your users to wait for the database...

Is the indexed view even being considered?  Check the query plan (Ctrl+L in Query Analyzer) and look to see if the index in view is even being used.

Are you running...

When you took the position, how did you negotiate?  It may simply be that the other person asked for more.  Next time around, be ready to do so for yourself.

The...

If you're running this function many times, you may be taking a processor hit for the extra conversions in the second case evaluation.

Try:

CREATE FUNCTION...

For the heap tables, you can move them by creating a clustered index on them using the ON [new filegroup] option.  Once they're moved over, you're free to either drop...

Recreate the clustered index on the new filegroup.

-Eddie

Look up Partioned Views in BOL.  You'll wind up creating the separate tables to hold the different years (place them wherever you like, even on different servers).  The partitioning is...

Unicode is a character format, not an integer format.  SQL Server stores unicode character data using the nchar and nvarchar types.

Can you provide a few examples of what this data looks...

Ensure that MSDTC is properly configured as part of the cluster, right alongside MSSQL and SQLAgent.  It is necessary for distributed transactions.

-Eddie

Have you tried using an INSTEAD OF trigger instead of (the default) AFTER trigger?

  An INSTEAD OF trigger actually replaces the normal INSERT behavior, and it's up to you to...

Ditch COMPUTE, and use either CUBE or ROLLUP.

The reason it doesn't work outside of QA is that your results are not a single resultset.  Each time a compute result is...

Many MDI applications use Ctrl+Tab to switch windows.

Having never heard of your example as a 'standard', I fired up Word and Notepad to see what they did.  In both, Ctrl+Tab...

If you have the memory available, SQL Server defaults to row-level locks.  If you are locking a significant number of rows on a page, it will escalate the lock into...

The Refresh method simply reloads the list of tables into your DMO tables collection from the server.  It has no effect on the server or any object on it.

To see...