Joseph -

One last thought on this one - MOST functions that might be performed by the DBA or by SQL Server itself in the course of normal activity (e.g. scheduled...

I'll probably catch some flak on this answer but here goes:

To be honest, your DBA does not need to be a local admin on the machine in question assuming that...

Phil's "very large database" are a great example of why compression products like SQL Safe, SQL Backup & Litespeed are usually a great addition to your toolset - they will usually...

I think you've missed the latter half of the equation, which is that SQL Server must also have a corresponding I/O path (e.g. raid array or HBA) to really take...

Robert -

Wow!  Talk about an open ended question.  In order to provide any help at all we would need a lot more information about the structure of your database and...

Reem -

It sounds like the one thing we're missing is that you need to recover the lost data?

If yes, I would restore the database from the latest backup before you...

Probably the single most important difference between disk & tape backup is the time to restore.  Tape backups take "forever" compared to a restore from disk - and that's if...

Don't forget service pack/patches on operating system and SQL Server, just as importantly don't go "too far" on SQL Server service packs prior to moving databases around.

Joe

Got to be the differences between "contexts" while running on an Windows 2003 x64 64-bit instance of SQL Server 2005.  The core database engine is entirely 64-bit but things like...

One unanticipated effect of a dbcc reindex is that you can expect that all of the tables in your database with a clustered index will have to be sorted, you...

James -

Per the documentation, you can only have one resultset per stored procedure... you can have multiple datasets that utilize the same procedure (if you really want to you could...

Brandon -

See http://www.microsoft.com/sql/prodinfo/features/compare-features.mspx, workgroup edition does not support http endpoints.

Joe

Jai -

Just search for "SFTP client" or "SFTP server" on google... basically SFTP is an upgrade of FTP to include encryption of the connection between the client and server -...

Use the vbCRLF rather than the char(10) + char(13) combination - the char(10) + char(13) works great in the designer but doesn't render correctly when published to reporting services...

Joe

Matt -

See the section Accessing External Resources of http://msdn2.microsoft.com/de-de/library/ms345101.aspx.

If you are running using a SQL Server login you're going to get stomped by SQL Server when you try to access...