ChrisM@Work

Forum Replies Created

Viewing 15 posts - 8,131 through 8,145 (of 10,143 total)

RE: Are the posted questions getting worse?

Paul White (2/22/2010)
Chris Morris-439714 (2/22/2010)
No, really! And you, Mr White, should write an article on APPLY. I'm learning tons from reading your recent posts and I'm sure I'm not alone....
^{“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

February 22, 2010 at 8:31 am

#1122989
RE: Are the posted questions getting worse?

Paul White (2/22/2010)
Chris Morris-439714 (2/22/2010)
:blush: time for more reading, less writing.
:laugh: Yeah, right! :laugh:
No, really! And you, Mr White, should write an article on CROSS APPLY. I'm learning tons from...
^{“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

February 22, 2010 at 7:58 am

#1122965
RE: Are the posted questions getting worse?

GSquared (2/22/2010)
Paul White (2/22/2010)
Is it just me...or are the posted questions getting better?
:smooooth:
Paul
Questions seem okay right now. Some of the answers have been abysmal recently. I guess 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

February 22, 2010 at 7:35 am

#1122949
RE: Are the posted questions getting worse?

Grant Fritchey (2/19/2010)
Chris Morris-439714 (2/19/2010)
Grant Fritchey (2/18/2010)
... I don't think I've got some great advantage over others...
SQL Server 2008 Query Performance Tuning Distilled
SQL Server Execution Plans
There's more than one copy...
^{“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

February 19, 2010 at 4:14 am

#1121703
RE: Are the posted questions getting worse?

Grant Fritchey (2/18/2010)
... I don't think I've got some great advantage over others...
SQL Server 2008 Query Performance Tuning Distilled
SQL Server Execution Plans
There's more than one copy here, and we're 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

February 19, 2010 at 2:18 am

#1121631
RE: complex join

APIJENA (2/18/2010)
Thanks ChrisM@home for the reply, but tab2 doesn't have 'city' column.
as mentioned in the step 2, I want to join, on city, records matched in step1 with those didnt...
^{“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

February 18, 2010 at 7:21 am

#1120908
RE: Are the posted questions getting worse?

Paul White (2/18/2010)
Chris Morris-439714 (2/18/2010)
Paul White (2/18/2010)
Oh dear, I posted a reply to that identity-order thread before checking here :ermm:
It's a great answer and needed to be said on 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

February 18, 2010 at 4:26 am

#1120786
RE: Are the posted questions getting worse?

Paul White (2/18/2010)
Oh dear, I posted a reply to that identity-order thread before checking here :ermm:
It's a great answer and needed to be said on the thread.
^{“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

February 18, 2010 at 4:00 am

#1120773
RE: Tsql conditional Join

phumlo1 (2/10/2010)
Hi All,
I have a table-- TableA which could be linked to either TableB or TableC. I want to join either of the latter depending on which one is...
^{“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

February 10, 2010 at 4:21 am

#1116680
RE: Are the posted questions getting worse?

Alvin Ramard (2/9/2010)
Oh oh. Someone is asking for documentation or white paper for the "command". :w00t:
Gus, wipe that smile off you face! 😀
The white paper won't be published...
^{“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

February 9, 2010 at 9:19 am

#1116199
RE: Cannot Get Average of rowcount: Msg 130, Level 15, State 1, Line 1 Cannot perform an aggregate function on an expression

Andrew Watson-478275 (2/9/2010)
Could be I'm just being thick (it wouldn't be the first time), but I don't follow how the DATEDIFF(hh,0,EventTime) can work.
select datediff(hh,0,'09 feb 2010 12:34:56') returns 965196
and select...
^{“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

February 9, 2010 at 7:27 am

#1116112
RE: Stored Procedure

TheSQLGuru (2/8/2010)
I wonder if the OP realizes that he/she is open to still putting in a record that already exists without proper transactioning/locking, especially if they do it in 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

February 8, 2010 at 9:44 am

#1115618
RE: Linking to the Previous Row

peter-757102 (2/8/2010)
Chris Morris-439714 (2/8/2010)
peter-757102 (1/23/2009)
Nice work, Peter, but I'm curious - if a CTE doesn't generate any kind of intermediate result, then how might a recursive CTE work? Bear 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

February 8, 2010 at 8:18 am

#1115528
RE: Linking to the Previous Row

peter-757102 (1/23/2009)
I understand your point of view as well as the theory you put forward as to why it might be different in case of my proof. Therefore I did...
^{“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

February 8, 2010 at 7:17 am

#1115469
RE: Are the posted questions getting worse?

Alvin Ramard (2/5/2010)
Picture what might happen if Steve tried to get rid of The Thread:
The Thread: Just what do you think you're doing, Steve?
The Thread: Look Steve, I can...
^{“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

February 8, 2010 at 2:11 am

#1115339

Viewing 15 posts - 8,131 through 8,145 (of 10,143 total)