Jeff Moden

Forum Replies Created

Viewing 15 posts - 5,461 through 5,475 (of 59,089 total)

Reply To: Better Practices for writing this query?
DaveBriCam wrote:
How do I integrate your
CROSS APPLY dbo.itvfGetSeconds(Call_Time) ctsec CROSS APPLY dbo.itvfGetSeconds(Talk_Time) ttsec
code with the needed code below?:
```
FROM a2wh.dbo.CallLogCommon com with (NOLOCK)
JOIN a2wh.dbo.Campaigns ud with (NOLOCK)
ON com.[campaign]...
```
--Jeff Moden
RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
First step towards the paradigm shift of writing Set Based code:
________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.
Change is inevitable... Change for the better is not.
Helpful Links:
How to post code problems
How to Post Performance Problems
Create a Tally Function (fnTally)
March 30, 2021 at 3:23 pm

#3863647
Reply To: how to improve the remote scan and remote query performance

Another thing is, what is the allowable latency for the data? Does it actually have to be up-to-the-second accurate or is it something that you can download once overnight and...
--Jeff Moden
RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
First step towards the paradigm shift of writing Set Based code:
________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.
Change is inevitable... Change for the better is not.
Helpful Links:
How to post code problems
How to Post Performance Problems
Create a Tally Function (fnTally)

March 30, 2021 at 1:29 pm

#3863590
Reply To: How to ALTER COLUMN without SELECT and UPDATE permissions

Thanks for the observations you made on this, Pete. It might be worthy of a new "Feedback" item as a "bug".
And, yeah... I can see people doing this... there have...
--Jeff Moden
RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
First step towards the paradigm shift of writing Set Based code:
________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.
Change is inevitable... Change for the better is not.
Helpful Links:
How to post code problems
How to Post Performance Problems
Create a Tally Function (fnTally)

March 30, 2021 at 1:25 pm

#3863589
Reply To: DATEDIFF() for times over a day long

I agree. Validating dates and times from possibly free-form sources is a real pita, especially in the presence of only "implied" specs. The OP never stated if the inputs always...
--Jeff Moden
RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
First step towards the paradigm shift of writing Set Based code:
________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.
Change is inevitable... Change for the better is not.
Helpful Links:
How to post code problems
How to Post Performance Problems
Create a Tally Function (fnTally)

March 30, 2021 at 1:03 pm

#3863587
Reply To: DATEDIFF() for times over a day long

The problem is, that's not a function. That's a script. Convert it to a function while I'm writing a similar one. 😀
And you seem to be saying that 'SELECT *...
--Jeff Moden
RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
First step towards the paradigm shift of writing Set Based code:
________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.
Change is inevitable... Change for the better is not.
Helpful Links:
How to post code problems
How to Post Performance Problems
Create a Tally Function (fnTally)

March 30, 2021 at 3:53 am

#3863474
Reply To: Better Practices for writing this query?

Ok... the premise of this thread is that we want to use "Better Practices". 😀 We not only want good code, but we want it to be simple and a...
--Jeff Moden
RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
First step towards the paradigm shift of writing Set Based code:
________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.
Change is inevitable... Change for the better is not.
Helpful Links:
How to post code problems
How to Post Performance Problems
Create a Tally Function (fnTally)

March 30, 2021 at 2:39 am

#3863459
Reply To: Better Practices for writing this query?
Dave,
I'm a bit confused by the functionality you express in your code. You're subtracting Talk_Time from the Call_Time. Perhaps things have changed a bit but, IIRC, Talk_Time is the duration...
- This reply was modified 5 years, 4 months ago by Jeff Moden. Reason: Added a revelation on my part as an additional clarification question
--Jeff Moden
RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
First step towards the paradigm shift of writing Set Based code:
________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.
Change is inevitable... Change for the better is not.
Helpful Links:
How to post code problems
How to Post Performance Problems
Create a Tally Function (fnTally)
March 29, 2021 at 9:42 pm

#3863393
Reply To: Better Practices for writing this query?

