Amazing article ....... On similar lines please find another link :: http://blogs.msdn.com/craigfr/archive/2006/06/30/652639.aspx

Frankly I would enjoy learning but I would want to put that learning to use rather than slog myself at the donkey work ....

What I derived is:

functions can cause Row by row processing and also that would result in a table scan as for each row the function will have to be executed....

But why do u say so ????

According to me 🙂

1) Increased data i.e. numerous inserts

a) Due to increased amount of data processing the query...

Grant Fritchey (12/12/2007)

---

This is only useful within client applications that are returning larger result sets, but you want to get a row or three on the screen as soon as...

I am sorry ................. Missed it 🙁

http://furrukhbaig.wordpress.com/category/dmvs/

Hey .....................

Well this link is really useful it tells you about

1) Worst performing queries

2) Whether the index is useful or not

Just check it out .......

but please tell me why do i need to add a recompile hint ??? Cause if i understand right Recompile is added when i want the cached execution plan to...

I do understand what u guys said but if we do have isolation levels then why do i need locks? as in ... If i can accomplish the transaction integrity...

but my question being that UserID will get only one row as it is the primary key. In this case what advantage is FASTFIRSTROW?

hey jeff...

Can you post the link of the forum u mentioned about ?

And hey i did not quite get that 2 Applications thing .... Cause there were always be...

i don seem to get the answer ...can someone point me to an appropriate link where i can find concept behind the correct answer

your excel sheet column contains both text and numbers right

for example :

'ABCD'

'1234'

well the problem might be that : ... check what does the SSIS package take the datatype of...

i execute it as

Try

{

SQLCommand Comm = new SQLCommand ("exec StoredProc", connection)

Comm.executenonquery();

}

Catch

{

...