CELKO (5/15/2012)

---

Please post DDL, so that people do not have to guess what the keys, constraints, Declarative Referential Integrity, data types, etc. in your schema are. If you know how,...

Initially I was always fascinated by table variables till I found some problems. When I started my new job 2 years back, I was given the task first up to...

Michael Valentine Jones (5/15/2012)

---

chandan_jha18 (5/15/2012)

---

Hi,

I had a procedure where there was a condition in where clause:

where ISNULL(d.[RejectReason], 0) IN (240,241,300,301)

The column RejectReason is int,null.

After going through several posts in this...

Lynn Pettis (5/14/2012)

---

Tim Walker. (5/13/2012)

---

I'm really sorry that my first post on this thread, which related to the lack of information from the OP, resulted in the thread going totally...

michael vessey (5/14/2012)

---

i think this should give the same results and be quicker

but without data i can't prove it

LEFT OUTER JOIN

(SELECT DsSupcode,DsLocationCode,TerminalNumber,MIN(recid) as recidmin FROM MOC_DT.dbo.TCN_Xref

WHERE

AND (group by...

Grant Fritchey (5/14/2012)

---

You've got multiple full scans running on millions of rows. Until you make the query filter that data, performance is going to stink and there's almost nothing you...

drew.allen (5/11/2012)

---

I still don't see any sample data. It's hard to rewrite your view if we don't have data to compare the original results with the revised results.

Also, please...

drew.allen (5/10/2012)

---

You've been around long enough that you should know that we're going to ask for DDL, sample data, and the actual execution plan.

I think that part of the problem...

Dear Riya,

I saw a lot of posts and questions asked by you without much information and when you reply back, they read as if you just want people to email...

glad to hear that. What was the issue you were facing and how this post solved your problem. We would liek to hear it so...

And here is the query without the view(but same where filters) and its actual plan. this works in 2-3 seconds. I am surprised and not able to find answers. I...

I am posting 3 items here. The query which takes 100 seconds, the view definition which is being used and the query plan...

Ok. Now a new twist in the tale. I forgot the view and coiped its definition of select command which displays so many columns and applied the proper where filters...

Thanks for you reply. If this is true, then it is going to kick my a** for ages because the select list in the view definition has around 20-25 columns...

Thanks. I will go through this article again, but can you read rest of my question about processors on the VM and clear some doubts.

Thanks Monster!