ChrisM@Work

Forum Replies Created

Viewing 15 posts - 5,881 through 5,895 (of 10,143 total)

RE: Query runs slow

pwalter83 (8/16/2012)
ChrisM@Work (8/16/2012)
Paul, have you tried these two yet?
WHERE MB.CREATE_DT > = DATEADD(HOUR,-14,GETDATE()-1) -- similar to DATEADD(D, 0, DATEDIFF(D, 1, GETDATE()))
WHERE MB.CREATE_DT > = DATEADD(HOUR,0,GETDATE()-1) -- similar to getdate()...
^{“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 16, 2012 at 9:23 am

#1526665
RE: Are the posted questions getting worse?

Hi folks, this evening I’m collecting Symba from here: http://www.tvaw.org.uk/Adoption.htm. We’ve met already, he’s awesome.
Not sure of the name though. Symba is a bit silly, it’s a misspelling of 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

August 16, 2012 at 9:13 am

#1526655
RE: Crazy Interviews

Earlier this year I had an interview for a gig right next to Swindon station, a dream forty-minute commute compared with the two hours each way I’d been on for...
^{“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 16, 2012 at 8:45 am

#1526639
RE: Query runs slow

Paul, have you tried these two yet?
WHERE MB.CREATE_DT > = DATEADD(HOUR,-14,GETDATE()-1) -- similar to DATEADD(D, 0, DATEDIFF(D, 1, GETDATE()))
WHERE MB.CREATE_DT > = DATEADD(HOUR,0,GETDATE()-1) -- similar to getdate() - 1
It's...
^{“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 16, 2012 at 8:24 am

#1526617
RE: UPDATE when the values are the same

GilaMonster (8/16/2012)
ChrisM@Work (8/16/2012)
but for a CI, there is so much activity associated with a value change that I'm surprised there's no check.
I suspect it's because of the level and point...
^{“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 16, 2012 at 8:06 am

#1526599
RE: How to escape the ^ symbol in the following function

Abu Dina (8/16/2012)
Sorry
select cleanstring from dbo.isfn_QBRemoveNonAlphaChars('Abu???////Dina')
Gives back AbuDina so no spaces insrted. 🙁
Here's something I knocked up over lunch, shouldn't take long to swap the tally table for Jeff's:
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 16, 2012 at 8:01 am

#1526597
RE: Query runs slow

pwalter83 (8/16/2012)
ChrisM@Work (8/16/2012)
pwalter83 (8/16/2012)
Hi,
The query I am working on runs very slow due to a piece of code -
CREATE_DT > = DATEADD(D, 0, DATEDIFF(D, 0, GETDATE())) -1
Could someone please...
^{“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 16, 2012 at 7:37 am

#1526577
RE: UPDATE when the values are the same

GilaMonster (8/16/2012)
Paul showed that for a heap (the only case in discussion here), the page is not dirtied and the update log record not written when an update occurs 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 16, 2012 at 7:15 am

#1526551
RE: UPDATE when the values are the same

Phil Parkin (8/16/2012)
I'd like to nominate this as a candidate for the 'esoteric thread of 2012' award 🙂
+1
The proofs are educational - but sooner or later someone's conclusions will be...
^{“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 16, 2012 at 6:50 am

#1526533
RE: ssrs doubts

asranantha (8/16/2012)
1)a ssrs reports has multiple parameters the reports works fine when opened from visual studio but,fails when all parameters values are selected on a broweser,
what could be the reason?
Please...
^{“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 16, 2012 at 6:28 am

#1526522
RE: How do I run subqueries on a dataset?

Something like this:
SELECT
Company,
AVG_MatchedToSent = AVG(DATEDIFF(hour,Matched_Date, Sent_Date))
FROM YourTable
GROUP BY Company
^{“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 16, 2012 at 6:25 am

#1526519
RE: Query runs slow

pwalter83 (8/16/2012)
Hi,
The query I am working on runs very slow due to a piece of code -
CREATE_DT > = DATEADD(D, 0, DATEDIFF(D, 0, GETDATE())) -1
Could someone please suggest an...
^{“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 16, 2012 at 6:20 am

#1526514
RE: sql query logics

asranantha (8/16/2012)
hi friends i have a small doubt in sql plz tell me how to solve this task
Hi
You've posted four or five similar questions and as Gail has already pointed...
^{“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 16, 2012 at 5:46 am

#1526498
RE: How do I run subqueries on a dataset?

Hi Don, I can't help with the SSRS issue - however, if you were to choose to do the aggregation and calculations in a query, then I could certainly help...
^{“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 16, 2012 at 5:27 am

#1526493
RE: How do I run subqueries on a dataset?

Hi Don
What are you grouping by, in order to use the aggregate operator AVG() in the original query containing this subquery?
^{“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 16, 2012 at 3:36 am

#1526426

Viewing 15 posts - 5,881 through 5,895 (of 10,143 total)