Forum Replies Created
Viewing 15 posts - 196 through 210 (of 10,143 total)
-
RE: Slow SQL Script
Here's a slightly more conventional form of the same query just to get us started really. Please can you run it, confirm that it generates correct results, then post the...
“Write the query the simplest way. If through testing it becomes clear that the performance is inadequate, consider alternative query forms.” - Gail ShawFor 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 -
RE: poor performing report query against table without a PK
Create this index and check out the plan. I'd expect to see a seek for the date and residual predicate for the remaining filter columns, then a key lookup to...
“Write the query the simplest way. If through testing it becomes clear that the performance is inadequate, consider alternative query forms.” - Gail ShawFor 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 -
RE: poor performing report query against table without a PK
Grant Fritchey - Monday, November 26, 2018 8:11 AMChrisM@Work - Monday, November 26, 2018 8:06 AMRE: poor performing report query against table without a PK
Jonathan AC Roberts - Monday, November 26, 2018 7:52 AM“Write the query the simplest way. If through testing it becomes clear that the performance is inadequate, consider alternative query forms.” - Gail ShawFor 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 ModenRE: Inner joins
andycadley - Sunday, November 25, 2018 2:48 PM“Write the query the simplest way. If through testing it becomes clear that the performance is inadequate, consider alternative query forms.” - Gail ShawFor 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 ModenRE: poor performing report query against table without a PK
polkadot - Sunday, November 25, 2018 11:02 PM“Write the query the simplest way. If through testing it becomes clear that the performance is inadequate, consider alternative query forms.” - Gail ShawFor 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 ModenRE: High memory utilization on SQL Server
sqlguy80 - Sunday, November 25, 2018 6:48 PM“Write the query the simplest way. If through testing it becomes clear that the performance is inadequate, consider alternative query forms.” - Gail ShawFor 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 ModenRE: pivot with group by
tanehome - Thursday, November 15, 2018 2:41 AM
Hi All,
I need your assist in a simple query to pivot the below...“Write the query the simplest way. If through testing it becomes clear that the performance is inadequate, consider alternative query forms.” - Gail ShawFor 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 ModenRE: Creating a Stored Procedure with Loop and If statement into a new table
roy.hoult - Tuesday, November 13, 2018 12:10 PM“Write the query the simplest way. If through testing it becomes clear that the performance is inadequate, consider alternative query forms.” - Gail ShawFor 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 ModenRE: SQL Query Delete top 4000 rows when row count > 10K looping to reduce row count to 10K
epivaral - Tuesday, November 13, 2018 10:33 AM“Write the query the simplest way. If through testing it becomes clear that the performance is inadequate, consider alternative query forms.” - Gail ShawFor 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 ModenRE: SQL Query Delete top 4000 rows when row count > 10K looping to reduce row count to 10K
register 33943 - Tuesday, November 13, 2018 9:38 AM“Write the query the simplest way. If through testing it becomes clear that the performance is inadequate, consider alternative query forms.” - Gail ShawFor 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 ModenRE: character data type selection in table design
What's wrong with 'Y' and 'N' as CHAR(1)? Unlike 0 and 1, there's no chance of getting them the wrong way around (I've seen this!!). You could even make it...
“Write the query the simplest way. If through testing it becomes clear that the performance is inadequate, consider alternative query forms.” - Gail ShawFor 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 ModenRE: Running query with Actual Execution Plan On slows down the query?
Jonathan AC Roberts - Tuesday, November 13, 2018 7:41 AM“Write the query the simplest way. If through testing it becomes clear that the performance is inadequate, consider alternative query forms.” - Gail ShawFor 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 ModenRE: Creating a Stored Procedure with Loop and If statement into a new table
If you really need the table CIP_updated_dateTOBE then use this:
;WITH FirstSelection AS (“Write the query the simplest way. If through testing it becomes clear that the performance is inadequate, consider alternative query forms.” - Gail ShawFor 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 ModenRE: Creating a Stored Procedure with Loop and If statement into a new table
Something like this:
;WITH FirstSelection AS (
SELECT
[TB_Code],
[TB_Start_production],
[TB_Resource_Code],
[TB_Version],
[TB_Start_Changeover],
[tb_duration_changeover],
[id] = ROW_NUMBER() OVER(ORDER BY TB_Resource_code ,TB_Start_production),
CIP_END,
[END_CIP] = CONVERT(char(5), DATEADD(MINUTE, tb_duration_changeover,...“Write the query the simplest way. If through testing it becomes clear that the performance is inadequate, consider alternative query forms.” - Gail ShawFor 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 ModenViewing 15 posts - 196 through 210 (of 10,143 total)
