Gail knows:

http://sqlinthewild.co.za/index.php/2010/09/14/one-wide-index-or-multiple-narrow-indexes/

Quite a lot of...

INSERT INTO #temp (item_code,variant_code)

SELECT DISTINCT T2.psp_item_no,T2.psp_item_var

FROM pmddb..pmd_mpsp_ps_postn T2

WHERE T2.psp_io_flag = 'i'

AND NOT EXISTS (

SELECT 1

FROM #temp AS T1

...

I think you're right, it should be the other way round.

I'm curious to read other opinions.

DISTINCT should do:

INSERT INTO #temp (item_code,variant_code)

SELECT DISTINCT T2.psp_item_no,T2.psp_item_var FROM pmddb..pmd_mpsp_ps_postn T2 WHERE T2.psp_io_flag = 'i'

Hope this helps

Gianluca

Looks like your cluster has already an IP Address resource and a Network Name resource.

If this is the case, delete the resources and let the setup create them.

EDIT: Wait a...

Confirmed!

This is what my in-laws do with my 2...

Lynn Pettis (6/4/2011)

---

Okay denizens of The Thread, I got a call yesterday evening from my oldest daughter that actually left me speechless.

I am going to be grandfather![/i]

Looks like I'll need...

This is a really smart...

You have to group your data on one or more columns:

;WITH SampleData

AS (

SELECT *

FROM (VALUES

(1, 'ABC11'),

(1, 'ABC12'),

(2, 'ABC11'),

(2, 'ABC12'),

(3, 'ABC11'),

(3, 'ABC12'),

(4, 'ABC11'),

(5, 'ABC11'),

(6, 'ABC11'),

(6, 'ABC12'),

(7, 'ABC12')

) AS InputData...

Lynn Pettis (6/3/2011)

---

Had a phone interview Thursday morning with Microsoft. It seemed to go pretty good. We'll know how good if the fly me up to Redmond for...

It should be an index with both fields in it. It should not matter which one first, especially when both tables have billions of rows, as it would probably end...

Something like this should do:

SELECT *

FROM EMP2

WHERE NOT EXISTS (

SELECT 1

FROM EMP1

WHERE EMP2.Name = EMP1.Name

...

You can use DATEPART to check the weekday:

select datepart(weekday , getdate())

Depending on your @@DATEFIRST setting, you will have to check for days 1 and 7 (default for US English) or...

Index rebuild recreates statistics with fullscan. When statistics are rebuilt, all dependant plans get invalidated.

I don't know what happens with index reorganize, but I suspect it doesn't rebuild stats.

Hope this...