Jeff Moden

Forum Replies Created

Viewing 15 posts - 5,476 through 5,490 (of 59,101 total)

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, 7 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, 7 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
Reply To: How to ALTER COLUMN without SELECT and UPDATE permissions

It's an amazing thing... I've been working with SQL Server since before SQL Server 7 came out and it just dawned on me that I've never tried to alter 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 27, 2021 at 8:50 pm

#3862777
Reply To: SQL Server 2008 R2 Audit Log

veeramani-408723 wrote:
In my sql server instance I renamed 'sa' account and disabled. I confirmed no sa account. I configured server side audit log and I can see some sa activities....
--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 27, 2021 at 1:58 pm

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

Hi Pete,
This is interesting. I've never seen such a thing before. The reason for my question is I'm looking for something else that might be causing this problem for you. ...
--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 27, 2021 at 1:44 pm

#3862704

Viewing 15 posts - 5,476 through 5,490 (of 59,101 total)