ChrisM@Work

Forum Replies Created

Viewing 15 posts - 7,651 through 7,665 (of 10,143 total)

RE: Between Statment only for current day

jon pill (7/16/2010)
I am not a SQL expert just things I have picked up to do simple queries.
I don't know about connection pooling either, but I will read up on...
^{“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 16, 2010 at 7:28 am

#1194103
RE: CTE - Avoiding the cursor

Eugene Elutin (6/30/2010)
Actually, recursive CTE is not far from RBAR (can be even worse in performance)...
Not strictly true. A good example of RBAR would be performing a running totals update...
^{“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 16, 2010 at 7:22 am

#1194101
RE: Today's Random Word!

Paul White NZ (7/15/2010)
Paragordius tricuspidatus
(today's random worm)
Haven't done that for a while 🙂
Isn't nature wonderful? 😀
^{“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 16, 2010 at 2:37 am

#1193941
RE: Are the posted questions getting worse?

Paul White NZ (7/15/2010)
Jeff Moden (7/15/2010)
Can you good folks give me an example of when IDENTITY will not work?
When you need a sequence across several tables
When you need to pre-allocate...
^{“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 16, 2010 at 2:17 am

#1193926
RE: Between Statment only for current day

jon pill (7/15/2010)
I am running the query from Chris, it does not take long, not sure how long but I do notice some delay.
I keep the connection open at 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

July 15, 2010 at 9:23 am

#1193574
RE: Between Statment only for current day

How long does the query take to run?
^{“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 15, 2010 at 7:32 am

#1193474
RE: Nested CASE query issue

,CASE
WHEN DATEADD (year, 1, MAX(dd.ActualDate)) >= GETDATE() AND fo.Product IN (62,64) THEN 'Upgrade_Year'
WHEN DATEADD (month, 3, MAX(dd.ActualDate)) >= GETDATE() AND fo.Product IN (61,63) THEN 'Upgrade_3Months'
ELSE 'Upgrade_Basic'
END...
^{“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 15, 2010 at 7:24 am

#1193465
RE: SSIS date with a value as '-' should be inserted as null

itsaditi2001 (7/15/2010)
In an SSIS package I am using a Excel source with a date column, and some of the dates are hyphen . I want these hyphens to be treated...
^{“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 15, 2010 at 6:53 am

#1193445
RE: Between Statment only for current day

jon pill (7/15/2010)
drop table #TodayRecords
Is this the fastest way, i will have over a 100 lines and will be calling sql every 500ms?
Why would you want to run the code...
^{“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 15, 2010 at 6:42 am

#1193433
RE: Today's Random Word!

tosscrosby (7/14/2010)
OK, now we're getting somewhere. Do you have four or more of these symptoms?
Dyspnea
Palpitations
Chest pain or discomfort
Choking or smothering sensations
Vertigo or unsteady feelings...
^{“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 15, 2010 at 2:14 am

#1193295
RE: Between Statment only for current day

jon pill (7/14/2010)
There will be gaps but it matters little, i only need to get the data the same way every time
The same with duplicates, it wont affect the hi...
^{“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 14, 2010 at 10:18 am

#1192957
RE: Between Statment only for current day

jon pill (7/14/2010)
I have data that I want to find the Min and Max off, for 2 fields
Upvolume and DownVolume
Every day the Totaltrades field starts at zero and cumulates throughout...
^{“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 14, 2010 at 9:51 am

#1192934
RE: Between Statment only for current day

jon pill (7/14/2010)
you right that cant be it either
Describe it in words. Be nice!
^{“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 14, 2010 at 9:39 am

#1192919
RE: Between Statment only for current day

jon pill (7/14/2010)
SELECT min(upvolume),min(downvolume),min(upvolume),min(downvolume)
FROM
(SELECT upvolume,downvolume,TotalTrades from DBVaskVbid WITH (NOLOCK) where BarStamp >= '7/14/2010') as XDtable
WHERE TotalTrades
BETWEEN
(SELECT MAX(TotalTrades)FROM DBVaskVbid WITH (NOLOCK) where BarStamp >= '7/14/2010') -1000
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

July 14, 2010 at 8:23 am

#1192851
RE: Today's Random Word!

Exsanguination
"Come on in, the blood's lovely" attributed to a British MP entering a cabinet meeting of the last government.
^{“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 14, 2010 at 7:27 am

#1192797

Viewing 15 posts - 7,651 through 7,665 (of 10,143 total)