rs80 (10/14/2015)

---

In order to improve readability and performance, can I simplify the query below to a set based query?

DECLARE @ProductCodes TABLE(ProductCode nvarchar(3), IsProcessed bit DEFAULT 0)

INSERT INTO @ProductCodes(ProductCode) VALUES('ABC')

INSERT INTO...

Ed Wagner (10/14/2015)

---

ChrisM@Work (10/14/2015)

---

Alvin Ramard (10/14/2015)

---

An important difference between cats and dogs is how they react when punished.

Punish a dog for doing something bad and it thinks: "I'd better not...

Alvin Ramard (10/14/2015)

---

An important difference between cats and dogs is how they react when punished.

Punish a dog for doing something bad and it thinks: "I'd better not do that again."

Punish...

Perhaps she has a...

Brandie Tarvin (10/14/2015)

---

A couple of my cats play fetch. The toy mouse (or feather on a string) gets dropped in front of my feet and I know it's time to...

Sean Lange (10/13/2015)

---

Grant Fritchey (10/13/2015)

---

Brandie Tarvin (10/13/2015)

---

Now she's hissing at me because I made the mistake of trying to move my other...

Eirikur Eiriksson (10/8/2015)

---

dwain.c (10/1/2015)

---

Eirikur Eiriksson (10/1/2015)

---

ChrisM@Work (10/1/2015)

---

Eirikur Eiriksson (10/1/2015)

---

ChrisM@Work (10/1/2015)

---

Eirikur Eiriksson (10/1/2015)

---

ChrisM@Work (10/1/2015)

---

Eirikur Eiriksson (10/1/2015)

---

ChrisM@Work (10/1/2015)

---

Eirikur Eiriksson (10/1/2015)

---

ChrisM@Work (10/1/2015)

---

Eirikur Eiriksson (10/1/2015)

---

This made me spill...

sushil_dwid (10/12/2015)

---

Performance issue on Query. Here is query which i ran and it takes around 7-8 min to give the output. Could you please suggest the alternate way to write...

ChrisM@Work (10/9/2015)

---

That's enforced by a UNIQUE index, so it's the same as we...

That's enforced by a UNIQUE index, so it's the same as we have...

rchantler (10/9/2015)

---

Yes, there are at least 2 questions - 1. why the poor performance with adding a UNIQUE constraint and 2. why does switching from left join to inner join...

ChrisM@Work (10/9/2015)

---

SQL_Surfer (10/8/2015)

---

I have two tables. Table A has 2162 rows and table B has 101 rows. There isn't any join keys that I can join on these two tables....

SQL_Surfer (10/8/2015)

---

I have two tables. Table A has 2162 rows and table B has 101 rows. There isn't any join keys that I can join on these two tables. But...

Kim Crosser (10/8/2015)

---

Kristen-173977 (9/29/2015)

---

That is not declared as UNIQUE, so not quite the same thing as a PRIMARY KEY's Clustered Index (SQL will add...

Greg Edwards-268690 (10/8/2015)

---

NOT EXISTS, from what I understand, is a simple Boolean check.

Aggregates must first gather all results.

I am not at all surprised it is generally faster.

Many times I found...