Recent content by benvegiard

There are a handful of such tables that have high ratio of inserts of data that may be inserted in the middle of the list, therefore they do not have clustered indexes on them. However, even tables w/clustered indexes can be "scanned" when the row-count is small. I kid you not. A MS engineer...

Using PerfMon, Profiler, and some other tools, I can see that Full Table Scans are popping off. However, I cannot find an easy way to determine WHICH queries are forcing these scans. My SQL2K db has about 1,900 procs in it! I am currently going through them based on things such as high...

Hi All... I have a proc that is fired off frequently (about twice a second) and am wrestling w/some tuning issues. I thought I'd get some community input! Following is the proc and my questions: Proc Parameters: (@UserID varchar(32), @OrgLinkID int) SELECT TOP 100 d.Consumer_Data_ID as...

Can anyone point me to an article or have any backing information on what the fastest control structure is in SQL Server? Here's my scenario, I am working on some performance tuning. A very common stored proc (fired about 50 - 100 times a minute) have a little over 200 if/thens to decide what...

(OK, picture Charlie Brown trying to kick the football, and Luzy keeps pulling it away…) Aaaaaaaaaaargh! I just can’t stand it! I’ve been fighting this for 3 days w/overtime! I need to update a project that uses a web-service for the middle tier. I am TRYING (in vein) to set up a copy of...

Hi there... I have written an engine to accept and pass parameters to a report that I wrote in VB.Net (.Net 1.1) However, reports written with Crystal 10 do not correctly pass the parameters. It simply reacts as if no parameters were passed. Has anyone else had experience with this and might...

I have a custom web control that contains a few text boxes and drop down lists and validators for these controls. I am validating good date/numeric data is being entered and that it is within tolerable ranges using custom validators. These validators are having to work with multiple controls...

Well, nuts. I had tried that and it didn't work, hence my confusion. However, since you confirmed it, I wrote up another test case and it worked. I must have typo'd myself on the first test. Thanks!

Is it possible to access native HTML elements from code-behind? I simply need to check values of a control during postback. Thanks, Ben

OK, for posterity, in trying different ideas… I turned SmartNavigation on and set the target browser to IE 5.0 and the behavior stopped. In my environment (intranet) I can get away with that. Thanks, Ben

Hi All.. I have used JavaScript to popup a modal window. On this window I have a report parameter input controls, a submit, and a cancel button. I'd like the Cancel button to close the window and return the user to the prior form. However, when the Cancel button is a ASP:Button running at...

Hi Al... I am writing some classes that will be re-used by other programmers, and I'd like to include summary descriptions for each Sub and Function and possibly some of the variables passed. I can find Attribute's for doing this at a class and property level, but when I add the...

OK, I have completely shut-down the ReportServer service and rebooted the machine just in case the service is continueing to run and simply reporting that it's not. The machine rebooted and I verified that the service is not running. However, reports are continuing to generate with new data...

I know... odd subject, but it got you to read the message, right? I am running RS on Win2003 and for many reports it's fine. I have a group of reports going through a couple of datasources that are acting odd, so I have been troubleshooting... During this troubleshooting, I have found that if...

Hey all... I'm not finding resolution to this. The client is running CR 7.x. On some machines, they can export to Adobe without any problems. On other machines, Adobe appears in the list of export options, but when selected, never requests as "save as" dialog and simply skips the printing...