ChrisM@Work

Forum Replies Created

Viewing 15 posts - 7,291 through 7,305 (of 10,143 total)

RE: Improve performance--need help

What tool are you using to "download data"?
Can you post the query you are using?
^{“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

September 27, 2010 at 3:58 am

#1227592
RE: Are the posted questions getting worse?

Dave Ballantyne (9/27/2010)
Anyone else going to be at SqlBits this week, have to say ive still got no idea how i got onto the Friday (Well known Speaker ?!?!)...
^{“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

September 27, 2010 at 2:45 am

#1227568
RE: Today's Random Word!

CirquedeSQLeil (9/24/2010)
Glory
Mor... no better not.
Happy mornings!!
^{“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

September 24, 2010 at 9:26 am

#1227074
RE: Invalid length parameter passed to the SUBSTRING function.

vwilliams (9/24/2010)
I ran with the below script and got an error: Incorrect syntax near the keyword 'where'.
I am loving the change though.
[code="sql"
update ds_CleanNames
set clean_name1 = LEFT(clean_name1, CHARINDEX(' DBA...
^{“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

September 24, 2010 at 9:13 am

#1227057
RE: Today's Random Word!

rhinotillexo-freakin'-mania
^{“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

September 24, 2010 at 9:08 am

#1227053
RE: Invalid length parameter passed to the SUBSTRING function.

Thanks for clarification. Here's a little added value...
DROP TABLE #ds_CleanNames
CREATE TABLE #ds_CleanNames (clean_name1 VARCHAR(20), Clean_Extra_Name VARCHAR(20))
INSERT INTO #ds_CleanNames (clean_name1)
SELECT 'AB DBA CD' UNION ALL
SELECT 'AB DBA CD EF DBA...
^{“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

September 24, 2010 at 8:38 am

#1227024
RE: Trying to optimize performance of query having Hash Matches & Agreegate

Grant Fritchey (9/24/2010)
First off, nesting views frequently leads to performance problems. I recommend against it.
Especially when different levels of nesting have different sort criteria.
^{“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

September 24, 2010 at 8:25 am

#1227011
RE: Need help on TSQL

The Dixie Flatline (9/24/2010)
Hey, Chris started it. 😀
Ooh Bob you grass!
^{“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

September 24, 2010 at 7:13 am

#1226943
RE: Pre-Aggregated Tables - Weekly Inventory

DROP TABLE #LookupInv
CREATE TABLE #LookupInv
(
DateID int,
StyleCode varchar(23),
...
^{“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

September 24, 2010 at 7:09 am

#1226938
RE: Pre-Aggregated Tables - Weekly Inventory

Don't you want to sum the quantity over each partition?
^{“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

September 24, 2010 at 6:35 am

#1226907
RE: Need help on TSQL

The Dixie Flatline (9/24/2010)
Interestingly, Bob's query, while undeniably compact, still scans the source table twice.
You fail to ascertain that performance was not my primary design criterion. 😛
Bob, you could...
^{“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

September 24, 2010 at 6:29 am

#1226902
RE: Transcation does not execute

Of course, you could turn the query around and look at rows matching on orderid where the column values are the same:
SELECT sd.OrderID, sd.ProductID, sd.BookedDate, sd.LBooked_Date, sd.SLeadTime, sd.CustDel
FROM supplydates sc...
^{“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

September 24, 2010 at 6:04 am

#1226883
RE: Transcation does not execute

tt-615680 (9/24/2010)
Chris Morris-439714 (9/24/2010)
Have you tried following the steps recommended by Winash?
I have been trying to query the OR statements one at a time but it is still the same...
^{“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

September 24, 2010 at 6:01 am

#1226880
RE: Transcation does not execute

Have you tried following the steps recommended by Winash?
^{“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

September 24, 2010 at 5:28 am

#1226858
RE: Are the posted questions getting worse?

GilaMonster (9/24/2010)
Here's a photo taken in daylight.
Very gothic, reminds me of Reign of Fire.
^{“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

September 24, 2010 at 5:27 am

#1226856

Viewing 15 posts - 7,291 through 7,305 (of 10,143 total)