Judging by the way it's being used, the dbo.fnGetSeconds function appears to be a scalar function. That's really not a good thing. If you would post the complete code for...
--Jeff Moden
RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
First step towards the paradigm shift of writing Set Based code:
________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.
Change is inevitable... Change for the better is not.
Helpful Links:
How to post code problems
How to Post Performance Problems
Create a Tally Function (fnTally)

March 29, 2021 at 5:50 pm

#3863326
Reply To: There and back again: From a partition number to a filegroup and vice versa

Let us know how that PR works out, George. I've got a bunch of places where I found errors, need better examples, or is missing information. I've frequently been seriously...
--Jeff Moden
RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
First step towards the paradigm shift of writing Set Based code:
________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.
Change is inevitable... Change for the better is not.
Helpful Links:
How to post code problems
How to Post Performance Problems
Create a Tally Function (fnTally)

March 29, 2021 at 4:51 pm

#3863304
Reply To: DATEDIFF() for times over a day long

I still concern myself with such things because it doesn't make sense to use something that's known to be slower when there's something easy you can do to avoid the...
--Jeff Moden
RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
First step towards the paradigm shift of writing Set Based code:
________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.
Change is inevitable... Change for the better is not.
Helpful Links:
How to post code problems
How to Post Performance Problems
Create a Tally Function (fnTally)

March 29, 2021 at 4:43 pm

#3863302
Reply To: DATEDIFF() for times over a day long

ScottPletcher wrote:
Don't worry about ms, just use seconds. A few ms diff could be caused by almost anything is and not significant for an SSIS package.
I have to strongly disagree...
--Jeff Moden
RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
First step towards the paradigm shift of writing Set Based code:
________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.
Change is inevitable... Change for the better is not.
Helpful Links:
How to post code problems
How to Post Performance Problems
Create a Tally Function (fnTally)

March 29, 2021 at 5:17 am

#3863089
Reply To: DATEDIFF() for times over a day long

As a bit of a sidebar, Sergiy posted while I was working on mine. That's about the same kind of simplicity that I built into mine because you can, as...
--Jeff Moden
RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
First step towards the paradigm shift of writing Set Based code:
________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.
Change is inevitable... Change for the better is not.
Helpful Links:
How to post code problems
How to Post Performance Problems
Create a Tally Function (fnTally)

March 29, 2021 at 3:32 am

#3863067
Reply To: DATEDIFF() for times over a day long
Thought I'd toss my hat into the ring. Details are where they should be... in the code. 😀 It also tolerates leading, embedded, and trailing spaces, which is a frequent...
- This reply was modified 5 years, 4 months ago by Jeff Moden. Reason: Added a couple more important notes
--Jeff Moden
RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
First step towards the paradigm shift of writing Set Based code:
________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.
Change is inevitable... Change for the better is not.
Helpful Links:
How to post code problems
How to Post Performance Problems
Create a Tally Function (fnTally)
March 29, 2021 at 2:56 am

#3863063
Reply To: How to get spare no from categories 1 table where not exist per same spare no on

There are several methods for doing this. Steve Collins has correctly identified what most people identify as the "Best Method" and it frequently is.
There are 3 methods that I'll try...
--Jeff Moden
RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
First step towards the paradigm shift of writing Set Based code:
________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.
Change is inevitable... Change for the better is not.
Helpful Links:
How to post code problems
How to Post Performance Problems
Create a Tally Function (fnTally)

March 28, 2021 at 9:44 pm

#3863023
Reply To: DATEDIFF() for times over a day long

Please see the following article for calculating durations. It's really simple to do when you understand the hidden powers of the DATETIME datatype. Heh... you may never use DATEDIFF() to...
--Jeff Moden
RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
First step towards the paradigm shift of writing Set Based code:
________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.
Change is inevitable... Change for the better is not.
Helpful Links:
How to post code problems
How to Post Performance Problems
Create a Tally Function (fnTally)

March 28, 2021 at 6:35 pm

#3862994

Viewing 15 posts - 5,461 through 5,475 (of 59,089 total)