Hogan

New York, NY

Age: 49

25+ years...
ASM, C, C++, C#, VB, ASP.NET, TSQL +many more


The postings on this site are my own and don't necessarily represent IBM's positions, strategies or opinions.


Programmer, Architect, Team Lead, Director, CTO
MS Comp. Sci @ NYU '95
hoganlong at us.ibm.com // hoganlong at gmail.com


oh, and #SOreadytohelp, but you can see that just looking below.

5h
comment Diagnosing a SQL Server 2012 performance issue
@JeffShain interesting. So the database tells you this routine is causing the problem but you don't believe it. shrug
1d
comment Calculating daily growth using previous row value in new column - SQL Server
Here is a hint -- % growth is (CurValue - PriorValue / PriorValue) * 100 (so a db goes from 50gb to 75gb we say it had 50% growth or 75-50 = 25 / 50 = .5 * 100 = 50) . You have the way to find CurValue and PriorValue in my answer.
1d
comment Calculating daily growth using previous row value in new column - SQL Server
sure... you try first then I will show you.
1d
comment Calculating daily growth using previous row value in new column - SQL Server
@choloboy7 - see edit. But please try to understand... this LAG statement is not hard to understand.
1d
revised Calculating daily growth using previous row value in new column - SQL Server
added 41 characters in body
1d
answered Calculating daily growth using previous row value in new column - SQL Server
1d
comment Sybase: How do I concatenate rows in sybase column
@JuanCarlosOropeza - xml support and replace support exist in all modern db platforms. I don't know the details of sybase, so I didn't give an answer instead I made a comment.
1d
comment Sybase: How do I concatenate rows in sybase column
should work just like this: stackoverflow.com/a/1785923/215752
1d
answered Diagnosing a SQL Server 2012 performance issue
1d
comment Extract data from XML Clob using SQL from db2
PASSING XMLPARSE(DOCUMENT testclob) AS "d" could be simplified to testclob
1d
comment linq query with db2 xml column
IdInstanceTag - I like this name, is it an ID?, an Instance?, a Tag? No one knows.
1d
comment select parent_id who have at least one boy and one girl
@RamboLi did you get the job?
1d
comment select parent_id who have at least one boy and one girl
@TimSchmelter - I guess a WHERE child_gender IN ('M','F') would solve that.
1d
comment Linq to SQL Internal .NET Framework Data Provider error 1025
Why? EF has to translate from Linq to SQL. If you give it a construct it can't translate then it can't translate it. Replace the function with the return statement from your example.
2d
comment Using Current row value inside a function as a constant SQL
Your example does not make sense to me -- CURRENTAGE-PERSONAGE will always be 0 since you show above that CURRENTAGE and PERSONAGE are the same thing, unless you are joining these variables from another table or something?
2d
comment IBM DB2 Control Loop
@Lennart - he does say they won't take it out because it will break a feature -- still a strange feature to say the least.
2d
comment Linq to SQL Internal .NET Framework Data Provider error 1025
I'd say you can't use it in entity-framework then.
2d
answered Performance and scalability benefits of prepared queries in web applications?
2d
comment Linq to SQL Internal .NET Framework Data Provider error 1025
Yeah that still does not make sense. Are you trying to make an extension method? Then the syntax should be something like .Where(L => L.IsInDatesRange(startDate, endDate))
2d
comment Why is dba.stackexchange so...welcoming?
Not my experience at all. I was trying to understand a complex issue (which was never explained to my satisfaction) and was told " There's no reason to ask these types of questions here". I'm active on SO in DBA related questions and just had no interest in joining this community after that. In fact, if I could move my question back to SO I would. dba.stackexchange.com/questions/3307/…
1 2 3 4 5