101 reputation
bio website ienablemuch.com
location
age
visits member for 2 years, 2 months
seen May 27 '12 at 3:18

Hi, I'm Michael Buen. I love to study and implement enabling technologies.

I'm currently mastering AngularJS, ServiceStack, ServiceStack.Razor, ASP.NET MVC, Postgresql, Microsoft Sql Server, jQuery, XML, JSON, XSLT, LINQ, NHibernate, Entity Framework (Code First), Ninject, Moq

Microsoft stuff: http://www.ienablemuch.com/

Opensource stuff: http://www.anicehumble.com/

Twitter: http://twitter.com/ienablemuch

ienablemuch and anicehumble are anagrams of my name


Jun
19
comment Running total with count?
That is not good, that is very slow. Even you just have a 100 rows, it will do a ping-pong read between tables at 5,050 times. 200 rows, is 20,100 times. With 1,000 rows only, it jumps exponentially to 500,500 reads sqlblog.com/blogs/adam_machanic/archive/2006/07/12/…
Jun
19
comment Running total with count?
I made a comprehensive blog about running total (Quirky update vs Hybrid Recursive CTE vs Cursor): ienablemuch.com/2012/05/… I didn't include the running total that uses pure set-based approach, the performance is nothing to be desired: sqlblog.com/blogs/adam_machanic/archive/2006/07/12/…
Jun
19
comment Running total with count?
I made a comprehensive blog about running total (Quirky update vs Hybrid Recursive CTE vs Cursor): ienablemuch.com/2012/05/… I didn't include the running total that uses pure set-based approach, the performance is nothing to be desired: sqlblog.com/blogs/adam_machanic/archive/2006/07/12/…
May
2
comment Fast SQL query with * but extremely slow with specific columns?
This is the twilight zone of slow query problems. I hope this gets solved and share the cause of the problem