It depends. Do you have any sort of Replication going on? Then the logreader agent will be marking transactions when they are moved to the distribution database.

The main...

I usually make use of the FileProperty function. It has served me pretty well.

select fileproperty(name, 'SpaceUsed')/128, size/128

from sys.database_files

Feel free to group by data_space_id, or file_id, if your backups go...

Estimates are fine and well, but have the report designer demonstrate how much of a gain it is. My guess is as yours, that this will not add up...

Perry. Out of curiosity, does the command line utility work across versions of Windows? Right now (and for a few more fiscal months), I have Windows 7 on...

To bring a SQL Server service offline in a clustered environment, you would just have to go to Failover Cluster Manager, find the application group you want to shut down,...

It is likely there are not many pages in the index. Personally, I do not even consider re-indexing, until there are at least 100 pages in an object.

alter table switch partition effectively updates the metadata to switch the definitions of the partition and the table. You can truncate the dummy table after the switch, and have...

You could switch out the partition with an empty table (I forget the command offhand), then truncate the swapped out table.

edit: I think it is ALTER TABLE SWITCH PARTITION.

If there was a permissions error, it should return an error. However, errors can be caught. What kind of error handling is in the package, where are they...

Is there anything in the configuration of the job that runs depending on the logged in user? The only difference so far has been the Agent account running the...

Could the job be configured to exit and report success on failure?

Well, you can use Profiler to set up the events and filters you want to monitor. I would suggest:

Stored Procedures -> RPC:Completed

TSQL -> SQL:BatchCompleted

You may want others, so play...

Those numbers (like all of the CPU and I/O numbers in the output of sp_who2) are cumulative for the life of the instance. They only matter if they are...

If the database is online, and accessible to the users, I would say this is not a problem. The various system processes do what they do with really no...

There should be log files in C:\Program Files\Microsoft SQL Server\100\SetupBootstrap (You may need to adjust the version number from 100 to 105 for R2, if that is the case)....