ChrisM@Work

Forum Replies Created

Viewing 15 posts - 676 through 690 (of 10,143 total)

RE: Are the posted questions getting worse?

Jeff Moden - Friday, June 23, 2017 2:57 PM
Ed Wagner - Friday, June 23, 2017 1:20 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 26, 2017 at 1:40 am

#1948100
RE: Missing months group by

if 0 = 1 begin
CREATE TABLE #temp4(
Bdate DATE
,Country VARCHAR(7)
,Type VARCHAR(4)
,P1 INT
,P2 INT
,C1 INT
...
^{“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 22, 2017 at 8:54 am

#1947781
RE: Are the posted questions getting worse?

Ed Wagner - Wednesday, June 21, 2017 9:02 AM
Brandie Tarvin - Wednesday, June 21, 2017 8:54 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 21, 2017 at 9:55 am

#1947593
RE: Missing months group by

Steve Jones - SSC Editor - Wednesday, June 21, 2017 7:59 AM
You (Papil), need to understand how the query works. I'm not...
^{“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 21, 2017 at 8:33 am

#1947571
RE: Missing months group by

The next step is to construct the statement as a string so it can be executed.
Here's the entire output list constructed as a string from the source table:
^{“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 20, 2017 at 4:39 am

#1947356
RE: Missing months group by

Other than making the batch dynamic, this should be very close:
DROP TABLE #SummedData
-- create a matrix of date, country and type and left-join the data set...
^{“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 19, 2017 at 10:12 am

#1947278
RE: Missing months group by

Papil - Friday, June 16, 2017 10:14 AM
ChrisM@Work - Friday, June 16, 2017 9: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

June 19, 2017 at 7:06 am

#1947240
RE: Missing months group by

Ta Phil 🙂
Here's a correction to the hard-coded query, check that it's what you're looking for from the hard-coded version. Let us know if it is, and someone...
^{“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 16, 2017 at 9:33 am

#1947117
RE: Missing months group by

You're going to need dynamic sql to get the month/year columns. Here's a query for picking up the values:
^{“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 16, 2017 at 4:51 am

#1947070

RE: SQL server 2014 is very slow

pranabpal - Wednesday, June 14, 2017 6:02 PM

bmg002 - Wednesday, June 14, 2017 12:18 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 15, 2017 at 1:30 am

#1946878

RE: Query Performance

You're taking most of the data fromthese tables and that severely limits your options - which might not be a badthing. The main issue with your...

^{“Write the query the simplest way. If through testing it becomes clear that the performance is inadequate, consider alternative query forms.” - Gail Shaw}

June 13, 2017 at 7:08 am

#1946539

RE: Day-of-week to Week-Number mapping

Sergiy - Monday, June 12, 2017 8:06 AM

Jeff Atherton - Thursday, March 16, 2017 7:25 AM

^{“Write the query the simplest way. If through testing it becomes clear that the performance is inadequate, consider alternative query forms.” - Gail Shaw}

June 12, 2017 at 8:10 am

#1946402

RE: Best way to handle a table-based queue?

ScottPletcher - Thursday, June 8, 2017 2:40 PM

1) I don't see why READPAST would lead to deadlocking.
2) I would think you do need...

^{“Write the query the simplest way. If through testing it becomes clear that the performance is inadequate, consider alternative query forms.” - Gail Shaw}

June 9, 2017 at 8:22 am

#1946177

RE: Locking behaviour

vsamantha35 - Thursday, June 8, 2017 7:18 PM

Hi All,

We have a SELECT query which runs for almost 9 hours queing up CXPACKET...

^{“Write the query the simplest way. If through testing it becomes clear that the performance is inadequate, consider alternative query forms.” - Gail Shaw}

June 9, 2017 at 8:14 am

#1946173

RE: Unable to get data from Joins

Keep it simple:

SELECT

TotalNoOfCompanies

^{“Write the query the simplest way. If through testing it becomes clear that the performance is inadequate, consider alternative query forms.” - Gail Shaw}

June 9, 2017 at 7:24 am

#1946156

Viewing 15 posts - 676 through 690 (of 10,143 total)