Biggest piece of advice, don't do this. You really need to look at each index and decide if it needs to be created or not. The missing index...

Doesn't tell us what additional information was included in the event log regarding the error you got.

Yes, but what...

yogi123 (4/11/2013)

---

Lynn Pettis (4/11/2013)

---

autoexcrement (4/11/2013)

---

Sorry, I would like to help, but there are just too many things about all of this that don't make sense to me.

For example, why...

And what does the event log say regarding this?

autoexcrement (4/11/2013)

---

Sorry, I would like to help, but there are just too many things about all of this that don't make sense to me.

For example, why are you (seemingly)...

Compressing the clustered index compresses the table as it is the table.

sudhirnune (4/11/2013)

---

When we get the Following String as In put

-1 * [SAL] - [BON] - [COMM]

need to check for the Data from the Below Table.

Columns:

--------

SAL

COMM

Once you search through the...

This really makes one want to help, doesn't it.

Start with this and show us what you would do:

select name as DatabaseName from sys.databases where database_id > 4 and name not like '%SPoint';

TravisDBA (4/11/2013)

---

Any answer the man seem to give was not the right answer, so either the question was not plain enough up front or the man was playing games with...

Please read and follow the instructions regarding what to post and how to do it: http://www.sqlservercentral.com/articles/Best+Practices/61537/.

Sorry, but you just haven't provided enough information for anyone to really help.

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 table in...

curious_sqldba (4/11/2013)

---

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...

TravisDBA (4/11/2013)

---

Asking an obvious question and expecting a different type of answer. Just read what he posted.

"Describe how you would program an elevator.

I spent the good part of an...