ChrisM@Work

Forum Replies Created

Viewing 15 posts - 7,531 through 7,545 (of 10,143 total)

RE: Are the posted questions getting worse?

The Dixie Flatline (8/11/2010)
I was just remembering one of my favorite cartoons from "The Far Side", Chris. 🙂
The comics world lost a great humorist when...
^{“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

August 11, 2010 at 8:53 am

#1205411
RE: Advanced Query Question

sc-w (8/11/2010)
Thanks for this.
Could you do me a favour? I'm not getting my head round how this works.
The part of my query below is the bit that works out...
^{“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

August 11, 2010 at 8:34 am

#1205392
RE: Are the posted questions getting worse?

The Dixie Flatline (8/11/2010)
GilaMonster (8/10/2010)
LutzM (8/10/2010)
You're not talking about Elephant or Zebra biltong, are you?
No, just beef to start with, wouldn't want to scare the poor Americans :-D. Kudu biltong...
^{“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

August 11, 2010 at 8:11 am

#1205375
RE: Joining Multiple Tables - What is the correct order on JOINS?

CELKO (8/11/2010)
...Using table valued functions is a bad programming technique that people who just don't understand declarative programming use to make the code feel like OO. This will mess up...
^{“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

August 11, 2010 at 7:58 am

#1205368
RE: Advanced Query Question

sc-w (8/11/2010)
Well this does not matter in this instance i know they are unique based on their stu_id and i just want their contact deatils to populate the wce_contact tables....
^{“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

August 11, 2010 at 7:49 am

#1205365
RE: Column prefix not doesn't match

donmakaveli41 (8/11/2010)
well I tried the little query you gave me, but I get the same error :
The column prefix 'a' does not match with a table name or alias...
^{“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

August 11, 2010 at 7:24 am

#1205346
RE: Advanced Query Question

The order by in the window function in the CTE in your original query will return a random row from the available dupes.
Is this intentional?
^{“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

August 11, 2010 at 7:22 am

#1205343
RE: Column prefix not doesn't match

donmakaveli41 (8/11/2010)
Chris Morris-439714 (8/11/2010)
What about alias ata?
where ata.type_name = a.type_name AND at.simulator = 0 AND f.atd IS NOT NULL
Yes I've edited my post to correct this. It's not like that...
^{“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

August 11, 2010 at 7:04 am

#1205330
RE: 70-432 exam dump

rjohal-500813 (8/11/2010)
Memorise all this and you are bound to ace the exam...
ROTFLOL! 😀
^{“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

August 11, 2010 at 6:48 am

#1205318
RE: Column prefix not doesn't match

What about alias ata?
where ata.type_name = a.type_name AND at.simulator = 0 AND f.atd IS NOT NULL
If I were you I'd chuck out this query and start again, it looks like...
^{“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

August 11, 2010 at 6:24 am

#1205303
RE: I need a better way to do this

dennisv (8/11/2010)
...
I'm hoping someone can combine these (or at least the last two) for me which should speed it up a lot.
I know this will take some time and thank...
^{“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

August 11, 2010 at 6:08 am

#1205295
RE: Merging two tables

-- make some sample data
DROP TABLE #Archive
DROP TABLE #Current
CREATE TABLE #Current (objectId INT IDENTITY(1,1), Data1 VARCHAR(5), lastModified DATETIME)
INSERT INTO #Current (Data1, lastModified)
SELECT 'A', GETDATE()-5 UNION ALL
SELECT 'B', GETDATE()-4 UNION ALL
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

August 11, 2010 at 5:09 am

#1205276
RE: Help on Table/Query tuning

You could try preaggregating the source query:
;WITH ParameterList AS (
SELECT convert(varchar(max),decryptbypassphrase('SKey',PARAMETERNAME)) PARAMETERNAME
FROM MST_PARAMETER
),
Preaggregate AS (
SELECT PARAMETERNAME, -- extra columns required here
Col1 = SUM(Col1),
Col2 = SUM(Col2),
Col3 =...
^{“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

August 11, 2010 at 4:04 am

#1205240
RE: Are the posted questions getting worse?

LutzM (8/10/2010)
GilaMonster (8/10/2010)
...Love to, but it wouldn't be allowed through customs on this side. Same with honey, fruit and meat products etc. Otherwise I'd bring biltong when I visit...
^{“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

August 11, 2010 at 2:12 am

#1205191
RE: Today's Random Word!

Neuromasts
^{“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

August 10, 2010 at 8:36 am

#1204828

Viewing 15 posts - 7,531 through 7,545 (of 10,143 total)