Hello,

Here is the situation.

• SQL 2019 enterprise on datacenter server
• agent is running
• test job has 1 line;   select getdate() or running a SPROC with the same line
• the...

If that's true, Happy Birthday, Steve!

Hi folks

I can't find anywhere else to ask this, so here it is. SQL Server 2017 Standard Edition is restricted to 24 cores. Does this mean that the licencing...

I guess what you’re asking for is the amount of space actually used by data pages within the space allocated to db files of your databases.

To...

Sorry, I just have to ask: why would logical file name(s_ need to be preserved?  Are they hard-coded in some existing statements?  That seems dangerous, what if files are...

Saints be praised.  I'm allowed up to a 15 minute outage at 9 tonight.  I couldn't use Scott's suggestion 100% because I can't have two files with the same logical...

Thanks to both of you.  I'll take a look.  I really appreciate it.

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]...

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...

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...

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...

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 *...

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...

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 ago by Jeff Moden. Reason: Added a revelation on my part as an additional clarification question

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...