ps_vbdev (6/30/2014)

---

Thanks Koen

I was actual reading about these but was not sure if i was on the correct path. In my case would i have a product dimension of granularity...

1. Yes, 1,9M rows is quite a lot for a dimension table (especially if you are going tenfold in the US). If you are going to use SCD type 2,...

Replace the NOT IN with a LEFT OUTER JOIN and filter on NULL values.

kapil_kk (6/30/2014)

---

Does it make any impact if I used SET...

OK, so why don't you?

What's the problem? Performance? Try replacing the NOT IN with NOT EXISTS.

edit: any special reason the query is full with "WITH (NOLOCK)"?

It works fine here.

CREATE PROC dbo.MyTestProc AS

SELECT 1 AS Test;

GO

DECLARE @cnt INT;

EXEC dbo.MyTestProc;

SET @cnt = @@ROWCOUNT;

SELECT @cnt;

EdVassie (6/30/2014)

---

If you are certain that there...

Depends on the age of the person that asks.

From old to young(er):

* something with computers

* something with databases

* reporting on top of databases

* business intelligence (data manipulation and visualization if...

What does the stored procedure do? Insert, update, delete, select?

EdVassie (6/30/2014)

---

If you can be certain that you will only ever have one SQL instance on your Windows cluster then it can be safe to cluster SSIS in the way...

Interesting question, thanks.

Lynn Pettis (6/29/2014)

---

Koen Verbeeck (6/29/2014)

---

Lynn Pettis (6/28/2014)

---

It is scary how people manage to get into working with databases and then expect others to bail them out when they are in...

Lynn Pettis (6/28/2014)

---

It is scary how people manage to get into working with databases and then expect others to bail them out when they are in over their head.

And the...

Evil Kraig F (6/27/2014)

---

Eirikur Eiriksson (6/27/2014)

---

The Dixie Flatline (6/27/2014)

---

Grant Fritchey (6/27/2014)

---

Koen Verbeeck (6/27/2014)

---

Grant Fritchey (6/27/2014)

---

Anyone think they can help this person? I think they really need it, and what's more,...