network profile
| bio | website | ienablemuch.com |
|---|---|---|
| location | ||
| age | ||
| visits | member for | 1 year |
| seen | May 27 '12 at 3:18 | |
| stats | profile views | 2 |
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 |
