Can you please share the calculation/query that is used by the Application to get the data from...

Read BOL and search on google....

Read these article for Index.

http://www.sqlservercentral.com/articles/Indexing/68439/

http://www.sqlservercentral.com/articles/Indexing/68563/

Can you post the table structure and sample date? Help us to help you.

Here are some things you can check:

1. Check the Folder property of loop, whether it is pointing to correct folder.

2. check the Files property and see whether it using the...

That is what I had thought. Thanks Gail for the conformation.

I don't think there is a way to prevent a sysAdmin to fire select statements. If there is one then I would also like to know.

The only way I would...

Encrypt the sensitive data and then store it. And decrypt while reading in application.

I have never faced any problem by calling procedures like this. You can use the same name.

Create procedure Estimate(

@Rows int

,@TableName varchar(32)

)

AS

select sum(length)* @Rows AS SizeInBytes

from sys.syscolumns

where id = object_id(@TableName)

But this code will give you the maximum size your row will occupy because it sums the size...

execute xp_cmdshell 'net stop sqlserveragent'

execute xp_cmdshell 'net start sqlserveragent'

Thanks Crosan for the article. It looks great.

We ran some tests last night and observed that the INSERTS take 3 time more the time compared to uncompressed table.

Yes! This looks better that reading the header. Thanks Mark!

use RESTORE HEADER command to automate.

You sure that you are using 2008.

Because in SSMS 2008 it gives an error if you type a table name that doesn't exists.

You can try WITH ROLLUP option with GROUP BY. But it will give you one extra row for each employee having the total hours.