ChrisM@Work

Forum Replies Created

Viewing 15 posts - 7,576 through 7,590 (of 10,143 total)

RE: Are the posted questions getting worse?

Brandie Tarvin (8/5/2010)
Chris Morris-439714 (8/5/2010)
Jack Corbett (8/5/2010)
...
Where you place the criteria for OUTER JOIN's DOES make a difference. Whenever you place criteria in the WHERE clause that references 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

August 5, 2010 at 8:21 am

#1202786
RE: Are the posted questions getting worse?

Jack Corbett (8/5/2010)
...
Where you place the criteria for OUTER JOIN's DOES make a difference. Whenever you place criteria in the WHERE clause that references a column in your OUTER...
^{“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 5, 2010 at 8:00 am

#1202757
RE: Best practice: Syntax error converting value -> determine problematic row

Thom- (8/5/2010)
Well, I just have a simple query in my query window ->
insert into testtable
select a,b,c,d from openquery(server2,'select a,b,c,d from testtable2)
Now I'm getting the error -> how would I...
^{“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 5, 2010 at 4:17 am

#1202602
RE: Too many CASE statements...how to avoid??

CELKO (8/4/2010)
...Also, start using COALESCE() instead of ISNULL() ...
Why is that, Joe? I use COALESCE() if I want to return the first non-null value from a comma-delimited list of 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

August 5, 2010 at 2:19 am

#1202561
RE: Can I use pivot on this query?

Chris-475469 (8/4/2010)
I'm little reluctant to post some actual data on here because its pretty sensitive. But here is the definitions of the tables i'm using.
Then make some up 😛
-- 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

August 4, 2010 at 6:47 am

#1202047
RE: Too many CASE statements...how to avoid??

There are some ideas in here...I've run out of time 🙁
Oops wrong 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

August 3, 2010 at 10:24 am

#1201660
RE: Are the posted questions getting worse?

Stefan Krzywicki (8/3/2010)
Gianluca Sartori (8/3/2010)
Brandie Tarvin (8/3/2010)
Stefan Krzywicki (8/3/2010)
Brandie Tarvin (8/3/2010)
You could get burned and find yourself without options (and jobs) if a employer decides they don't have the budget...
^{“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 3, 2010 at 8:34 am

#1201586
RE: Are the posted questions getting worse?

Steve Jones - Editor (8/3/2010)
Since this is the water cooler, any comments?
http://abcnews.go.com/US/ground-mosque-plan-stirs-controversy/story?id=10670631
Tasteless and insensitive. Is that an olive branch or a sharp stick I see approaching?
^{“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 3, 2010 at 8:12 am

#1201558
RE: Are the posted questions getting worse?

Tom.Thomson (8/3/2010)
Chris Morris-439714 (8/3/2010)
We've recently finished a few years experiment with socialism here in the UK. Everybody's even now, but some are more even than others 😀
AH, the good old...
^{“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 3, 2010 at 8:01 am

#1201545
RE: Are the posted questions getting worse?

Jeff Moden (8/3/2010)
I'm reminded of something that Margaret Thatcher supposedly said and I'll paraphrase it because I didn't memorize it... the problem with socialism is that you eventually run 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 3, 2010 at 7:41 am

#1201520
RE: Can I use pivot on this query?

Hi Chris
Since a report type can depend on the values of up to six other columns, and not necessarily the same six between report types, I reckon pivot would make...
^{“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 3, 2010 at 2:39 am

#1201394
RE: ROW_NUMBER() OVER (ORDER BY ) is very slow with large dataset

Have a look through Paul White's excellent server-side paging articles. They describe your problem and how to get around it.
http://www.sqlservercentral.com/articles/paging/69892/%5B/url%5D
^{“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 3, 2010 at 2:20 am

#1201392
RE: Are the posted questions getting worse?

Gianluca Sartori (8/2/2010)
BTW, my hourly rate is around 11 euros (14 dollars).
That's shocking. Why so low? What's the going rate for a dba in your area?
I've just Jobserved 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

August 2, 2010 at 6:44 am

#1200965
RE: Help in Aggregating columns

A little formatting goes a long way:
SELECT TOP (100) PERCENT
(SELECT DISTINCT dbo.tbl_ProductCategories.Description
FROM dbo.tbl_Product
INNER JOIN dbo.tbl_ProductCategories ON dbo.tbl_Product.FK_CategoryId = dbo.tbl_ProductCategories.CategoryId
WHERE (dbo.tbl_Product.ProductId = @ProductId)) AS Category,
Medium,
Brand,
SUM(CASE d .[Month]...
^{“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

July 30, 2010 at 7:58 am

#1200341
RE: LIKE operator with millions of records giving slow performance

Raj Deep Alapati (7/30/2010)
I just read this article.. any ideas if it can help me
http://www.sqlservercentral.com/Forums/Topic669022-338-1.aspx#bm669714
Thanks
Raj Deep
The article you've linked to points out that a LIKE comparison can be optimised if...
^{“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

July 30, 2010 at 6:28 am

#1200245

Viewing 15 posts - 7,576 through 7,590 (of 10,143 total)