i believe the best solution will be of using the an archived folder where u can move the processed files. (use file system task 🙂 )

u may first check if there is any Windows server level backup jobs running>??

like,, BackupExec

well,,,, in your source ,u may check whether u are able to pick all the records that are provided in ur Data source.

if using transformation, then u may test if...

CONVERT function will help u in this.(different styling).

a learning for today...!!!

very good question 🙂

well i guess,,,,,, SSIS package (Data Flow task ) may help you in this.

IF,Number of columns in your excel files are going to be fix.....Then u can pump "N" number...

well your answer lies in the logical execution of your query.

The sql executes query in this order.

1. FROM

2. ON

3. OUTER

4. WHERE

5. GROUP BY

6. CUBE | ROLLUP

7. HAVING

8. SELECT

9. DISTINCT

10 ORDER...

u may try in any...

kindly first go through this: http://www.sqlservercentral.com/articles/Best+Practices/61537/

Steven.Howes (9/26/2013)

---

The only one I can even think of is Crystal reports, but I haven't used it in over 5 years. I'll agree, sometimes SSRS performance just sucks and...

nice question,,,, learned something.

what i believe that u r asking something like this,

that transaction that is inserting these huge records has not been committed yet.

and in the mean time You run your Select...

well, almost all the sql masters have answered the questions.

a simple group by and having count will serve the purpose.

100% Possible.

but should have the adequate permissions.

need table structure and some sample data.

and Most. Imp. Your Query...!!! 🙂