Reputation
Next privilege 125 Rep.
Vote down
Badges
1
Impact
0 people reached

  • 0 posts edited
  • 0 helpful flags
  • 0 votes cast
Sep
24
awarded  Autobiographer
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