ChrisM@Work

Forum Replies Created

Viewing 15 posts - 2,431 through 2,445 (of 10,143 total)

RE: Are the posted questions getting worse?

rodjkidd (6/16/2015)
ChrisM@Work (6/16/2015)
rodjkidd (6/16/2015)
ChrisM@Work (6/16/2015)
dwain.c (6/15/2015)
Here's one for the hard-core Sci-Fi fans out there:
Size Comparison - Science Fiction Spaceships
Count me among 'em.
I sent the link around the lads here. One...
^{“Write the query the simplest way. If through testing it becomes clear that the performance is inadequate, consider alternative query forms.” - Gail Shaw}
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

June 16, 2015 at 3:15 am

#1805665
RE: Are the posted questions getting worse?

rodjkidd (6/16/2015)
ChrisM@Work (6/16/2015)
dwain.c (6/15/2015)
Here's one for the hard-core Sci-Fi fans out there:
Size Comparison - Science Fiction Spaceships
Count me among 'em.
I sent the link around the lads here. One of them...
^{“Write the query the simplest way. If through testing it becomes clear that the performance is inadequate, consider alternative query forms.” - Gail Shaw}
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

June 16, 2015 at 2:53 am

#1805659
RE: Are the posted questions getting worse?

rodjkidd (6/16/2015)
ChrisM@Work (6/16/2015)
dwain.c (6/15/2015)
Here's one for the hard-core Sci-Fi fans out there:
Size Comparison - Science Fiction Spaceships
Count me among 'em.
I sent the link around the lads here. One of them...
^{“Write the query the simplest way. If through testing it becomes clear that the performance is inadequate, consider alternative query forms.” - Gail Shaw}
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

June 16, 2015 at 2:51 am

#1805658
RE: Are the posted questions getting worse?

dwain.c (6/15/2015)
Here's one for the hard-core Sci-Fi fans out there:
Size Comparison - Science Fiction Spaceships
Count me among 'em.
I sent the link around the lads here. One of them sent the...
^{“Write the query the simplest way. If through testing it becomes clear that the performance is inadequate, consider alternative query forms.” - Gail Shaw}
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

June 16, 2015 at 2:44 am

#1805656
RE: Are the posted questions getting worse?

dwain.c (6/16/2015)
rodjkidd (6/16/2015)
dwain.c (6/15/2015)
Here's one for the hard-core Sci-Fi fans out there:
Size Comparison - Science Fiction Spaceships
Count me among 'em.
From the comments;
Q: And where's TARDIS?
A: It's both too large and...
^{“Write the query the simplest way. If through testing it becomes clear that the performance is inadequate, consider alternative query forms.” - Gail Shaw}
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

June 16, 2015 at 2:42 am

#1805655
RE: SET 1 symbol instead whole string in varchar value

koles2004 (6/12/2015)
I have such Function:
IF EXISTS (SELECT * FROM sys.objects WHERE name = 'TwoDigitsNumber' AND type = 'FN')
DROP FUNCTION MinimumOFThree;
GO
CREATE FUNCTION TwoDigitsNumber(@a int)
RETURNS nvarchar(20)
AS
BEGIN
DECLARE @str nvarchar(20);
DECLARE...
^{“Write the query the simplest way. If through testing it becomes clear that the performance is inadequate, consider alternative query forms.” - Gail Shaw}
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

June 12, 2015 at 9:27 am

#1805091
RE: Deadlock issue

muratos2007 (6/12/2015)
....I have suggested not using the cursor for the programmer. But, surely he will continue use it 😀
I don't know what to do more....
Your programmer is learning his trade...
^{“Write the query the simplest way. If through testing it becomes clear that the performance is inadequate, consider alternative query forms.” - Gail Shaw}
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

June 12, 2015 at 6:45 am

#1805008
RE: SQL Server Query Running Slow for huge data set

-- Style 112 for the convert function is 'yyyymmdd' which doesn't match the supplied string.
-- The CONVERT function doesn't make sense anyway - you're converting a string to a string.
--...
^{“Write the query the simplest way. If through testing it becomes clear that the performance is inadequate, consider alternative query forms.” - Gail Shaw}
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

June 12, 2015 at 5:45 am

#1804967
RE: SQL Server Query Running Slow for huge data set

T2512 (6/12/2015)
Thank you for the reply!! the execution plan has real table names, which is why i did not post the full plan earlier. The image attached is the...
^{“Write the query the simplest way. If through testing it becomes clear that the performance is inadequate, consider alternative query forms.” - Gail Shaw}
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

June 12, 2015 at 5:23 am

#1804957
RE: SQL Server Query Running Slow for huge data set

-- Please check that this formatted version of your query still works,
-- then put table aliases before each column reference in the
-- inner derived table 'r'.
SELECT DISTINCT *...
^{“Write the query the simplest way. If through testing it becomes clear that the performance is inadequate, consider alternative query forms.” - Gail Shaw}
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

June 12, 2015 at 4:53 am

#1804947
RE: SQL Server Query Running Slow for huge data set

Can you attach an actual execution plan as a .sqlplan attachment please? Each graphical component on the plan has a whole bunch of properties which provide essential clues for query...
^{“Write the query the simplest way. If through testing it becomes clear that the performance is inadequate, consider alternative query forms.” - Gail Shaw}
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

June 12, 2015 at 4:30 am

#1804937
RE: Performance issue with this query

Gangadhara MS (6/11/2015)
please look for my first post,i have included the schema as well as execution plan by editing it.
Please post the execution plan as a .sqlplan attachment, not...
^{“Write the query the simplest way. If through testing it becomes clear that the performance is inadequate, consider alternative query forms.” - Gail Shaw}
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

June 12, 2015 at 3:44 am

#1804924
RE: Ranking duplicate contacts using multiple columns for ranking. Phone and emails that are blank can match to phones and emails that are not blank.

jeff.born (6/11/2015)
SSCertifiable,
I've been playing with the cross apply and trying to get it to work with a few other requirements. Each business group I should easily be able to...
^{“Write the query the simplest way. If through testing it becomes clear that the performance is inadequate, consider alternative query forms.” - Gail Shaw}
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

June 11, 2015 at 9:59 am

#1804761
RE: Select multiple values from same column and make them to show in a row

-- It's not clear what you want as your output because you decribed it (badly)
-- rather than presenting it as data.
-- This might be correct, then again, it...
^{“Write the query the simplest way. If through testing it becomes clear that the performance is inadequate, consider alternative query forms.” - Gail Shaw}
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

June 11, 2015 at 4:29 am

#1804638
RE: Apply And operator on same column

CREATE TABLE #NewsEntities (NewsEntity INT NOT NULL identity(1,1), NewsId INT, EntityId INT)
INSERT INTO #NewsEntities (NewsId, EntityId)
VALUES
(1,1),(1,2),(1,3),
(2,1),(2,5),(2,3),
(3,5),(3,2),(3,3)
SELECT n.NewsId
FROM #NewsEntities n
WHERE EntityId = 1
AND NOT EXISTS (
SELECT 1
FROM #NewsEntities...
^{“Write the query the simplest way. If through testing it becomes clear that the performance is inadequate, consider alternative query forms.” - Gail Shaw}
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

June 11, 2015 at 3:16 am

#1804624

Viewing 15 posts - 2,431 through 2,445 (of 10,143 total)