Eric M Russell (12/14/2011)

---

sqldba_newbie (12/12/2011)

---

I see huge performance difference on joining a #temp_table instead of @table_variable. Query runs way faster when i join on a #temp_table. Any idea what could...

Henry_Lee (12/13/2011)

---

Thanks for the suggestion. However, there's no option in their console for anything like that and no hint...

Dave Ballantyne (12/14/2011)

---

sqldba_newbie (12/13/2011)

May be, but that portion runs perfectly fine. Issue is really not there, i am sure there is better way to write that code but the real...

Leo.Miller (12/13/2011)

---

I may be wrong as I can't see your data, but it looks like this portion of your code always returns one row:

If @RId is not null and...

I have...

Converting function to sproc is not a viable solution , too many changes need to be done.

After reading this article , i have added "option (recompile)" to batch of sql...

Henry_Lee (12/13/2011)

---

I understand this thread is over a year old, but I thought I'd leave some more information for the next person...

I'm working through this issue right now. We purchased...

thanks . I am trying to tune this one query, unfortunately i wont be able to use #temp tables because this is a function, though just the query itself with...

Thanks.That would give me some idea but i think...

SpringTownDBA (12/10/2011)

---

Just to clarify what you're asking:

You have a database that you wish to have copies of on multiple other servers. These copies need to always be available for querying...

Surprisingly it ONLY happens for the database which has to...

Spid -3 happens after the crash. I am attaching the stack dump which occurs first and then...

thanks..i am not sure why is that happening, but the problem here i am trying to resolve is there is an ETL process which for some reason brings down the...

Totally my fault...got confused with those column name :-). Thanks again for...

GilaMonster (10/25/2011)

---

You're getting nulls because of the left join. If there's an index in sys.indexes and there's no row in sys.index_usage_stats (which will happen if the index has never been...