Viewing 15 posts - 3,541 through 3,555 (of 10,143 total)
Greg Edwards-268690 (3/12/2014)
Kind of like...
For fast, accurate and documented assistance in answering your questions, please read this article.
Understanding and using APPLY, (I) and (II) Paul White
Hidden RBAR: Triangular Joins / The "Numbers" or "Tally" Table: What it is and how it replaces a loop Jeff Moden
March 12, 2014 at 8:18 am
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...
For fast, accurate and documented assistance in answering your questions, please read this article.
Understanding and using APPLY, (I) and (II) Paul White
Hidden RBAR: Triangular Joins / The "Numbers" or "Tally" Table: What it is and how it replaces a loop Jeff Moden
March 12, 2014 at 7:30 am
Jeff Moden (3/11/2014)
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...
For fast, accurate and documented assistance in answering your questions, please read this article.
Understanding and using APPLY, (I) and (II) Paul White
Hidden RBAR: Triangular Joins / The "Numbers" or "Tally" Table: What it is and how it replaces a loop Jeff Moden
March 12, 2014 at 2:47 am
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)
That's why I couldn't see that in the execution plan...
For fast, accurate and documented assistance in answering your questions, please read this article.
Understanding and using APPLY, (I) and (II) Paul White
Hidden RBAR: Triangular Joins / The "Numbers" or "Tally" Table: What it is and how it replaces a loop Jeff Moden
March 11, 2014 at 9:26 am
curious_sqldba (3/7/2014)
For fast, accurate and documented assistance in answering your questions, please read this article.
Understanding and using APPLY, (I) and (II) Paul White
Hidden RBAR: Triangular Joins / The "Numbers" or "Tally" Table: What it is and how it replaces a loop Jeff Moden
March 11, 2014 at 9:03 am
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 you posted.
--
SQLBuddy
Exactly,...
For fast, accurate and documented assistance in answering your questions, please read this article.
Understanding and using APPLY, (I) and (II) Paul White
Hidden RBAR: Triangular Joins / The "Numbers" or "Tally" Table: What it is and how it replaces a loop Jeff Moden
March 11, 2014 at 8:44 am
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...
For fast, accurate and documented assistance in answering your questions, please read this article.
Understanding and using APPLY, (I) and (II) Paul White
Hidden RBAR: Triangular Joins / The "Numbers" or "Tally" Table: What it is and how it replaces a loop Jeff Moden
March 11, 2014 at 8:38 am
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 you posted.
--
SQLBuddy
Exactly, but my...
For fast, accurate and documented assistance in answering your questions, please read this article.
Understanding and using APPLY, (I) and (II) Paul White
Hidden RBAR: Triangular Joins / The "Numbers" or "Tally" Table: What it is and how it replaces a loop Jeff Moden
March 11, 2014 at 8:30 am
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 you posted.
--
SQLBuddy
Exactly, but my...
For fast, accurate and documented assistance in answering your questions, please read this article.
Understanding and using APPLY, (I) and (II) Paul White
Hidden RBAR: Triangular Joins / The "Numbers" or "Tally" Table: What it is and how it replaces a loop Jeff Moden
March 11, 2014 at 8:10 am
You're welcome Geoff. Which part helped?
For fast, accurate and documented assistance in answering your questions, please read this article.
Understanding and using APPLY, (I) and (II) Paul White
Hidden RBAR: Triangular Joins / The "Numbers" or "Tally" Table: What it is and how it replaces a loop Jeff Moden
March 11, 2014 at 7:19 am
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,...
For fast, accurate and documented assistance in answering your questions, please read this article.
Understanding and using APPLY, (I) and (II) Paul White
Hidden RBAR: Triangular Joins / The "Numbers" or "Tally" Table: What it is and how it replaces a loop Jeff Moden
March 11, 2014 at 6:36 am
amy26 (3/6/2014)
For fast, accurate and documented assistance in answering your questions, please read this article.
Understanding and using APPLY, (I) and (II) Paul White
Hidden RBAR: Triangular Joins / The "Numbers" or "Tally" Table: What it is and how it replaces a loop Jeff Moden
March 6, 2014 at 9:48 am
pharmkittie (3/6/2014)
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...
For fast, accurate and documented assistance in answering your questions, please read this article.
Understanding and using APPLY, (I) and (II) Paul White
Hidden RBAR: Triangular Joins / The "Numbers" or "Tally" Table: What it is and how it replaces a loop Jeff Moden
March 6, 2014 at 8:51 am
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...
For fast, accurate and documented assistance in answering your questions, please read this article.
Understanding and using APPLY, (I) and (II) Paul White
Hidden RBAR: Triangular Joins / The "Numbers" or "Tally" Table: What it is and how it replaces a loop Jeff Moden
March 6, 2014 at 7:21 am
rodjkidd (3/6/2014)
ChrisM@Work (3/6/2014)
Are you working in Maidenhead, Rod?Chris,
Work in Bracknell, stay near Bray in Maidenhead at the moment.
Rodders...
Not much of a hike then. Bray, home of the Fat Duck. I...
For fast, accurate and documented assistance in answering your questions, please read this article.
Understanding and using APPLY, (I) and (II) Paul White
Hidden RBAR: Triangular Joins / The "Numbers" or "Tally" Table: What it is and how it replaces a loop Jeff Moden
March 6, 2014 at 6:21 am
Viewing 15 posts - 3,541 through 3,555 (of 10,143 total)