Viewing 15 posts - 1 through 15 (of 77 total)
Could you add in a join against sys.dm_exec_requests on plan_handle?
I think that would get you access to the session_id
July 18, 2011 at 8:07 am
Great article, made for a very informative read. Many thanks!
July 18, 2011 at 7:46 am
thanks, I'll check out the link.
May 7, 2009 at 11:14 am
select email from Member usr
inner join Messages msg
on usr.ID = msg.UserID
where msg.IsRead = 0
Ok, so I'm presuming that there is a UserID column in the member table and that it...
May 7, 2009 at 9:15 am
yeah... their site doesn't mention the 2008 tests anywhere that I can find, I can only see info for 2005. I guess I could just call them. *shrug*
April 27, 2009 at 1:33 pm
as a followup, where in the states can you even take the test? I used to go thru New Horizons but I cannot even find the test listed on...
April 27, 2009 at 11:36 am
definitely simpler than mine!
My brain shuts off at the most inconvenient times 🙁
April 16, 2009 at 8:20 pm
Thanks for the replies. I'll see if we can just get rid of it all.
March 3, 2009 at 9:51 am
sorry, I thought it was pretty universal that ... means too much stuff to bother typing out
plus I fixed a typo so it reads UPDATE instead of PDATE. It...
February 27, 2009 at 3:06 pm
I'll play with it some more, not giving me the breakout im looking for. I need to figure out how to return a different value for 'period' when grouping...
January 16, 2009 at 11:21 am
Actually it was a 'pound head on keyboard' solution. I needed to put the CATCH/TRY inside the 2nd while loop instead of the while loop inside the CATCH/TRY.
December 18, 2008 at 8:47 am
December 16, 2008 at 7:35 am
if you have any code samples for those login triggers, that would be a good starting place I think.
August 7, 2008 at 12:34 pm
June 20, 2008 at 8:19 am
I cobbled this together from an example but it doesn't give me the right -4.16
I have to account for the negative numbers and I hate doing math in SQL.
June 19, 2008 at 12:57 pm