Calvin:

> I don't want to restore from last night backup.

  Unfortunately, that's what you have to do.  When restoring the log backups, use the STOPAT switch and specify a...

ActiveX and COM are pre-.Net and pre-SQL 2005.  "ActiveX" with SQL Server 2000 only showed up in DTS.  You could instantiate and manipulate COM objects with sp_OA procs.  But all that...

> Since the only duplicate field is the join field, and I really only want to have that field show up once in the result set, is there some way...

Do not use Enterprise Manager for important tasks.

The command to shrink files is DBCC SHRINKFILE(fileid, newsize).

Take a look in BOL for more info.  You can get the fileid from the...

The number of transaction log files does not matter to a transaction log backup.  Just run your job like you would if there were only one file.

-Eddie

SELECT COUNT(*) AS MainCount, 

       Sum(CASE WHEN A.InspectionUID LIKE '00076_0000001481'

                THEN 1 ELSE 0 END) AS SubCount

  FROM tbl_NSP_QuestionTree AS Q LEFT OUTER JOIN

       tbl_NSP_Answer AS A...

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...