The MOVE clause needs to refer to the logical filename, not the physical file name.  If you don't know what the logical filename is you can execute sp_helpdb 'FuseTalk' on...

Truncating and shrinking the log file ARE related, but they are not the same thing. 

I thought the problem was that the log was getting too large after the nightly...

The culprit is the nightly reindexing job.  Reindexing is a logged operation and will cause your t-log to grow. 

Also don't confuse log truncation with file shrinking operations.  They are not...

Very useful script, but there is one thing that should be changed.  As it is you are using the Host_Name() function to populate the ServerName column.  Host_Name() returns the name of...

Assuming you have the dbase ODBC drivers installed you can setup a system DSN that points to you dbase file(s).  Then configure the linked server to use the Microsoft OLE...

There are several methods you could use depending on what your requirements are.  Since you are talking about resumes, as opposed to applications, there is no predetermined format with a known...

I guess I was wrong about the lack of debate.  I must say I disagree somewhat with Steve's recommendation to purchase a server with more CPU capacity than you will use. ...

2GB is the limit for Standard Edition.  All the talk about AWE and the 3Gb  switch applies to Enterprise Edition.  Here is the official MS reference on the matter:

http://www.microsoft.com/sql/techinfo/planning/SQLReskChooseEd.asp

I don't think you'll get much debate on the subject.  If you need to stay with 32bit go with the latest Xeon CPU.  

If, as you indicate, you are going...

Generally a good article, but the author fell prey to one of the most common errors about clustered indexes.  He states:

"Do not try to place a clustered index on...

We started developing a system along these lines of thought about a year ago, and despite my dislike of XML I initially thought that it might actually work?!?!?! 

Sure enough...

Is the service set up to run under a user account?  If so, has the password been changed or the user deleted from the domain?

I think you meant DTC...?

How about "Does the column make sense logically?"  i.e. will the column take my BCNF table(s) and turn them into an unnormalized mess of redundancy and inconsistency? 

This, of course, assumes...

Unfortunately, MS has not provided us, the DBA's, a good way of actually seeing what SQL is actually being executed by sp_execute.  This makes troubleshooting and optimization very difficult at...