ScratchMonkey's Q&A profile
SQL Server increase the speed of the report
Hello, I am working on a report in SQL Server Reporting Services 2000. [CODE] SELECT TOP 200 * FROM necc.dbo.vw_rop_report_profit_per_call WHERE [Call Day] = case when @callDate = '' then [Call Day] else @callDate end [/CODE] >> I have apromt for the user to enter the date. >> If the user does not enter any date, then the report will show all the first 200 records. >> This query is running too slow. To increase the speed of the report , could somebody help me build the where clause only when something is in the filters Thank you, This should do what you want: SELECT TOP 200 * FROM necc.dbo. ...Show All
Visual C++ Strsafe.h or .NET String class
Hello there I am building an application that needs alot of string parsing. I need to know which is better for the performance and security point of view: the strsafe.h functions or the methods of the .NET String class Yes they will be slower. But there is nothing I can say, how much they ae slower. It depends strongly what you are doing. Compared to a unicode string buffer, were I have direct access through a pointer and do some parsing, checking and extracting I had differences up to 100% (functions is finding parts of substring and soundlike checks with recursive functionality like wildcards). In this case the stre ...Show All
Visual Basic Controls Flickering when drawed on the form
Hello there :) This was a Problem in Visual Basic 2003 when having a Form with about 150 Controls the form simply consists of panels and those panels have Labels and controls beside hem the form itself has a background picture ,,, the Panels also have backimages the Problem is when the form is shown the controls are being drawn really slow ... (the form is 1024*768) that wasn't a Problem at all back in VB6 anyway I saw that Visual Basic 2005 has a New Future called DoubleBuffered but it isn't doing any difference at all ... what are your Suggestions :) Thank you very much in Advance ! NGen.exe will create a n ...Show All
Windows Forms Properly drawing C# user controls?
[Ported from a post in the C# forum by Moogy...] I have created two usercontrols; one is a panel that has a gradient background, and another is a 'header' control that merges icon and border graphics - they look great. The problem is the order of painting. Right now, when the control is resized, I get a nasty flicker with my 'Header" control (not the panel control). I am curious, what's the best way to properly process the painting of user controls in VS 2005 and C# It's been awhile since I've done this... Thanks! You can turn on double-buffering: DoubleBuffered = true ; ...Show All
Visual Studio 2008 (Pre-release) Error Help
System.InvalidOperationException: Could not find endpoint element with name WSHt tpEndpoint and contract TrackingApplicationClient.Program+IServiceSession, Track ingApplicationClient, Version=1.0.0.0, Culture=neutral, PublicKeyToken=null in t he ServiceModel client configuration section. What's causing this Your client's app.config doesn't seem to contain a configuration element in the <client> section that properly maps to your proxy/channelfactory type. See http://windowssdk.msdn.microsoft.com/library/en-us/WCF_genref/html/bf0f7031-76c8-4e7e-a6c6-9ad9119134be.asp ...Show All
SQL Server Combining text data rows
I am working with a database derived from text documents. One of the tables (TEXT001) contains the text of the documents with each paragraph of each document assigned to its own row with a paragraph number in a SectionNo column. I want the entire text of each document in a single row with its own unique number (so that I can do a full text search with SQL Server 2005 that will search and return the entire document as a result). How do I combine the rows with the same DocumentID into a single row of text data This will put the entire text content of each document in its own row. TEXT001 table as it is Documen ...Show All
Visual Basic collection ?
public module m1 property p1 propety p2 propety p3 end module public class c1 dim l1 as new list(of object) sub main l1.add(m1.p1) l1.add(m1.p2) l1.add(m1.p3) for each obj as object ...Show All
Visual C# Can anyone solved this problem with Shockwave Player?
Hi..alll. please see this problem on Visual Studio.net 2005 does anyone know the solutions..: http://lab.msdn.microsoft.com/productfeedback/viewfeedback.aspx feedbackid=94b4aaf8-95de-4d45-9f37-58099fbffabf Best Regards.. sorry i didnt understand the users fix. .Can you tell me how i can solve the problem..or tell me if you have solutoins of you own.. thanks.. ...Show All
Visual C++ Slow mixed assembly performance... Why?
Hi, I wrote a program in Visual Studio 2005b2 (Winforms), but include many of my image processing algoritms written in unmanaged c++. These functions use SSE2, and array manipulations. However, compiling my new program (.Net) resulted in very poor performance, where the execution is so slow, compared to the same code when compiled in MFC. Why is that I'm aware that .Net compiler generates MSIL, and it is compiled to native code on the fly during execution. Most articles online says that .Net code is slightly slower than pure code, but eventually the performance difference is too small to be noticed. In my case, the performance difference is ...Show All
Visual Studio Load dynanicallt images
I have a tabe that contains the name of images ex: image1.gif etc, all pictures are in the same folder, and they can be reached also with URL like http://ImageServer/Folder/image1.gif . how can I add this image to my report. any help would be greatly appreciate. I Found the solution. in case that someone would be interested i changed the Value of the image control to something like: =" http://Myserver.com/images/ " + First(Fields!programlogo.Value, "Mydataset") ...Show All
Windows Forms Ctrl + Enter with a MenuStrip
Hi, I was following a tutorial to try to make my own browser interface. I tried to implement the Ctrl+Enter in a Textbox to make like Internet Explorer to complete the address, eg. google => http:// www.google.com . The problem is that I cannot take the Ctrl+Enter keys event while I enable my MenuStrip (eg. File, Options, Help,....) as it makes the focus on the MenuStrip! When I "un-enable" or delete my MenuStrip, it works well. When try to replace the Control key by the Alt key, it works well too. There are no shortcuts keys in the MenuStrip. I tried with the e.Control and e.KeyValue = 17 items, but it stills makes the ...Show All
Visual Studio Express Editions Problems with using OpenGL with Visual C++
Hi, I'm new to OpenGL and want to use Visual C++ 2005 Express Edition (German) (running on Win XP SP2). I've already installed the PSDK and added the folders to the IDE's settings. But when I want to compile the source code of the second chapter of the Nehe OpenGL guide [ http://nehe.gamedev.net/data/lessons/vc/lesson02.zip ], the command line compiler says that it can't find "windef.h". What's going wrong now I really go bananas about this... :-) Thank you! denken Nehe probably uses MFC. Either way, you don't have the platform SDK, you need to install and set that up to run Windows ...Show All
Visual Studio Team System Unresolved Reference: Microsoft.Vbe.Interop
Hey, I'm working on a project that is in the process of being ported from VB6 to .NET. I've tried to run fxCop against the main .DLL (it's a web app) but I get an error message telling me that there is an unresolved reference to Microsoft.Vbe.Interop. Now, I have confirmed that this file does exist in C:\Windows\assembly\ and I've even verified that the version/public key that fxCop is expecting matches the assembly in the folder. However, fxCop will not allow me to select the file to be loaded, nor am I able to use Windows Explorer to copy the file to a local directory and point to it there. Am I completely missing something here Is it not ...Show All
Visual Studio Team System Code Analysis Policy Problem
I added "Code Analysis" policy type in to check-in policy and removed some rule from Code Analysis Policy Editor. Then I open my solution and click "Migrate Code Analysis Policy Settings to Solution". I saw all rule is enabled in Code Analysis of Project. I don't understand why "Migrate Code Analysis Policy Settings to Solution" does not remove some rule in project Eagle Tsui wrote: No body can help me I want to know this is a bug or by design. I think it's by design, but I'm not a big fan of this design. The Migrate function will only turn on rules in your project, it will never turn rules ...Show All
Software Development for Windows Vista Workflow Monitor Sample
I have downloaded the lasted WinFX sdk and Visual Studio workflow extensions but cannot find the Workflow Monitor Application. Is this application a separate download I am not seeing this either. Under C:\Program Files\Microsoft SDKs\WinFX\ there is no Application Samples directory. Regards, Chris ...Show All
