the data presented formatted as select statements:

SELECT '805880' AS TC_EMPNO,'2012-05-20 22:41:00.000' AS DateTime,'IN' AS PunchType,'1' AS tc_type,'8831916' AS TC_ID UNION ALL

SELECT '805880','2012-05-21 07:15:00.000','OUT','11','8837290' UNION ALL

SELECT '805880','2012-05-21 22:46:00.000','IN','1','8850645' UNION ALL

SELECT '805880','2012-05-22...

it looks to me like the cursor is calling a stored procedure [STAT_LK.dbo.stat_v3] for each row;

to change this to a set base, wer would need to see the defintiino of...

still sound slike multiple roles are hitting the user;

i would test as that user and see what roles that login was in;

--see what windows roles the windows user belongs...

i think it has to do with applying the logs prior to teh database being marked as ready to use.

that for a big MDF/Small LDF, the restore just has...

PradeepVallabh (5/21/2012)

---

Thanks for your good explanation....I was just playing around without using include statement while creating a non clustered index(analysed the execution plan), it give's a RID Lookup for...

i just tested this on my dev server;

i'm just printing some of the data available, which you would do as an email, or logging to an audit table;

you can rollback...

I would say you want to take the "how do you eat an elephant" approach: one bite at a time.

1. Make sure the destination database is set to SIMPLE recovery...

PradeepVallabh (5/21/2012)

---

I am pretty new to resolving query performance issues, just bear with me...Why should i create an index with Include Columns(why can't i just say create a composite index...

because you are putting a function on thee column, SQL has to convert the WHOLE table to give you results.

with a TOP, it can shortcut and convert fewer values...

Yeah i thought something looked wrong, when he said it's returning 4 values;

ii had to double check myself and test scope identity to prove it returns one and only one...

had to look that one up! Thanks Eugene!

since it's just this one server,

could it be something like database mail is not emabled, even though you've created the profile?

it sounds like maybe you scripted the database mail settings...

• This reply was modified 7 years, 1 months ago by Lowell.
• This reply was modified 6 years, 8 months ago by Lowell.

that would work or not work depending on the data, right vinu?

if the data elements are consecutive numbers, but if they are not, i don't think you get the right...

MysteryJimbo (5/18/2012)

---

awe come on; whether SSIS or anything else, multiple files requires a...

I'll go all devils advocate on the SSIS guys and present a solution i put together for other posts that is all TSQL.

Thsi requires xp_cmdshell to get the list of...