ChrisM@Work

Forum Replies Created

Viewing 15 posts - 211 through 225 (of 10,143 total)

RE: Creating a Stored Procedure with Loop and If statement into a new table

roy.hoult - Monday, November 12, 2018 7:03 AM
Hi Chris
[CIP_LatestEndtime] = '', -- EXPRESSION REQUIRED
If the [TB_Resource_Code], on ID 1 = TB_Resource_Code...
^{“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

November 12, 2018 at 9:33 am

#2013232
RE: Creating a Stored Procedure with Loop and If statement into a new table

roy.hoult - Monday, November 12, 2018 5:17 AM
Hi Pietinden
Thank you for your reply, maybe i should have explain the case first,
In short,...
^{“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

November 12, 2018 at 5:43 am

#2013199
RE: Composite indexes; performance

You also want to know what indexes are currently used by those stored procedures. If their plans are cached then you can use this:

/*
ChrisM...
^{“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

November 9, 2018 at 3:28 am

#2012939
RE: Composite indexes; performance

In your shoes I'd begin by gathering information about index usage. This should help you do that. Holler if you require assistance in interpreting the results:
^{“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

November 9, 2018 at 3:18 am

#2012938
RE: Round to two decimal places in a pivot

DReantil - Thursday, November 8, 2018 9:07 AM
Definitely tried that one. Here is what I get:
Msg 195, Level...
^{“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

November 8, 2018 at 9:13 am

#2012849
RE: Composite indexes; performance

Jonathan AC Roberts - Thursday, November 8, 2018 8:47 AM
ChrisM@Work - Thursday, November 8, 2018 8:42 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

November 8, 2018 at 8:50 am

#2012837
RE: Composite indexes; performance

Jonathan AC Roberts - Thursday, November 8, 2018 8:36 AM
AER - Thursday, November 8, 2018 8:29 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

November 8, 2018 at 8:42 am

#2012833
RE: Composite indexes; performance

AER - Thursday, November 8, 2018 8:29 AM
Hi everybody,
I have couple quick questions for the DBAs.
We have 2 heavy SELECT statements in...
^{“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

November 8, 2018 at 8:35 am

#2012829
RE: Round to two decimal places in a pivot

DReantil - Thursday, November 8, 2018 8:10 AM
I'm pretty sure I tried that, but just to be sure I tried it again...
^{“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

November 8, 2018 at 8:31 am

#2012826
RE: Parsing INTERNAL REPRESENTATION OF OVERPUNCH SIGNS

Some alternatives here.
^{“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

November 8, 2018 at 5:36 am

#2012796
RE: Slow run time

Admingod - Wednesday, November 7, 2018 8:32 AM
I have a query which is running slow for approx 15 mins, however, the slow...
^{“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

November 7, 2018 at 9:49 am

#2012714
RE: While Loop Stored Procedure

Daniel.Bayliss - Tuesday, November 6, 2018 8:59 AM
Hi,
Can help me with an issue I am facing. I need to create a single...
^{“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

November 7, 2018 at 7:46 am

#2012693
RE: Execute a Stored Procedure against every row insert in Table

azhar.iqbal499 - Wednesday, November 7, 2018 6:21 AM
This option will not be viable for us, As our data is already there inside...
^{“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

November 7, 2018 at 6:28 am

#2012681
RE: Mixed Joins

Carlo Romagnano - Wednesday, November 7, 2018 4:32 AM
ChrisM@Work - Wednesday, November 7, 2018 3:36 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

November 7, 2018 at 4:35 am

#2012672
RE: Mixed Joins

call.copse - Wednesday, November 7, 2018 3:50 AM
ChrisM@Work - Wednesday, November 7, 2018 3:36 AM
Force...
^{“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

November 7, 2018 at 3:57 am

#2012668

Viewing 15 posts - 211 through 225 (of 10,143 total)