ChrisM@Work

Forum Replies Created

Viewing 15 posts - 4,426 through 4,440 (of 10,143 total)

RE: Unsupported datatype...Help!

Davebhoy (7/4/2013)
Thanks for your reply Chris.
Nothing gets returned using like U%
Thanks
Dave.
Hi Dave
Please refer to this Connect article which provides an explanation and a temporary fix. The issue appears to be...
^{“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

July 5, 2013 at 1:06 am

#1629950
RE: Unsupported datatype...Help!

What's returned when you run this:
SELECT DISTINCT rel_value
FROM agr.dbo.relvalue AS relvalue
WHERE (attribute_id = 'A0')
AND (rel_attr_id = 'ZL')
AND rel_value LIKE 'U%'
^{“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

July 4, 2013 at 9:35 am

#1629857
RE: SQL statement that will perform a daily sum aggregation my last chance

engstevo (7/3/2013)
it's my test for BI position ,It's a real problem
It's SQL Server 101, and I'm surprised that the tests for a BI position can be this simple. If you...
^{“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

July 3, 2013 at 5:38 am

#1629490
RE: Massive slowdown in SELECT statement in Cursor from SQL 2000 to 2008 -- need help!

Steve
Take another look at this part of the query:
SELECT
SVPromoInteractions.RefKey
FROM SVPromoInteractions
INNER JOIN (
SELECT
RefKey,
MIN(ContactDate) ContactDate -- Finds the oldest interaction, in case there are more than one 321 rec
FROM SVPromoInteractions
WHERE INum =...
^{“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

July 3, 2013 at 1:23 am

#1629381
RE: The Cascading (CROSS) APPLY

How are you consuming the output, Amy? At almost 3M rows I'm guessing it's part of another query, in which case I'd look first at bundling up the faster 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

July 3, 2013 at 1:08 am

#1629375
RE: How to compate cross column values

sachince61 (7/2/2013)
Thanks for your reply..
Its very much helpful to me..
But i want to know is there any other way without using ROW_NUMBER() function ??
B'cause i am using server 2000 so...
^{“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

July 2, 2013 at 8:24 am

#1629120
RE: How to compate cross column values

-- This should work but the output does not match your "desired output" table.
-- If you can explain why there is a difference then I'm sure the code can
--...
^{“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

July 2, 2013 at 8:12 am

#1629104
RE: Can you please help me??

techmarimuthu (7/2/2013)
@chrism-2@Work : this are (50200,50194,50430,50191,1) Record Id
Yes I can see that! How does the list come into existence? Is it typed in by you or generated...
^{“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

July 2, 2013 at 6:01 am

#1629011
RE: Massive slowdown in SELECT statement in Cursor from SQL 2000 to 2008 -- need help!

steve.pantazis (7/1/2013)
Also, let me re-emphasize that I created a non-unique, non-clustered index for SaleDate, which eliminated the Key Lookup in the execution plan, but peformance is still slow.
Steve
The indexing strategy...
^{“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

July 2, 2013 at 6:00 am

#1629010
RE: Can you please help me??

How is this list (50200,50194,50430,50191,1) generated? Could you leverage the method to create a two-column table instead?
^{“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

July 2, 2013 at 5:16 am

#1628991
RE: Extract first numeric value from a string

Sean Lange (7/1/2013)
valeryk2000 (7/1/2013)
iTVF - 1:08
Scalar- 2:07
Long live iTVF and Sean!
ROFL. Glad you got it working. 🙂
valeryk2000 (7/1/2013)
iTVF - 1:08
Scalar- 2:07
Long live iTVF and Sean!
Limping! 😛
^{“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

July 1, 2013 at 8:37 am

#1628733
RE: Extract first numeric value from a string

valeryk2000 (7/1/2013)
Sean, I hate to look stupid - but this is a quality not easy to hide ...
I was not able to use iTVF in my query ... alas ...
I'm...
^{“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

July 1, 2013 at 8:24 am

#1628728
RE: Problem with Co-Related Subquery

T.Ashish (7/1/2013)
I have attached the execution plans as required.
Waiting for your comments...
The query with the redundant outer select times out - SQL Server effectively gives up trying to find 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

July 1, 2013 at 5:35 am

#1628665
RE: Problem with Co-Related Subquery

T.Ashish (7/1/2013)
Yes, I used Andy's suggestion and it was working fine. After that, Optimizer was suggesting some index. Instead of creating index, I put all the query inside another 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

July 1, 2013 at 4:01 am

#1628649
RE: Problem with Co-Related Subquery

T.Ashish (6/30/2013)
I tried one more thing in above suggestions, as pasted below.
It is not asking for missing indexes and performing much better.
...
^{“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

July 1, 2013 at 3:21 am

#1628642

Viewing 15 posts - 4,426 through 4,440 (of 10,143 total)