Grant,

As a side note, can you please let me know how to find the tables actually involved in the execution plan so that I can filter the unused ones. Do...

Chris\ Grant,

Thanks a lot for replying. I agree with you without any reservation. I know that the plan is not coming good due to complex view involved in it. I...

ChrisM@Work (1/29/2013)

---

Take away the unnecessary tables and use variables in the exact same...

You are the man! Thanks Anthony:-)

Chandan

Although I am late to this thread but would like to share my thoughts.

VM snapshots does cause issues in replication which is nothing but some latency. However, after reading your...

I had this issue and found that the database had 'autoclose' option enabled and while trying to open that database it messed up with some system process and got killed....

Thanks NGreene. Will try that very soon and post the results of execution times.

Wish you and your family a very happy new year!!!

Regards

Chandan Jha

Due to year end vacations, things have slowed down a bit. You can watch this thread as I...

ngreene (12/28/2012)

---

If the primary key is an identity and its the clustered index, you could loop through and update records 1 at a time. Each update the where clause...

Yes:-) When I am dealing with fully logged situation, it goes very very low. Reason could be my I\O storage where log file is kept which unfortunately cannot be changed....

Koen Verbeeck (12/27/2012)

---

There are several options:

* recreating the table like you did before, but not with SELECT INTO, and using the simple recovery model.

* updating the table in batches: do...

komal145 (12/7/2012)

---

I know , it's kind of DBA questions and they are excepting the Developer to answer it and I am a Newbie to SQL server ,and never faced such...

This thread looks quite old. Can you open a new question and post it here. That way it will be...

Perry,

Thanks for replying.

The server uses VMWare and the sysadmin wrote the following to me:

'All of these drives are situated on the same set volume on the NetApp'.

He also wrote that...

I agree with MysteryJimbo that if the procedure has been caught doing nasty things time to time, we may add recompile option on the procedure level rather than running dbcc...