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

7m
comment What is the "object" equivalent in SQL Server?
also in this case you could use varchar(1), varchar(max), char(1), char(10) -- but these will not match all types only strings.
8m
comment What is the "object" equivalent in SQL Server?
no such thing SQL is strongly typed. What are you trying to do?
11m
comment Any HTML tag parse in javascript only
possible duplicate of RegEx match open tags except XHTML self-contained tags
15h
comment How to properly emit and use class?
Vague questions get vague answers. Give us some real details and we can give some real answers. (If you don't want to show your code, maybe the UI where you build the object -- this might make clear what you are doing.)
2d
answered SQL Server If Null Return Everything
2d
revised SQL exclude all rows that with have certain value?
added 388 characters in body
2d
comment SQL exclude all rows that with have certain value?
@TTeeple I don't understand if plan is the same as the one you showed NOT EXISTS is doing an extra TOP 1 step. how is that the same?
2d
comment SQL exclude all rows that with have certain value?
@TTeeple not apples to apples -- the 2nd query does not do a distinct. Take the Distinct out of mine or add it to his. See mine is faster.
2d
comment SQL exclude all rows that with have certain value?
@dnoeth - you don't think indexes will have an effect on the plan?
2d
comment SQL exclude all rows that with have certain value?
@TTeeple - of course it depends on the platform. DB2 for example is much better with not exists, so I would try that too on that platform.
2d
comment SQL exclude all rows that with have certain value?
I like this trick.
2d
comment SQL exclude all rows that with have certain value?
@TTeeple - Basically the SQL server can optimize by looking for distinct values of order in another thread -- if [order] is an index it can order them while it checks for shipping and at the same time join back to the main table.
2d
comment SQL exclude all rows that with have certain value?
@ChristianBarron - Thanks. Welcome to Stackoverflow. If you think an answer is correct you should up-vote it. This carries even more weight than adding a comment.
2d
comment SQL exclude all rows that with have certain value?
@DanielE. I would expect NOT IN to be faster than NOT EXISTS
2d
answered SQL exclude all rows that with have certain value?
2d
comment IDENTITY and GetDate out of order
@Damien_The_Unbeliever - please make this an answer so I can up-vote it. You are clearly correct. It is the same as my comment Zohar but stated better.
2d
comment IDENTITY and GetDate out of order
Please be aware that both Damien_The_Unbeliever and @LasseV.Karlsen are using the term "race" and "race condition" to mean something very different than is typically meant when talking about "race conditions" in database systems. Race Conditions result in deadlocks or invalid data. Here the system is working correctly.
May
18
comment IDENTITY and GetDate out of order
@ZoharPeled - race condition means something different than the way you are using it here.
May
18
comment IDENTITY and GetDate out of order
@LasseV.Karlsen ZoharPeled Why not as simple as multi-thread, multi-core some thread/cores run faster between reserving the ID and retrieving the datetime and let it go at that?
May
18
comment Need help understanding why I'm required to use JSON.parse()
you probably need gameArray.data[counter] - can you show us the actual JSON content?
1 2 3 4 5