ChrisM@Work

Forum Replies Created

Viewing 15 posts - 466 through 480 (of 10,143 total)

RE: Divide column data into equal parts

If it isn't paging you are after, then consider NTILE(8) OVER()
NTILE()
^{“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

January 9, 2018 at 7:51 am

#1975078
RE: Schema Design - Product Packing Box

kiran 4243 - Monday, January 8, 2018 9:14 PM
Dear Experts,
I would to know your valuable suggestions for requirement as mentioned below.
Most of...
^{“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

January 9, 2018 at 7:45 am

#1975077
RE: Problem with Tuning of Delete Statement

There's a rowcount Top operator in your plan with only one reason I can think of: SET ROWCOUNT issued before the query.
When I issue SET ROWCOUNT 1 before...
^{“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

January 5, 2018 at 10:08 am

#1974726
RE: Problem with Tuning of Delete Statement

Hamid-Sadeghian - Friday, January 5, 2018 9:14 AM
ChrisM@Work - Friday, January 5, 2018 6:33 AM
^{“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

January 5, 2018 at 9:49 am

#1974721
RE: Searching strings

-- If VisitID is a string within PcsAssmntDataID bounded by spaces,
-- then you could use a string-splitter followed by LEN or something
-- else to collect 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

January 5, 2018 at 8:01 am

#1974697
RE: Problem with Tuning of Delete Statement

Hamid-Sadeghian - Thursday, January 4, 2018 8:12 AM
ChrisM@Work - Thursday, January 4, 2018 7:33 AM
^{“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

January 5, 2018 at 6:33 am

#1974666
RE: Are the posted questions getting worse?

Ed Wagner - Thursday, January 4, 2018 9:13 AM
ChrisM@home - Wednesday, January 3, 2018 1:43 PM
^{“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

January 4, 2018 at 9:23 am

#1974496
RE: Problem with Tuning of Delete Statement

Hamid-Sadeghian - Thursday, January 4, 2018 5:50 AM
thank you,
This index already exist on this table. but I think has a problem with...
^{“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

January 4, 2018 at 7:33 am

#1974454
RE: How to get up to 5 hierarchy levels of data from original (parent) to derived (children) product table.

Greg Edwards-268690 - Thursday, January 4, 2018 6:41 AM
ChrisM@Work - Thursday, January 4, 2018 5:51 AM
^{“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

January 4, 2018 at 7:31 am

#1974452
RE: Problem with Tuning of Delete Statement

It's easy enough to model your query. This is sufficient:
SELECT c1.City, c1.Postcode
FROM Customer c1
WHERE NOT EXISTS (
SELECT FanID
FROM Customer c2
WHERE c2.Lastname =...
^{“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

January 4, 2018 at 7:26 am

#1974450
RE: Problem with Tuning of Delete Statement

Hamid-Sadeghian - Thursday, January 4, 2018 5:50 AM
thank you,
This index already exist on this table. but I think has a problem with...
^{“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

January 4, 2018 at 5:58 am

#1974432
RE: How to get up to 5 hierarchy levels of data from original (parent) to derived (children) product table.

aaron.reese - Thursday, January 4, 2018 4:26 AM
Google for Recursive CTE - basically a CTE that references itself. You can set a...
^{“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

January 4, 2018 at 5:51 am

#1974428
RE: How to get up to 5 hierarchy levels of data from original (parent) to derived (children) product table.

Using your original table definition I created a temp table with 7047 rows and set to work.
^{“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

January 4, 2018 at 5:50 am

#1974427
RE: Problem with Tuning of Delete Statement

Hamid-Sadeghian - Thursday, January 4, 2018 5:33 AM
Thank you.
But in Network_V3 fields (SDE_State_ID,Geometry_ID) does not exist and this field is in 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

January 4, 2018 at 5:43 am

#1974424
RE: Problem with Tuning of Delete Statement

DELETE g9
FROM AliTest2.DBO.SDE_GEOMETRY9 g9
WHERE NOT EXISTS (
SELECT v3.objectid, 0
FROM AliTest2.DBO.NETWORK_V3 v3
WHERE v3.OBJECTID = g9.GEOMETRY_ID
AND v3.SDE_STATE_ID = 0
^{“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

January 4, 2018 at 3:28 am

#1974409

Viewing 15 posts - 466 through 480 (of 10,143 total)