Can you elaborate a bit further?

Do you mean what tasks are avialable in SQL Server Integration Services (SSIS)?

Table is to small for it to be reorganized, typically anything less than 1000 pages should be excluded from rebuilds/reorganizations.

ramachandran narayanan (9/24/2012)

---

Dear Sir,

I have a query

there is only one field 'datetime' in the table.I have to calculate shifts ,intime and outtime is needed.

how to calculate intime and outtime?

Thanks and...

ReportServer is the webservice side of the application, you shouldnt point users to that address unless they use Chrome or Safari as that is the only way I know of...

Please do not cross post.

Replies here please http://www.sqlservercentral.com/Forums/Topic1363325-391-1.aspx

In that case there must only be that one login on the server.

Can you attach a screen shot of the security --> logins area in Enterprise Manager.

If the indicator is embedded inside the table then you dont need the "DataSet" tags as the tablix takes care of which data set to use.

=SWITCH

(

Fields!Expr2.Value = 0, 0,

Fields!Value.Value >=...

Yes you will be able to recover to a point in time.

I would strongly recommend moving into the old way that your used to in creating seperate files for each...

Yep, it looks like you can rule reports out of the offending TempDB growth then based on that information.

Are you embedding the indicator inside a table as a column object like I did in my sample report?

Only thing I can suggest is to attach the RDL file along with some sample data and I will give it a go here.

Unsure, looks right, only thing I can think of is to enclose the last two in brackets, so the division is done before the evaluation

=SWITCH

(

(Fields!Expr2.Value, "DataSet1") = 0, 0,

(Fields!Value.Value, "DataSet1")...

Thats why I asked if there will only ever be two rows in the table on the first post.

If you have more than 1 set of values in the table,...

Take a look at Ola Hallengren's maintenance scripts (link in my signature) some great maintenance scripts on there including a good index rebuild script.

Even though the SSRS databases maybe on another server it could still be them causing the TempDB issue, especially if the reports use excessive sorting or #temp tables.

You can query...