Kris R's Q&A profile

• SQL Server Exceedingly long update on large tables - why?

  We have a simple UPDATE query, joining two tables, that takes much longer than 10 hours to run, but if we break the table in six (10 million rows in each table), it takes only fifteen minutes to run each part. Why And how can we tell in advance whether a query will cross the threshold into l.o.n.g.r.u.n.n.i.n.g query Or, how can we prevent it The system is Windows XP Pro with 4GB RAM (/3GB switch), and SQL Server Standard 2005. Log files, swap files, dbf files are on separate drives. The system is dedicated to SQL Server. No other queries are running at the same time. The database is in Simple logging mode. Each table is a few GB with 60 ...Show All

• SQL Server How to Performing routine task on a database

  Hi, In my database application I need to do regular checks like compare a date and flag records, check the status of a column and send emails accordingly. some of these operations has to be performed everyday, some weekly etc. This database applciation is a windows applcaition (c# 1.1). What is the best practice for this sort of applcaition. Many thanks, -VJ Have you looked at SQL Server Notification Services   http://www.microsoft.com/sql/ns     -- Adam Machanic Pro SQL Server 2005, available now http://www..apress.com/book/bookDisplay.html ...Show All

• Software Development for Windows Vista Compiling DirectShow Samples with Visual Studio .Net 2005

  We've just purchased .Net 2005 and would like to compile the DirectShow BaseClasses supplied with the Platform SDK.  DirectShow documentation (in the on-line version of the MDSN library) states that there should be a .dsw file in the BaseClasses folder... but there is none. All we could find was a makefile.  Is there a way to create the project from a makefile   Help! haroonsarwar84 wrote: I am having the same problem.... In trying cpix's suggestion I downloaded the December 2004 edition of the DirectX SDK from a MS site...and extracted it's content......and unbelievably enough there is ...Show All

• Windows Forms External component has thrown an exception

  Hi, I'm getting this error really sporadically in my Winforms app. Seems to happen when trying to display a form with a call to .ShowDialog(). It doesn't seem to happen on any particular form, just pops up now & again. I can close the application and restart it, then I can view the form without the error The application is running in a Citrix terminal server environment, the assemblies themselves are running from a network share. Can anyone think of what would be causing this error - why is it only happening every now & then (the worst sort of errors!). One post mentions a faulty network connection to blame, but our network ...Show All

• Windows Forms DateTimePicker Events don't fire

  VS 2005 Beta2: I like the DateTimePicker, but it seems the events don't fire, neither click, doubleclick, mouseclick, mousedoubleclick seem to fire. Are these events not yet implemented, does one need to click at a particular location or do I do anything else wrong Thanks - Thomas Joe, thanks for the confirmation - yes, mouseUp and Down work and I will use it as a workaround. Your information that the other events won't be available in the final release is very helpful too. Thanks - Thomas ...Show All

• Visual Studio 2008 (Pre-release) Any way to create menus with columns?

  Is there a way to create columns in a menu dropdown (or context menu). I'm looking for some equivalent of <separator/> that forces column breaks instead of drawing a horizontal line. The native menuing system supports AppendMenu(... MF_MENUBARBREAK...). The application: a data-driven dropdown menu that can sometimes contain a lot of items.   You can change the panel for the menu to be a Grid and layout the elements in the grid any way you would like. In the Jan-Feb CTP there were some issues I hope are fixed in Beta 2. UniformGrid did work, but of course did not allow spanning. ...Show All

• SQL Server SQL Server 2005 Express - Upgrading will Lose Data?

  Hi - quick question. I wanted to upgrade pre-release version of SQL Express to the latest version, and wanted to make sure that none of the database information would be lost. The thing that concerns me is that it states to uninstall previous versions of SQL Server 2005 Express before installing the latest version. I threw the database tables into a backup directory, and I think this should be fine, but I want to be sure. Let me know. Thanks! Hi Matt, Version 1399 is the released version of SQL Server. If you want to update to SP1, you can do so by downloading the SP1 update from http://msdn.microsoft.com/vstudio/express/sql/ ...Show All

• .NET Development .NET Framework upgrade

  In advance, let me say that I am somewhat of a newbie... I am using Visual Studio 2005 Team Edition Beta 2 (2.050215.44).  I am trying use some proprietary components that require a a more recent .NET Framework (2.0.50727).  How do I find and upgrade to this version of .NET FRamework Thanks in advance. John H. Kaicher, M.D. The RTM framework (2.0.50727.42) can be found here: http://www.microsoft.com/downloads/details.aspx FamilyID=0856eacb-4362-4b0d-8edd-aab15c5e04f5&DisplayLang=en You may need to uninstall Beta components using this tool: http://msdn.microsoft.com/vstudio/sup ...Show All

• Visual C# Progress Bar

  I have a progress bar whereby it should progress for every graph that is loaded.But upon executing the program, the progress bar will immediately hit 100 % even the graph had not been fully loaded. But my code is written such that the PerformStep is placed after the loading of graph. Please advice. Thanks for ( int i = 1; i <= load_graph; i++) { parent_form.flowLayoutPanel2.Controls.Add( new TrendChart (a , root_source)); parent_form.progressBar1.TabIndex = 0; parent_form.progressBar1.Maximum = 10000; parent_form.progressBar1.Minimum = 1; parent_form.progressBar1.Step = 2500; parent_form.progressBar1.Pe ...Show All

• Visual Studio Tools for Office Repeating data in Word - how to?

  What would be the best method for displaying a list of header and detail rows in a word document I am not sure I understand the problem correctly, but you can look at this article that describes a method for addng repeating data in Word. http://msdn.microsoft.com/library/default.asp url=/library/en-us/odc_wd2003_ta/html/OfficeVSTO_WordToImportXML.asp ...Show All

• Visual C++ doubt regarding access specifiers

  Dear all, I have a doubt regarding access specifiers in C++. I have a class ABC let us say. In ABC I have two private member variables, and two public member functions. And I'm putting this class in a static library. To use that library, one should have the header file. So in the program, where I use that library if I change the class defenetion to have all public members will there be any harm Thanks and best regards, Raja Pratap. If all that you change is the access to the fields then the program should continue to run. In an executable fields are represented by an offset so there is no furt ...Show All

• Visual Studio Express Editions 3d games?

  Well. you know if I creat a 3D graphic, is it possible to "move" then render the graphic in real time with Visual Basic Express or are there easier solutions to make EASY 3D games Thank you! Keehun Nam VB is not usually the language of choice for creating 3D games. Here's a tutorial on games programming in VB.NET: http://vbprogramming.8k.com/tutorials/main.htm ...Show All

• Visual C++ GDI's TextOut giving strange character

  hi all, I am new in win32 programming, I try to use in following ways: case WM_PAINT: hdc = BeginPaint(hWnd, &ps); TextOut(hdc,50,50, (LPCTSTR)"H", 2); ......etc It seem to give me some strange chinese character. How should I cast the lpstring I am using Window XP and visual studio VC++ 2005 express edition, PSDK. Regards, First Question, Do you at least see the "H" and afterwards the funny Chinese character If that's the case you have one too many characters marked for display, change the 2 to a 1. TextOut(hdc, 50, 50, (LPCTSTR)"H", 1); If not I us ...Show All

• SQL Server DSO

  I was using DSO to make atree based on this example. But my Question is where could i put code for complexity_penalty or minimum_leaf_case in my code below And what's complexity_penalty or minimum_leaf_case use for are they important in our coding Public Sub CreateRelMiningModel() Dim dsoServer As New DSO.Server Dim dsoDB As DSO.MDStore Dim dsoDS As DSO.DataSource Dim dsoDMM As DSO.MiningModel Dim dsoColumn As DSO.Column Dim dsoRole As DSO.Role Dim strLQuote As String, strRQuote As String Dim strFromClause As String ' Constants used for DataType property ' of the DSO.Column object. ' Note that these constant ...Show All

• Software Development for Windows Vista Tutorial - Lab 4 Ex 1 Tk 6 St 15 - dragging to set next state

  FYI - When I executed this step, the designer did not change the existing SetState activity. It added a new one. What version of the Tutorials are you using Beta 2.2 When you executed this step, did you have a OrderCompletedState in your "TargetState" in your property ...Show All