the data doesnt have those brackets, I put them in to see if the spaces were still there or not.. as you can it tells me that there are spaced...

What tool do you presently use for DB schema comparison?

Yes, a whole lot of blocking. Blocking causes our web applications to stop connecting with the DB inturn causing the website to go down. I had to stop my procedures...

Sorry guys for the delayed response but I've been trying to figure this out. The query seems to be very unpredictable even with the indexes on their. I even purge...

I havent done that Grant...let me try that.

Slick84 (10/15/2009)

---

Weitzera,

Thanks for the input. You definately are making sense and yes the requirement you described is how I want it. I'm basically inserting records from tblRegularItems into tblProductSizeWidthColor which...

I'm not sure how I could implement the inner join when I'm only looking for items which are available in my table on the left or my first table compared...

Weitzera,

Thanks for the input. You definately are making sense and yes the requirement you described is how I want it. I'm basically inserting records from tblRegularItems into tblProductSizeWidthColor which do...

It runs almost instantly.. However, I have the same environment setup on my QA server (I did what you advised on our Staging environment) and the query has been running...

Okay Gail, here is my execution plan after making the above changes. Unique non-clustered index on fstrShortsku and EDPno included in index for tblRegularItems.

I also noticed that when my SELECT...

Got it. fintProductId is the primary key of table product and the clustered index. I will go ahead and create a non-clustered index on tblProduct for the fstrShortSku column.

Also,...

Hi Gail,

Here is the DDL for the view VwRegularItems which I previously posted as well. I havent changed anything on it from before.

CREATE VIEW [dbo].[vwRegularItems]

AS

SELECT Item_Id,

...

WOWWWWWWWWWWWWW! Thanks so much Gilamonster. It's unbelievable. I got my results back in 5 seconds....amazing...execution plan attached. :-D:-D:-D:-D

Wow thanks for the detailed information! Let me implement this and run the procedure again and upload the exec plan. Im creating non-unique non-clustered indexes on those, right?

By the way.....

So another question, and please let me know if I'm asking too much or just point me to the right direction but...

Would you be able to explain what the wide...