ChrisM@Work

Forum Replies Created

Viewing 15 posts - 7,201 through 7,215 (of 10,143 total)

RE: Are the posted questions getting worse?

Paul White NZ (10/12/2010)
WayneS (10/12/2010)
I think instead of clearing the fog, we've managed to make it denser. :w00t:
Ah I see that thread is fully doomed now - Chris Morris has...
^{“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 13, 2010 at 2:03 am

#1236016
RE: Query tuning - avoid Case statement on this query

Paul White NZ (10/12/2010)
Gianluca Sartori (10/12/2010)
Or, like me, question everything he pretends to know! 😛
While I'm messing with your head, how about this:
"LIKE is not SARGable".
It really isn't 🙂
I'm going...
^{“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 12, 2010 at 10:15 am

#1235672
RE: Today's Random Word!

Ray K (10/12/2010)
WOTD: anniversary! (married eight years today!)
Continuously? To the same person? Well done Ray. Happy Anniversary!
^{“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 12, 2010 at 7:20 am

#1235501
RE: Check for field value before attempting to insert row

Check again - looks like it's failing on business rather than email.
^{“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 12, 2010 at 7:16 am

#1235497
RE: Are the posted questions getting worse?

Grant Fritchey (10/12/2010)
Brandie Tarvin (10/12/2010)
Paul White NZ (10/11/2010)
Jack Corbett (10/11/2010)
$3k is about right at this point. You can do it for less by finding a cheaper hotel and roommate.
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

October 12, 2010 at 7:01 am

#1235479
RE: TRANSPOSE ROWS TO COLUMNS IN SQL SERVER 2005 Without CURSOR

See Cross Tabs and Pivots, Part 1 – Converting Rows to Columns[/url]
and Cross Tabs and Pivots, Part 2 - Dynamic Cross Tabs[/url].
^{“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 12, 2010 at 5:23 am

#1235403
RE: Are the posted questions getting worse?

george sibbald (10/11/2010)
WayneS (10/10/2010)
Hey gang... not definite yet, but my wife is talking about letting me spend the $ to go to PASS. 😀
Any suggestions on good, inexpensive, close places...
^{“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 12, 2010 at 2:34 am

#1235345
RE: How to Compare Rows within Partitioned Sets to Find Overlapping Dates

TheSQLGuru (10/11/2010)
We SOOOOOOO need full Windowing Function support in SQL Server. And yes, performance on this type of query will currently be exceptionally poor and approaching non-functional on increasingly...
^{“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 11, 2010 at 8:15 am

#1235017
RE: How to Compare Rows within Partitioned Sets to Find Overlapping Dates

ta.bu.shi.da.yu (10/11/2010)
If I read this correctly, you just implemented the LAG(...) Over(...) analytic function.
However, I'm interested... if you do this on a large dataset, what does the execution 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 11, 2010 at 5:54 am

#1234921
RE: Are the posted questions getting worse?

Brandie Tarvin (10/8/2010)
Chris Morris-439714 (10/8/2010)
Brandie Tarvin (10/8/2010)
Grant Fritchey (10/8/2010)
what is it we do for work again?
Work is a four letter word. My mother taught me to behavior better than that.
Behaviour,...
^{“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 8, 2010 at 8:58 am

#1234326
RE: Are the posted questions getting worse?

CirquedeSQLeil (10/8/2010)
Brandie Tarvin (10/8/2010)
Grant Fritchey (10/8/2010)
what is it we do for work again?
Work is a four letter word. My mother taught me to behavior better than that.
So now you have...
^{“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 8, 2010 at 8:51 am

#1234319
RE: Are the posted questions getting worse?

Grant Fritchey (10/8/2010)
Jeff Moden (10/8/2010)
The Dixie Flatline (10/7/2010)
I just had an idea for an epic summer movie. It involves an intrepid group of DBA's and SQL...
^{“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 8, 2010 at 8:28 am

#1234300
RE: Views with NULL values

SELECT
COALESCE (dZ_Field1 + CHAR(13) + CHAR(10), '') +
COALESCE (dZ_Field2_A + CHAR(13) + CHAR(10), '') +
COALESCE (dZ_Field3_A + CHAR(13) + CHAR(10), '') +
COALESCE (dZ_Field3_A + CHAR(13) +...
^{“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 8, 2010 at 7:07 am

#1234230
RE: Using MAX and COUNT function to display MAX(COUNT) row(s) from a table

Or this, which works on the raw data i.e. before the first aggregation step:
SELECT
d.kunnr,
d.zterm,
d.cnt
FROM (
SELECT
g.kunnr,
g.zterm,
g.cnt,
rn = ROW_NUMBER() OVER (PARTITION BY kunnr ORDER BY zterm, cnt DESC)
FROM (
SELECT
kunnr,
zterm,
cnt...
^{“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 8, 2010 at 2:29 am

#1234065
RE: Are the posted questions getting worse?

GilaMonster (10/7/2010)
Alvin Ramard (10/7/2010)
I thought the next version of SQL was going to be 2011.
Not necessarily. No release date or name has been announced. The reason people have...
^{“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 8, 2010 at 2:14 am

#1234055

Viewing 15 posts - 7,201 through 7,215 (of 10,143 total)