Breakpoint's Q&A profile

• SQL Server TOP 100 ordering of Data Question

  Hi, I was trying to use the UNION construct to combine two tables. The second table was to be sorted before effecting the UNION. The first attempt was the following: SELECT emp_id , assigned_branch_id FROM employee WHERE title = 'Teller' UNION SELECT open_emp_id , open_branch_id FROM account ORDER BY open_emp_id The above was generating an error. I then tried SELECT emp_id , assigned_branch_id FROM employee WHERE title = 'Teller' UNION SELECT e . open_emp_id , e . open_branch_id FROM ( SELECT TOP ( 100 ) PERCENT open_emp_id , open_branch_id FROM account ORDER BY open_e ...Show All

• SQL Server Impact of "Rows per batch" on OLE DB Destination?

  OLE DB Destination has a "Rows per batch" parameter. Are there best practices/guidelines around what it should be set to (for better performance etc) For example, if each row is of size 100 bytes, how does performance change when I set a batchsize of 0, 100, 1000, 10,000 etc I guess the default value for this parameter is zero. Does that mean, internally it is implemented as: For each row: begin transaction insert row commit transaction thanks, Nitesh   Nitesh Ambastha wrote: OLE DB Destination has a "Rows per batch" parameter. Are there best practices/guidelines around what it should be set to (for better p ...Show All

• Windows Forms Noob question about Composite Controls

  I am creating a simple composite control. It consists of a text box, and a picturebox. I've taken care of the code to make the picture and text do what I want them to, but I'd like to expose as many of the individual child control properties as possible. For example, if the developer wants to change the border type of the textbox or pict ...Show All

• Windows Forms ActiveX control issues

  i have an activex control developed in c++ (not managed c++) which is used in my windows forms application.  the purpose of developing it in c++ is mainly for performance point of view.  i have an experience in GDI+ and control development and what the said activex control does is just the same painting routines that i have been doing in .NET using the wrapper classes for graphics object, pens, brushes, etc. is there really a performance difference between using the said activex control in a .NET winform application, and having it ported into C# using the managed classes for GDI+ I think yes, GDI+ in .NET is generally fas ...Show All

• .NET Development Encrypting with UsernameToken - requires plain text password to decrypt?

  When you encrypt data with a UsernameToken, which has the password in digest form, does the encryption process require the plain text equivalent of the password to create the decryption key I can't find any documentation (WSE, OASIS standard) which explicitly states this. I would have thought this to be the case, otherwise any (unauthorised) recipient of the message would be able to decrypt it. Ie. they look at the message, see that the body is encrypted, the <KeyInfo> element specifies the UsenameToken in the header, and the authorised recipient then figures out the decryption key using the digest of the passwor ...Show All

• Windows Forms Auto-updating applications - options?

  Hi, I was wondering if there are any other good solutions to auto-updating winforms applications out there. I can not use ClickOnce as I need to register COM components, need access to all system ressources, etc. Anyone knows of a good solution Thanks, Tom You don't need to register COM dlls in ClickOnce Deployment. ClickOnce has a great Registry Free COM interop support built in.. Look at the article by Dave Templin http://msdn.microsoft.com/msdnmag/issues/05/04/RegFreeCOM/ The article considers a VB6 COM DLL in the example.. but same can be applied to any COM dll. If you have other reas ...Show All

• SQL Server Express cannot convert different data types automaticly????

  I have a SQL Server 2000 database which works like a charm in my asp app. Joining tables by id columns which are of different data types (eg. int in one table and varchar in the other) is no problem with the SQL Server engine, but Native Client refuses to do so and hands me back an error. Even if columns have a slightly different collation (like Slovenian_CI_AS and SQL_Server_1250_CI_AS) SQL Express native client returns an ERROR !!! Is it possible that Native client cannot resolve this on its own Must I change the colattion and datatype on all my tables Please help!!!! Peca, developer from Serbia u ...Show All

• Visual Studio Express Editions Registration Benefits

  Where can I download the promissed e-books I can download the stockphotos, icons and two components, but not the promissed e-books. Does anybody else already got it I downloaded MicrosoftR Visual Basic 2005 Express Edition: Build a Program Now!, an e-book in PDF-format, from the Visual Studio 2005 Registration Benefits Portal that the "Thank you for registering" e-mail pointed to. If you tried that too but failed, you may have to install the special Microsoft File Transfer Manager first. ...Show All

• Software Development for Windows Vista Workflow instance version issues

  I was wondering what the best practis is for updating workflows in a live enviroment. Now during development I have noticed Serialization errors when building a new version of the workflow while having running workflows. It complains that "indexoutofbounds" when trying to featch the instance from the persistance service becouse there are more activities in the new version. How can i solve this You should use .NET assembly versioning to ensure that your published workflow models are identified as different by the CLR. Increment the version each time you publish an update. Any assemblies referenced ...Show All

• .NET Development Inability to Set WebRef In VS2K5 (completely) When WS not on port 80.

  Greetings from Austin, My I ask if this has happened to anyone else I have a WinForms app in vs2k5. In setting a webref, the uddi tool connects to the ws url and I can add the ref (partially) to the project. What is happening is at the point where the add web ref utility tries to get the contract from the ws endpoint, I get a dialog complaining that it cannot get the wsdl from http://myip/myws/myws.asmx when in actuality the uddi tool correctly discovered http://myip:83/myws/myws.asmx yet it now expects the wsdl to be available on http://myip/myws/myws.asmx wsdl The complaint is just an "ok only" dialog and there is no place t ...Show All

• Visual C++ Performance problems after porting to VS 2005 from 2003, native C++ code vs STL.

  After porting code from studio 7.1 to 8.0 beta 2, performance (function execution time) decreesed twice. In each two cases code was compiled with max speed optimisation. I tried each useful in my case compiler feature for increasing performance, and nothing helps, 7.1 still x2 faster. Code use basic STL tamplates such as vector, map, iterators, heap functions and nothing else. Please help to understand this fenomenal.     Thanks a lot Maks for taking the time to report the issue. I can see your bug link at http://lab.msdn.microsoft.com/productfeedback/viewfeedback.aspx feedbackid=f37af40 ...Show All

• Visual C# How to Add a Windows Service in VC#2005 Express Edition

  Hi Refer to my subject, thanks. The service application templates are not included in the Visual Studio Express products, but there is a workaround to allow you to use them. What I have done in the past is to load up the trial version of the Visual Studio System and create a base application from each template and then export them as templates. Then once inside the Express IDE I would then import the templates, from this point on I now have a windows Service template that I can use. If you do not have the trial you may be able to find someone to export the template for you. But, it are just templates, so this means you ca ...Show All

• Visual Studio 2008 (Pre-release) Why the reverse German-like syntax?

  Why do the LINQ queries have to look like a SQL query in German   If you are trying to make it easier and are adding SQL-like keywords to the language, at least keep the ordering the same as SQL. The way this is, I have to know C#, SQL for triggers and stored procedures, and LINQ for the in-code queries.  I don't see how this is going to make my life any easier. > .... why then has VB decided to do it the wrong way This would hardly be a first for VB and cannot be taken as a guide for what C# should do.  I am not on the team, and am not from MS, but what's clear to me is tha ...Show All

• Visual C++ simle form in c++

  CODE bool InitWindowApp(HINSTANCE instanceHandle, int Show); int Run(); LRESULT CALLBACK WndProc(HWND hWnd, UINT msg, WPARAM wParam, LPARAM lParam); int WINAPI WinMain(HINSTANCE hInstance, HINSTANCE hPrevInstance, PSTR pCmdLine, int nShowCmd) { if(!InitWindowApp(hInstance, nShowCmd)) { ::MessageBox(0, "Failed to create Window!", "Fail", MB_OK); return 0; } } bool InitWindowApp(HINSTANCE instanceHandle, int Show) { WNDCLASS wc; wc.style = CS_HREDRAW | CS_VREDRAW; wc.lpfnWndProc = WndProc; wc.cbClsExtra = 0; wc.cbWndExtra = 0; wc.hInstance = instanceHandle; wc.hIcon = ::LoadIcon(0, IDI_APPLICATION); wc ...Show All

• SQL Server Failed install of SQL Server 2005 Developer Edition on Win XP Pro

  I've tried installing SQL Server 2005 Developer Edition 3 times now, from 2 different CDs. I keep failing with the same error message: "SQL Server Setup Failed to compile the Managed Object Format (MOF) file C:\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\Binn\etwcls.mof. To proceed, see "Troubleshooting an Installation of SQL Server 2005" or "How to: View SQL Server 2005 Setup Log Files" in SQL Server 2005 Setup Help documentation." This is the bottom of the SQLSetup0001_<machine name>_SQL.log Doing Action: Do_sqlMofcomp PerfTime Start: Do_sqlMofcomp : Fri Jan 27 14 ...Show All