InstantForum.NET v2.9.0SQLServerCentralhttp://www.sqlservercentral.com/Forums/notifications@sqlservercentral.comMon, 17 Jun 2013 23:41:12 GMT20http://www.sqlservercentral.com/Forums/Topic981376-360-1.aspx[quote][b]Madhivanan-208264 (9/8/2010)[/b][hr]The avatar you used is very goodAre you a designer too? :-)[/quote]No... someone else did most of the work. I just overlaid the word "RBAR" and converted it to a GIF.Wed, 08 Sep 2010 05:17:25 GMTJeff Modenhttp://www.sqlservercentral.com/Forums/Topic981376-360-1.aspx[quote][b]Jeff Moden (9/7/2010)[/b][hr][quote][b]Madhivanan-208264 (9/7/2010)[/b][hr]Have a million row table and do running total using a triangular join[code="plain"]select col,(select sum(col) from table as t1 where t1.pkcol<=t2.pkcol) as run_sumfrom table as t2[/code][/quote]Heh... ya beat me to it, Madhivanan.[/quote]Yes. Thats the good example that I know which takes lot of time.The avatar you used is very goodAre you a designer too? :-)Wed, 08 Sep 2010 01:23:05 GMTMadhivanan-208264http://www.sqlservercentral.com/Forums/Topic981376-360-1.aspxAlso force maxdop to 0 if your server isn't already set to it....a horrible, awful query like that should eat up every available core.Tue, 07 Sep 2010 15:35:30 GMTDerrick Smithhttp://www.sqlservercentral.com/Forums/Topic981376-360-1.aspx[quote][b]Madhivanan-208264 (9/7/2010)[/b][hr]Have a million row table and do running total using a triangular join[code="plain"]select col,(select sum(col) from table as t1 where t1.pkcol<=t2.pkcol) as run_sumfrom table as t2[/code][/quote]Heh... ya beat me to it, Madhivanan.Tue, 07 Sep 2010 15:20:29 GMTJeff Modenhttp://www.sqlservercentral.com/Forums/Topic981376-360-1.aspxHave a million row table and do running total using a triangular join[code="plain"]select col,(select sum(col) from table as t1 where t1.pkcol<=t2.pkcol) as run_sumfrom table as t2[/code]Tue, 07 Sep 2010 06:45:30 GMTMadhivanan-208264http://www.sqlservercentral.com/Forums/Topic981376-360-1.aspxErrrmmm... that's a requirement not seen very often... ;-)One option would be to create a c.u.r.s.o.r. on a rather large table (to "avoid" a set based operation).Inside the c.u.r.s.o.r.:Join a large number of (large) tables on predicates that are not supported by any index (to force a table scan). Take as many columns as you like and build a large comma delimited string. Insert results into a table variable and use a loop to split the string again by stepping through each character.Most important: make sure not to run it on a production system!Tue, 07 Sep 2010 02:48:44 GMTLutzMhttp://www.sqlservercentral.com/Forums/Topic981376-360-1.aspxHi All,I need sql queries or bad tsql code for producing high expensive resource utilization queries to test some performance reports. I ahve adventure works database in my environment. Please let me know as from where will I get high expensive queries for my testing..thanks in advance.Tue, 07 Sep 2010 01:30:06 GMTsejal p gudhka