Convince whoever made that decision of the stupidity of using XML to move "large amounts of data."  Small messages are one thing, but the bloat of XML when transfering large...

I will just emphasize a point that Steve made.  I have seen several projects both internal and vendors that have attempted to "port" an application from FoxPro or DBase to...

You must login to the server using the SQL Server Service account, configure the MAPI client and then configure SQL Server to select that profile in Enterprise Manager by right...

Unfortunately, unless you had some sort of auditing application in place at the time the change was made there is only one way to find this out.  If your database...

The biggest con of clustering is cost.  You have to run SQL Server Enterprise Edition and have to use a SAN, both of which typically cost a bundle. 

The biggest...

Sure you can shrink tempdb.  You can use either the dbcc shrinkdatabase or the dbcc shrinkfile commands.  If this is a production instance, I would be careful about shrinking tempdb...

There are several reasons to store the file data in the database rather than just storing a link.

First and foremost is recoverability.  What mechanisim ensures that your filesystem and the...

I think this is highly unadvisable.  Linked Servers have their place, but they tend to be rather large security holes.  First off, you would have to use SQL authentication with...

To expand on what Chris said...  If your users are accessing the data through the internet you probably need to use the "Per Processor" license, this has nothing to do...

Since you are already able to connect to the other database and query it, all you should need to do is modify your source query to include the appropriate WHERE...

Thanks for correcting the XML, but since I don't claim to be an expert in XML (as I avoid it like the plague) I pulled that example right off of...

csv = comma seperated values.  Normally it denotes an ASCII file, but not always...

...as if XML were a universal data format, PLEASE!!!  Get real here.  Why does a data file format need to be universally agreed upon (as if XML were)?  First off...

See my post above...  Run Profiler to capture each statement run with its associated CPU and IO cost. 

Somebody is either screwing around with you or is inadvertantly doing this.  First thing I would do is to lock down SQL Server.  Eliminate any unused logins and users.  Very...