how do you know that?

i am using 2008r2

you don't really need to 'write' it anywhere.

steps would be

1. delete your existing format expression

2. click on your report in design mode

3. press F4 to bring up report properties

4. Under...

I assume that you are trying to put the numbers into the Indian number format of ##,##,###.##

Rather than create your own custom format for this you can change the language...

you can do this with SSIS, setup a flat file connection to the logs and then send the data to a database.

However an easier and possibly better way would be...

Well it is Non-Sargable

http://www.sql-server-performance.com/tips/t_sql_where_p2.aspx

so performance would not be optimal.

Why don't you try both ways and then compare the execution plan?

did you restore master from a backup of the db server you are working on? or is it a backup from another server?

That advice has been floating around for a while and is really only applicable when you have identified bottlenecks in the tempdb.

some good advice about this here

http://www.sqlskills.com/BLOGS/PAUL/post/A-SQL-Server-DBA-myth-a-day-(1230)-tempdb-should-always-have-one-data-file-per-processor-core.aspx

you should include your question in the body of your post not the heading.

To do this query you should have a look at ROW_NUMBER

It depends on how you are doing the inserts into the warehouse system. If you are using SSIS as suggested then could put all the insert data flows into...

It will be up to your 'special program' to guarantee Atomicity in the ETL process, it will need to have logic in it to roll-back incase a load fails.

You also have to be careful running this statement without knowing what data could possibly be lost

Where did you get this from?, it does not say this...

I don't have any jobs going sorry, but it might help your search if you let people know what country / area / city you are looking for...

Is there any other large amount of activity on the database between those times like a SSIS Data load?

have a read of

http://support.microsoft.com/kb/307487#6

to shrink the tempDb without restarting the server you need to have no activity occuring on it.