A DTS is reading fields from a source database using a stored procedure. Before storing certain fields in the (different) destination database, they...
An existing DTS selects rows from various tables and outputs them to a CSV file. I need to use PGP (the command line version) to encrypt that output...
What's a good way to download five SQL Server 2005 databases from production to my laptop for development work with Visual Studio? Our application...
When monitoring the performance of our production SQL Server 2005 system, it's now running much better thanks to help from people here. Now that...
Here's our maintenance plan for a production database server. Hosting company backups: Full backup to tape each Sunday, diff backups to tape...
I'm reading about the fill factor setting in Sql Server 2005. Most sources recommend a setting of 80 to 90, depending on how the table is used....
Reviewing our databases, we find 31% of our indexes have index fragmentation above 30% and should be rebuilt. Yesterday, I found fragmentation of the...
If I take the first SQL example from Reorganizing and Rebuilding Indexes and try to execute it, it fails with this error: "Msg 102, Level 15, State...
I've inherited a production SQL Server 2000 database that was migrated to SQL Server 2005 by restoring backup tapes on the new server. Stored...
Separate names with a comma.
