rlortega (3/12/2014)

---

I guess a differentiation must be made in skills required for administration and skills required for development. We have 15 DBA's and twice that many developers. We are DBA's...

Greg Edwards-268690 (3/12/2014)

---

Although I will admit - Core skills, and 'Nice to Have - you will need these skills' - will drive a lot of debate at times.

Kind of like...

Neither do I Greg and that’s an excellent point you’ve made.

An article claiming to list the required skill set for a general-purpose TSQL developer, published here on ssc, absolutely...

Jeff Moden (3/11/2014)

---

@chrism-2,

I noticed that you've not written an article on this subject yet and thought I'd give you a nudge. I think the list you came up with...

curious_sqldba (3/11/2014)

---

ChrisM@Work (3/11/2014)

---

curious_sqldba (3/11/2014)

---

ChrisM@Work (3/11/2014)

---

curious_sqldba (3/11/2014)

---

sqlbuddy123 (3/10/2014)

---

MAXDOP =1 means disabling the parallelism. That's why SQL Server doesn't consider parallelizing the query.

That's why I couldn't see that in the execution plan...

curious_sqldba (3/7/2014)

---

I don't have any query hints being used, at server level i have MAXDOP = 5 and CTP = 1, in the exec plan i see that query is...

curious_sqldba (3/11/2014)

---

ChrisM@Work (3/11/2014)

---

curious_sqldba (3/11/2014)

---

Exactly,...

It does go around the houses a bit doesn't it. This is probably worth a try:

Start with a preaggregate

SELECT

a.AccountNumber,

s.StoreId3,

Distance = MIN(a.LocationPoint.STDistance(s.LocationPoint) / 1609.344)

FROM prod_Accuzip a

INNER Join StoreListMaster s ON (s.St...

curious_sqldba (3/11/2014)

---

Exactly, but my...

curious_sqldba (3/11/2014)

---

Exactly, but my...

You're welcome Geoff. Which part helped?

DROP table #CustIfno;

CREATE table #CustIfno (AccountNumber int, StoreID int, Distance decimal(14,10));

insert into #CustIfno values

('1','44','2.145223'), --

('1','45','4.567834'),

('1','46','8.4325654'),

('2','44','7.8754345'),

('2','45','1.54654323'), --

('2','46','11.5436543'),

('3','44','9.145223'),

('3','45','8.567834'), --

('3','46','17.4325654'),

('4','44','7.8754345'),

('4','45','1.54654323'), --

('4','46','11.5436543');

-- without index

WITH CTE AS (

SELECT AccountNumber,...

amy26 (3/6/2014)

---

I suppose of there was another way to loop through the original data structure by issue_num and find all instances where the column_value was all 0's or all -'s...

pharmkittie (3/6/2014)

---

Hello,

Is my question too general or do I have too much detail? If anyone could please tell me if there's something I could do to make my post...

SELECT issue_num

FROM (

SELECT issue_num, column_value

FROM mydata

GROUP BY issue_num, column_value

) d

GROUP BY issue_num

HAVING COUNT(*) =1

The code bit is trivial - this is one of many ways of getting the same result...