durayakar (4/12/2013)

---

LEFT JOIN TBFe FEP -- 112357833

ON FEP.Fcde = V.Fcde

...

Lynn Pettis (4/11/2013)

---

And the reason you get a separate plan for the execution of the same procedure from different sessions is that the procedure is actually accessing a completely different...

ChrisM@Work (4/11/2013)

---

Lynn Pettis (4/10/2013)

---

I think I know why, the table #test are different tables when the stored procedure is run in different sessions. Therefore you will get separate plans...

Lynn Pettis (4/10/2013)

---

I think I know why, the table #test are different tables when the stored procedure is run in different sessions. Therefore you will get separate plans for...

Lynn Pettis (4/10/2013)

---

curious_sqldba (4/10/2013)

---

Lynn Pettis (4/10/2013)

---

curious_sqldba (4/10/2013)

---

I have been battling for weeks on this issue, i was able to resolve the issue but i don't the exact root cause. I...

Lynn Pettis (4/10/2013)

---

curious_sqldba (4/10/2013)

---

I have been battling for weeks on this issue, i was able to resolve the issue but i don't the exact root cause. I am posting complete...

dkschill (4/10/2013)

---

Just ran a reorg and it finished in less than second...tried the rebuild and it immediately created a backup on the master database. I will have to wait...

jayoub1 (4/4/2013)

---

04/04/2013

I am a newbe database admin and I have been tasked to run queries against multiple databases. Each server has an instance and each instance has 10 or...

dkschill (4/9/2013)

---

I will see if I can get a backup restored to another box, and see if the same issue shows up...and if it does then I will make adjustments...

ChrisM@Work (4/10/2013)

---

sqldba_newbie (4/9/2013)

---

In below query , in the exec plan i see nested loop join on TBFE table. This is executed for 25,000 times. I could force a hash join...

Lynn Pettis (4/9/2013)

---

To really help, read the second article I reference below in my signature block regarding asking for help on performance issues. Follow the instructions in that article...

I didn't specify any query hints

GilaMonster (3/29/2013)

---

sqldba_newbie (3/29/2013)

---

I can see that every time it is creating a new execution plan. I took the stored procedure ,opened two sessions in ssms and executed the sproc. I...

DBA_Dom (3/29/2013)

---

Can you provide some more information about what your procedures are doing. Code would be helpful. Are you using dynamic SQL? What is the Server Advance setting for Optimize...

yup, if i multiple number of executions with actual number of rows it...