Viewing 15 posts - 241 through 255 (of 263 total)
Yes, I have - but now I'm not so sure I understand how the ports are working in this, firstly here is my routing list: (I've sanitised the servers names...
June 23, 2015 at 2:24 am
Cheers Grant! I am getting spurious results anyway, it seems waitfor delay doesnt count as a long running query!
June 12, 2015 at 3:02 am
Resolved!
IF EXISTS(SELECT * FROM sys.server_event_sessions WHERE name='long_running_queries')
DROP EVENT SESSION long_running_queries ON SERVER
GO
-- Create Event
CREATE EVENT SESSION long_running_queries
ON SERVER
-- Add event to capture event
ADD EVENT sqlserver.sql_statement_completed
(
ACTION (sqlserver.sql_text, sqlserver.tsql_stack)
WHERE duration > 2000...
June 11, 2015 at 8:21 am
Brilliant Cheers!
I've now changed it to use and return a date type instead.
Though I now get this error?
Warning: Range value list for partition function 'pfnWeatherEventsByYear' is not sorted by value....
June 4, 2015 at 10:43 am
Aye, Lowell thats currently how its being done.
But for exceptions its not so easy or clear to see whats what.. I'm really looking for a high level overall that yu...
June 3, 2015 at 1:37 pm
Brilliant, cheers Jason!
So, for Lag and Lead to work as 'expected' - I should leave the default sort order in place, realistically?
May 26, 2015 at 2:37 pm
Awesome reply, Alan... Cheers!
I need to re-read it a few times!
May 26, 2015 at 2:35 pm
Morning
I've just tried to add in the lag function to the above query (reposted below) because I want to add the previous pay rate per user to the report, so...
May 26, 2015 at 5:27 am
It's the "FOLLOWNG" portion that's a bit of a head-trip for me, right now!
May 26, 2015 at 2:37 am
Yes, I've got Kindle copies of High Performance Windows Functions and Expert TSQL Windows Functions.
Am I correct in thinking that the Window Frame portion is the part of the call...
May 25, 2015 at 6:18 pm
My question can be disregarded 🙂
"As of January 1st, 2015, Prometric no longer delivers Microsoft certification exams."
So, that answers that!
Cheers
Alex
May 1, 2015 at 5:08 am
New thread: "amusing tombstone captions for DBAs"
January 30, 2015 at 9:48 am
Gah! Another place with too many PM's
That's a PM per developer - that's madness!
Try and justify a DBA per server - same thing! Would never happen.
January 30, 2015 at 9:44 am
rwaring, I would agree 100%
I've not been in this industry as long as you, probably half as long but I can relate, completely.
I too have given people an unedited version...
January 30, 2015 at 7:47 am
Viewing 15 posts - 241 through 255 (of 263 total)