thisisfutile (9/11/2012)

---

While I'm sure...

Bill Talada (9/10/2012)

---

Setting STATISTICS TIME & IO ON will cause severe slowdowns. I generally write each table as a separate SELECT in the FROM clause as above because it...

Bill Talada (9/10/2012)

---

Good article. I just want to present a style of coding that prevents this situation. I often work with queries involving a dozen tables. Notice...

First I would like to appologize if my choice of test data is throwing people off. The data and table layout was meant to be simple and easy to...

I wish I had thought of that when I was writing...

Great article Gail. Very well written and organized.

t_a_dunn (8/31/2012)

---

I tested this in SQL Server, which I think you would agree is the ultimate arbiter here. I executed each statement separately. In both cases, I received "Command(s) completed...

Just a guess but you might consider looking at your indexes. You probably have an index that covers CE.ID, CA.CustomerID and CA.PostalCode but doesn't include CA.EnglishAddressLine1.

I did...

I'll read that chapter this afternoon. The cluster is active/passive and both nodes are identical. So I can just set the instances for the one node and when...

By any chance is the first row the column headings? If not any chance it can be made to? If so there is a setting on the connection...

Thanks for the clarification Hugo. Now that you describe it becomes a lot clearer. Still a very interesting effect. I'm guessing that the parser checks for the...

Jonathan Marshall (8/27/2012)

---

I have an inquiry based on how SSIS handles mappings for a certain number of columns that increase in time.

A client has a file that started off...

Steve Jones - SSC Editor (8/27/2012)

---

This...

demonfox (8/27/2012)

---

nice question ;

one more observation :

-- t1(id int,data varchar(50)) ; t6 table doesn't exist

create procedure usp_testing

as

select a.id,a.testing from t1 a

inner join t6 b

on b.id = a.id

go

this doesn't...

It's not an "assumption", it was stated in the original question.

If allowed, he...