ChrisM@Work

Forum Replies Created

Viewing 15 posts - 691 through 705 (of 10,143 total)

RE: Index seek and index scan

krishna83 - Friday, June 9, 2017 5:57 AM
Please find attached actual execution plan of the query.
This is an estimated plan. To get...
^{“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 9, 2017 at 6:07 am

#1946143
RE: Index seek and index scan

krishna83 - Friday, June 9, 2017 4:59 AM
I raised this question to improve performance of the query.It would be more help full...
^{“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 9, 2017 at 5:06 am

#1946130
RE: Index seek and index scan

krishna83 - Friday, June 9, 2017 3:59 AM
It's dataware house application.
Every day I collect database statistics and rebuilding existing indexes if require.
I...
^{“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 9, 2017 at 4:08 am

#1946119
RE: Index seek and index scan

krishna83 - Friday, June 9, 2017 1:49 AM
Please find attached execution plan and post your suggestions here
Thanks for posting the plan, it's...
^{“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 9, 2017 at 2:23 am

#1946107
RE: Index seek and index scan

krishna83 - Wednesday, June 7, 2017 9:38 AM
If I create cluster index on a column I have observed index scan on 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

June 7, 2017 at 9:53 am

#1945846
RE: SQL server 2014 is very slow

pranabpal - Tuesday, June 6, 2017 8:21 AM
bmg002 - Monday, June 5, 2017 9:02 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

June 6, 2017 at 9:15 am

#1945639
RE: SQL server 2014 is very slow

pranabpal - Tuesday, June 6, 2017 8:21 AM
bmg002 - Monday, June 5, 2017 9:02 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

June 6, 2017 at 8:28 am

#1945616
RE: Index fragmentation

krishna83 - Tuesday, June 6, 2017 5:31 AM
Okay,
I have a table with out any indexes. If I am deleting & Inserting data...
^{“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 6, 2017 at 6:27 am

#1945572
RE: Index fragmentation

VastSQL - Sunday, June 4, 2017 5:15 AM
GilaMonster - Sunday, June 4, 2017 4:48 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

June 6, 2017 at 5:10 am

#1945559
RE: Need Help Getting Max Date

SELECT
COUNTY.CountyName,
property.State.
x.UserDate2 AS LastCovered,
x.CompletedDate
FROM COUNTY COUNTY
INNER JOIN property property
ON COUNTY.CountyCode = property.County
CROSS APPLY (
SELECT TOP(1)
^{“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 5, 2017 at 7:18 am

#1945391
RE: Are the posted questions getting worse?

Neil Burton - Monday, June 5, 2017 2:28 AM
ChrisM@Work - Monday, June 5, 2017 2:11 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

June 5, 2017 at 2:38 am

#1945349
RE: Are the posted questions getting worse?

Neil Burton - Monday, June 5, 2017 2:08 AM
Ed Wagner - Friday, June 2, 2017 7:06 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

June 5, 2017 at 2:11 am

#1945343
RE: Reset SUM during Grouped selection using CTE

Stefan LG - Monday, June 5, 2017 12:30 AM
@chrism-2: Thanks for the solution!
I had a look at the Execution Plan and 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 5, 2017 at 2:00 am

#1945341
RE: Are the posted questions getting worse?

Sean Lange - Friday, June 2, 2017 1:44 PM
bmg002 - Friday, June 2, 2017 1:27 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

June 5, 2017 at 1:47 am

#1945339
RE: SQL Query find certain values and show corresponding value from different field

SELECT t.*
FROM @Table1 t
WHERE [Type] = 'Periodic'
OR
([Type] IS NULL AND NOT EXISTS (
  SELECT 1
  FROM @Table1 ti
  WHERE ti.ID...
^{“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 2, 2017 at 9:38 am

#1945150

Viewing 15 posts - 691 through 705 (of 10,143 total)