DesNorton (10/12/2016)

---

Sergiy (10/12/2016)

---

Try this approach:

ALTER VIEW vSeedData

AS

SELECT RAND(CHECKSUM(NEWID())) Seed

GO

alter FUNCTION [GenerateRandomDateTime]

(

@MinimumDate DATETIME,

@MaximumDayDifference INT,

@MaximumSecondsFromMidnight INT

) RETURNS DATETIME

BEGIN

RETURN(SELECT TOP 1 DATEADD(DAY, Seed * ISNULL(@MaximumDayDifference, 365), @MinimumDate) + DATEADD(SECOND,...

Alaster07 (10/12/2016)

---

Based on the feedback in this thread, I have changed the SPs to UDFs and am using a view instead of calling the NEWID() and RAND() functions directly.

CREATE VIEW...

Alaster07 (10/12/2016)

---

When I attempt to use the function, it states "Only functions and some extended stored procedures can be executed from within a function." Is there an...

asita (10/12/2016)

---

Hello There,

I have a procedure that is scheduled to run on sql server and some adhoc code that I am executing,

both is kind of same logic but diferent purpose,...

To do it all in one query you may use GROUP BY ... WITH ROLLUP.

In the row with GROUPING(Column1) = 1 you concatenate COUNT(*) , GETDATE() and whatever else you...

Yuri55 (10/11/2016)

---

No blocking- checked. For some reason this process (as per sys.sysprocesses) has SOS_SCHEDULER_YEILD wait, i.e. allows other processes to use scheduler thread (but waiting itself). May be this wait...

MickyD (9/15/2016)

---

Hi everyone.

I recently came across a dev database in our organization that had no clustered indexes and circa 100 million row.....:crazy:

In order to rectify I need some advice on...

On Prod there must be some concurrent activity which is surely absent in DEV.

Did you check for blocking?

You may add ROW_NUMBER to the recordset being inserted and add its values to MAX (ID ) of the table:

begin transaction

declare @MaxID bigint

select @MaxID + MAX(ID) From TargetTable (TABLOCKX)

INSERT INTO...

For a job scheduled to start on 23:59 this condition will never...

valeryk2000 (10/7/2016)

---

If you are still interested (e.g. in health system) - I spoke with our nurses: they are interested in cases when the second admission for the same problem ends...

Chrissy321 (10/10/2016)

---

My use case is I have daily jobs that are scheduled to run at a specific time. I want to alert when a job did not run. I thought...

That's right.

If you want to display...

Matt Miller (#4) (10/5/2016)

---

Sergiy (10/5/2016)

---

Matt Miller (#4)

Don't forget to incorporate the "sliding window" into your production version of this. In other words - if you're trying to capture all...

How about not splitting date and time for StartDateTime?

😀