Ray access

i have table in sql server inherited legacy system thats still in production structured according code below. created sp query table described in code below table create statement. issue that, sporadically, calls .net sp both through enterprise library 4 , through datareader object slow. sp called through loop structure in data layer specifies params go sp purpose of populating user objects. it's important mention slow call not take place on every pass loop structure. fine of day or more, , start presenting makes extremely hard debug. the table in question contains 5 million rows. calls slow, instance, take long 10 seconds, while calls fast take 0 10 milliseconds on average. checked locking/blocking transactions during slow calls, none found. created custom performance counters in data layer monitor call times. essentially, when performance bad, it's bad 1 call. when it's good, it's good. i've been able recreate issue on few different developer mach...

i have div id="a" may have number of classes attached it, several groups. each group has specific prefix. in javascript, don't know class group on div. want able clear classes given prefix , add new one. if want remove of classes begin "bg", how do that? this, works: $("#a").removeclass("bg*"); with jquery, actual dom element @ index zero, should work $('#a')[0].classname = $('#a')[0].classname.replace(/\bbg.*?\b/g, '');

if create index on columns (a, b, c), in order, understanding database able use if search on (a), or (a , b), or (a , b , c), not if search on (b), or (c), or (b , c). correct? there 3 index-based access methods oracle can use when predicate placed on non-leading column of index. i) index skip-scan: http://download.oracle.com/docs/cd/b19306_01/server.102/b14211/optimops.htm#pfgrf10105 ii) fast full index scan: http://download.oracle.com/docs/cd/b19306_01/server.102/b14211/optimops.htm#i52044 iii) index full scan: http://download.oracle.com/docs/cd/b19306_01/server.102/b14211/optimops.htm#i82107 i've seen fast full index scan "in wild", possible.

about 5 years ago wrote touch screen kiosk application in visual studio 2005 (.net 2.0) embedded flash activex movie in it, ran flash application written in flash 6. fast forward present , i've been tasked upgrading our kiosk platform allow video conferencing. requires communicating external application through window messages handles video call , shows incoming video overlaid image. however i've run several (seemingly conflicting) problems getting old visual studio 2005 project run on computer today, under windows 7 , visual studio 2010. attempt 1: windows 7, visual studio 2010, flash 10.1 activex installed begin checked old solution out of svn , loaded visual studio 2010, using upgrade wizard. when run project following exception: system.runtime.interopservices.comexception unhandled message=class not registered (exception hresult: 0x80040154 (regdb_e_classnotreg)) source=system.windows.forms errorcode=-2147221164 stacktrace: @ system.windows.forms...

when press f5 in visual studio 2008, want google chrome launched browser asp.net app runs in. may know how can done? right click on .aspx file , click "browse with..." select chrome , click "set default." can select more 1 browser in list if want. there's great wovs default browser switcher visual studio extension .

how can find location of specific character in nsstring? i have tried returns empty range (i want find location of '?'): nsrange range = [@"this ? test see if works" rangeofcharacterfromset:[nscharacterset charactersetwithcharactersinstring:@"?"]]; you must doing else wrong. because absolutely correct , returns {10, 1} . @ least on mac ;-)

given following assemblage of classes (contrived): public class school { [primarykey] public string name {get; set;} [set] public ilist<teacher> teachers {get; set;} public class teacher { [primarykey] public string name {get; set;} i'd have object hierarchy serialized single sheet of xlsx file, like school.name teacher.name waldorf college ms. briggs waldorf college mr. smith starfleet academy mr. spock starfleet academy mr. sulu starfleet academy mr. kirk i'd deserialize (sensible) modifications xlsx file, creating new copy of school, , associated teachers. does know of similar doesn't require touching openxml libraries much? thanks. you can use ado.net , linq. using ado.net create , alter excel file... <= first link found helps.