sqlfriends (10/19/2016)

---

I have a simple task to export a table to a flat file on network share.

so I schedules a sql agent job that does below:

sqlcmd -S myserver...

I'd have to see the original rows from your TEST table for this person. Is there a mismatch on the number of CLOCK_IN vs CLOCK_OUT entries for this person?

That must be a custom function you have locally, it's not part of SQL Server 2014. I don't know enough about it to understand what problem you are having...

OK, sorry for the delay in getting back to you, busy day at work today. If they can change shifts that would make it difficult to work with the...

I still do little things here or there in command line for automation purposes. I remember back in college though (early 90's), using Unix, I had one class that...

OK, I was unaware there were shifts that would cause the clock-in clock-out to potentially overlap the day boundary. Do you have a table that defines the shift start...

I think the problem may be in the way you're trying to do the UPDATE. See EXAMPLE A in:

https://msdn.microsoft.com/en-us/library/ms188427.aspx

basically the OPENQUERY should have a SELECT in it not an...

here's a quick example query based on the info you provided:

WITH Prep AS

(SELECT CAST(creation_date AS date) AS creation_date, CAST(creation_date AS time) AS creation_time, person_num, full_name, event_name,

ROW_NUMBER()...

sounds like you could use what's called cross-tab queries, such as presented by Jeff Moden:

http://www.sqlservercentral.com/articles/T-SQL/63681/

http://www.sqlservercentral.com/articles/Crosstab/65048/

Possible is all the nodes that are capable of running the SQL Server instance, preferred is the one node where you'd like it to be running under ideal conditions.

I think...

If they're trying to avoid UPDATEs where there is...

I believe the SQL Agent performance alerts are based on the same set that performance counters are.

some explanation of performance counters:

https://msdn.microsoft.com/en-us/library/ms190382.aspx

setting up performance alert:

https://msdn.microsoft.com/en-us/library/ms180982.aspx

I've seen this kind of behavior before when a SQL Agent job gets interrupted by something like a server reboot. You can usually find if that happened in the...

Paul Hernández (10/12/2016)

---

...I am designing a accumulating snapshot fact table...

the line managers estimate how many units they expected to be produced and then there are several process, in which some...

I'm sorry, I forgot this was a custom stored proc. It's basically doing the sp_foreachdb loop outside of the remote procedure call:

CREATE PROCEDURE dbo.sp_all_db_filespace AS

BEGIN

...