Quilnux's Q&A profile

• SQL Server Index granularity

  Hi, I was looking at the new index locking granularity option available in 2005. I did not understand in what case can this be a performance enhancement. Has anybody looked into this Can you post any examples of possible usage I was seriously considering setting table granularity locks on my data warehouse type tables, especially during the day, when all access is wholly write during ETL, or wholly read during cube build. Using a read only database is not really convienient, but this should give some of the same properties, right ...Show All

• Visual C++ including atltime.h cause tenth of errors

  Hi, I'm trying to measure elepsed time in my C++/CLI project thus in order to create an CTime object I include atltime.h. This cause immediatly tenth of errors the first one is : C:\Program Files\Microsoft Visual Studio 8\VC\include\crtdbg.h(1141) : error C2039: 'delete[]' : is not a member of '`global namespace'' What is the cure Dan Thanks for the prompt reply. I'm using Visuall 2005 C++ pro. and when I needed to measure elapsing time I fell upon a CTime example. In any case I took your advise and I'm using .NET DateTime and it works fine. Dan ...Show All

• SQL Server Performance problem: 2000 vs. 2005

  I copied a 2000 database onto 2005 on another box. Running the exact same SELECT query, with 7 tables joined, is running in less than 2 minutes on 2000 and almost 3 hours on 2005. The 2005 box is "bigger and better". I've compared the sp_configure output. There are differences in max worker threads, cost threshold for parallelism, and priority boost. I don't think any one of these is significant. I checked the server properties and the database properties and, again, I did not see what I would consider any significant differences. The 2005 instance has 4GB memory, as opposed to 2GB, but not using that much. In fact, the Total Server Memory (KB) for the instance indicates around 1,230,000 for some reason. We need to reso ...Show All

• Windows Forms Smoother Refresh

  Is there a way to force a refresh without making a control's background turn white Info: What you'll find is that the .net Winforms engine sends WM_ERASEBACKGND messages like crazy. Setting the control styles works, but you need to set those in any components that will receive messages. Another approach is to over ride WndProc to ignore these messages: protected override void WndProc( ref Message m) { if (m.Msg == WM_ERASEBKGND) { m.Result = new IntPtr (0); return ; } base .WndProc( ref m); } Where WM_ERASEBKGND = 0x0014. I'd love to know WHY it does this, one woud think that ONE paint message would be enough. ...Show All

• Windows Forms Control population - Best Method

  By the way, are there any other techniques I can use to speed up the population of a form besides "SuspendLayout" and "ResumeLayout" (Moderator: Post has been split from original for this question) ...Show All

• Windows Forms Text to Screen

  Hello, I need help figuring out how to write text directly to the screen. I've looked at the forums and the online help but still no luck. Any help would be appriciated. Hi, if you are going to be displaying a signal on the TV then it will be hooked up to a PC, in order to play TV you are going to have to have a TV capture card in the PC to get the signal and display it on the screen, this will be displayed inside an application, you can create your own form that sits ontop of the window showing the TVsignal and is transparent to allow you to view the TV signal, you can then show opaque text on your form which should achieve the desired effect. That is how I would first try to tackle the problem. Mark. ...Show All

• Game Technologies: DirectX, XNA, XACT, etc. Creating sprites for 2D games

  How do I create sprites for 2D games with bird eye's view of the game world For example, for a 2D driving game, I want to create sprites so that a car can travel in eight directions using the keyboard and gamepad. If I press the up arrow key, the front of the car should point upwards. If I press the left arrow key, the front of the car should point to the left. Should I use tiles instead of one big bitmap file for the ground How do I set up the ground so that it scrolls in eight directions I went through some tutorials on some websites. I downloaded the XNA Game Studio and Visual C# programs yesterday morning. I went through tutorials on the XNA Resources website at this link: http://www.xnaresources.com/pa ...Show All

• Visual Studio Express Editions Relative path of an exe file

  hello i need to run some .exe files from my C# program ,currently i have the files in a separate directory in resources and i just use the absolute path to open and run them. I want to know how i could specify a relative path to the directory in which the user installs my application after i distribute it ..and also will the exe files automatically be included in the distribution when i publish the solution If all of your programs are installed to say... C:\Program Files\MyApp\ and you want to execute Foo.exe and do so normally with the full path of C:\Program Files\MyApp\Foo.exe... provided your app is in the same directory you can just axe the full path. If however the sub executables are contained in the folder C:\Program Fil ...Show All

• SQL Server Encourage use of UDFs instead of Procedures when possible?

  Over the past few months one of the issues that repeats in this forum has to do with the use of stored procedure output as input to other procedures. One method of dealing with this is to convert the stored procedure to a function if possible and use the function for the process. I was wandering if it would be a good idea to change my database standards to reflect a preference to use functions over stored procedures -- especially in a read-only context. I realize that in some cases this might cause performance problems, but I sill want to recruit opinions on this issue. Anybody It is true for scalar UDFs. But depending on the query plan, you will encounted similar situation for multi-statement TVFs. ...Show All

• Visual Studio Express Editions Publishing A Program? And Adding Settings that can be saved?

  Can i publish the program to my C drive then upload it to my website... but then make it so there is a link on the website to update the program I would also like to know how to make it possable for the user of my program to save there own personal settings like the background color of a form... i mean like putting a check box that when checked changes the background blue... but allowing the user to click a button after checking the box to make it so everytime the app is ran the background is blue... ...Show All

• Visual Studio Express Editions find maximum value that was input into text boxes

  I have three text boxes and I would like to click a button and have the highest value returned to a fourth textbox. Thanks in advance for your help. get all the values from the textbox then find the highest. For the sake of argument, lets just assume all the inputs are infact numbers. Store the numbers into an array, an arraylist would be good since you can sort it and the last value will be the highest value Dim theArrayList as new ArrayList() Dim firstValue as Integer = theArrayList.Add(Convert.ToIn32(Me.theTextBox1.Text)) Dim secondValue as Integer = theArrayList.Add(Convert.ToIn32(Me.theTextBox2.Text)) Dim thirdValue as Integer = theArrayList.Add(Convert.ToIn32(Me.theTextBox3.Text)) ...Show All

• Smart Device Development Custom Installer and MSI Installer

  Hello Everyone, I created MSI Installer and in that installer asked the user to enter the IP Address for the web service.I am able to get the value entered by the user while installing the application in the custom installer class by using Context.Parameteres collection.The problem is, I want to pass this value from my custom installer to my actual PDA project so that users of this application will be connecting to the webservice with the IP Address entered by them while installing the application. Currently we include a .config file which contains static IP Address for the web service.If the user wants to point to a different server he will change the config file in the desktop and copy it over to PDA.but they want the entered IP Ad ...Show All

• .NET Development Passing parameter to stored procedure

  I am passing parameters to a stored procedure that accepts three parameters: @PerControlBegin, @PerControlEnd, @GreatPlainsCompanyCode in my catch block, i get the error below ERROR [42000] [Microsoft][ODBC SQL Server Driver][SQL Server]Procedure 'usp_GreatPlains_GarnishmentIntegrations_GetTransactionsByPerControl_Test' expects parameter '@PerControlBegin' , which was not supplied." Can anyone help with this Thanks ================================================== private void FillDataGrid(string sSelectStatement, string PerControlBegin, string PerControlEnd, string GreatPlainsCompanyCode) { OdbcDataAdapter daVendorInfo;  DataSet         dsVendorInfo;  ClearDataGr ...Show All

• Windows Forms OnClick preceding OnEnter

  VS 2005 / XP Pro -- both with all service packs It is my understanding that the OnEnter event should precede most (all ) other events for a control but... Our application has a form on which is a Tab-control. We load a number of controls dynamically onto this Tab-control -- ComboBoxes, CheckListBoxes, and TextBoxes. We haven't checked all the Tabs, but on at least one of the Tabs the OnClick/OnMouseClick event precedes the OnEnter event for the ComboBoxes and CheckListBoxes (but not the TextBoxes). Controls that are added at design-time on other Forms' Tab-controls have the events fire in the expected order -- OnEnter and then OnClick/OnMouseClick. Is my understand of the sequence of events erroneous or can someone g ...Show All

• Visual Studio Express Editions How to read data from RS232?

  Hello all, I really have a simple problem with C# and VS C# Express, but no solution. I try to read data over RS232. I have a device which sends continued data over RS232 - so I don't have to send anything, just read data from the RS232. Can someone help me Thanks a lot, Franz Coriand I tried this code - but nothing happened :-( class SerialPortProgramm { SerialPort port = new SerialPort("COM1", 9600, Parity.None, 8, StopBits.One); public static void Main() { SerialPortProgramm obj = new SerialPortProgramm(); obj.startReading(); obj.doSomething(); obj.stopReading(); System.Console.ReadLine(); } private SerialPortProgramm() { port.DataReceived += new SerialDataReceiv ...Show All