ChrisM@Work

Forum Replies Created

Viewing 15 posts - 2,101 through 2,115 (of 10,143 total)

RE: how do I fine tune this query

mw112009 (10/2/2015)
Not clear what you mean ?
Should I drop the PRIMARY key and CREATE AGAIN ?
No. Since you want most of the rows and most of the columns from 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

October 2, 2015 at 9:29 am

#1831088
RE: how do I fine tune this query

You might want to put some time into removing those DISTINCTs. In the second query the sort for the DISTINCT spills to disk because more rows pass through the operator...
^{“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

October 2, 2015 at 9:20 am

#1831085
RE: how do I fine tune this query

mw112009 (10/2/2015)
Do you want me to redefine the index using the "INCLUDE" clause ? Is that what you mean ?
Can you pass an example please of what you mean by...
^{“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

October 2, 2015 at 9:15 am

#1831082
RE: how do I fine tune this query

mw112009 (10/2/2015)
Can you help me understand this ...
I have the following index defined on hinstp table covering 2 columns ( ADMDT, FORMN )
PK_HINSTPclustered, unique, primary key located on...
^{“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

October 2, 2015 at 9:08 am

#1831077
RE: how do I fine tune this query

mw112009 (10/2/2015)
Can you help me understand this ...
I have the following index defined on hinstp table covering 2 columns ( ADMDT, FORMN )
PK_HINSTPclustered, unique, primary key located on...
^{“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

October 2, 2015 at 8:24 am

#1831061
RE: how do I fine tune this query

mw112009 (10/2/2015)
Got lost here.. What button/menu item should I use to see the actual plan ? ( not the estimated )
Six objects to the right of "Debug" on the menu...
^{“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

October 2, 2015 at 8:03 am

#1831049
RE: how do I fine tune this query

Grant Fritchey (10/2/2015)
ChrisM@Work (10/2/2015)
Grant Fritchey (10/2/2015)
ChrisM@Work (10/2/2015)
Jason A. Long (10/2/2015)
ChrisM@Work (10/2/2015)
Jason A. Long (10/1/2015)
...
Also note that you will need to look at the Actual execution plan to see the plan...
^{“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

October 2, 2015 at 7:36 am

#1831036
RE: how do I fine tune this query

Grant Fritchey (10/2/2015)
ChrisM@Work (10/2/2015)
Jason A. Long (10/2/2015)
ChrisM@Work (10/2/2015)
Jason A. Long (10/1/2015)
...
Also note that you will need to look at the Actual execution plan to see the plan change. The Estimated...
^{“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

October 2, 2015 at 7:17 am

#1831030
RE: how do I fine tune this query

Grant Fritchey (10/2/2015)
Jason A. Long (10/2/2015)
ChrisM@Work (10/2/2015)
Jason A. Long (10/1/2015)
...
Also note that you will need to look at the Actual execution plan to see the plan change. The Estimated plan...
^{“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

October 2, 2015 at 7:08 am

#1831028
RE: how do I fine tune this query

Jason A. Long (10/2/2015)
ChrisM@Work (10/2/2015)
Jason A. Long (10/1/2015)
...
Also note that you will need to look at the Actual execution plan to see the plan change. The Estimated plan will continue...
^{“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

October 2, 2015 at 6:53 am

#1831025
RE: Are the posted questions getting worse?

Brandie Tarvin (10/2/2015)
Greg Edwards-268690 (10/1/2015)
Brandie Tarvin (10/1/2015)
BrainDonor (10/1/2015)
BL0B_EATER (10/1/2015)
Talking about pork products, any one understand Sausage with Maple? I don't..
I've been to Canada more times than I can recall -...
^{“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

October 2, 2015 at 6:13 am

#1831015
RE: Are the posted questions getting worse?

Eirikur Eiriksson (10/2/2015)
ChrisM@Work (10/2/2015)
dwain.c (10/1/2015)
Eirikur Eiriksson (10/1/2015)
ChrisM@Work (10/1/2015)
Eirikur Eiriksson (10/1/2015)
ChrisM@Work (10/1/2015)
Eirikur Eiriksson (10/1/2015)
ChrisM@Work (10/1/2015)
Eirikur Eiriksson (10/1/2015)
ChrisM@Work (10/1/2015)
Eirikur Eiriksson (10/1/2015)
ChrisM@Work (10/1/2015)
Eirikur Eiriksson (10/1/2015)
ChrisM@Work (10/1/2015)
Oh, and maple beer - yuck.
This made me...
^{“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

October 2, 2015 at 5:52 am

#1831009
RE: how do I fine tune this query

Jason A. Long (10/1/2015)
...
Also note that you will need to look at the Actual execution plan to see the plan change. The Estimated plan will continue to show the index...
^{“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

October 2, 2015 at 4:41 am

#1830996
RE: Are the posted questions getting worse?

dwain.c (10/1/2015)
Eirikur Eiriksson (10/1/2015)
ChrisM@Work (10/1/2015)
Eirikur Eiriksson (10/1/2015)
ChrisM@Work (10/1/2015)
Eirikur Eiriksson (10/1/2015)
ChrisM@Work (10/1/2015)
Eirikur Eiriksson (10/1/2015)
ChrisM@Work (10/1/2015)
Eirikur Eiriksson (10/1/2015)
ChrisM@Work (10/1/2015)
Eirikur Eiriksson (10/1/2015)
ChrisM@Work (10/1/2015)
Oh, and maple beer - yuck.
This made me spill my ESB...
^{“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

October 2, 2015 at 1:37 am

#1830974
RE: Are the posted questions getting worse?

Eirikur Eiriksson (10/1/2015)
ChrisM@Work (10/1/2015)
Eirikur Eiriksson (10/1/2015)
ChrisM@Work (10/1/2015)
Eirikur Eiriksson (10/1/2015)
ChrisM@Work (10/1/2015)
Eirikur Eiriksson (10/1/2015)
ChrisM@Work (10/1/2015)
Eirikur Eiriksson (10/1/2015)
ChrisM@Work (10/1/2015)
Eirikur Eiriksson (10/1/2015)
ChrisM@Work (10/1/2015)
Oh, and maple beer - yuck.
This made me spill my ESB all...
^{“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

October 1, 2015 at 8:35 am

#1830794

Viewing 15 posts - 2,101 through 2,115 (of 10,143 total)