Hello. What I'd like to ask is if there is a way to configure SQL Server 2005 to use only a certain amount of RAM. I have a machine with 4GB RAM, and there are a lot of apps running on it. It is when SQL Server starts executing a query over a relatively large database (e.g. 20 - 30 GB)that things go bad for all other apps - SQL Server uses almost all of the available RAM, leaving only a very limited amount for all other applications to use. Any suggestions?

thank you for your answer, but is'n this going to cause a recalculation of the value of the alias?

Why don't you try this: delete from dbo.Check_LIS where Lis_key in( select ps.Lis_key from dbo.Check_LIS as ps inner join Tshwane_Valuations.sde.Property as p on ps.Lis_key = p.Lis_key where substring (p.Attrib_code, 5, 2) = '16' or p.Attrib_code = '0009000900' ) Also you don't need to add ps.Lis_key = p.Lis_key in the where clause since you use inner join on the same fields. I hope this was helpful. Best wishes, Dobromir.

Hello, I'd like some help on the following problem - I need to use an alias as a condition in the where clause: select field1, field2, field3, field1*field2-field3 as some_alias from table1 where some_alias between 10 and 20 Using an alias like that returns the following error: Invalid column name 'some_alias'. Could anyone propose a solution?

Hello. I have the following problem:I need to retreive top(N)rows for each group in a single query. Here is an example of what I would like to do: select top(10) with ties table1.field1, table1.field2, table2.field1 from table1 inner join table2 on table1.some_field = table2.same_field group by table1.field1 order by table1.field1 As you can see, this query will return only 10 rows. What I need is 10 rows for each group (table1.field1). Can anyone help?

Is there a way to use some of .Net's numerous classes in MFC? What I'm particulrly interested is finding a way to use .Net's DataAdapter, DataReader, SqlCommand and so on classes in MFC. Thank you in advance.

Hello. I am new to MFC and C++ in general. I am interested in how to get the lower and higher parts of a DWORD variable?

Hi. Can anyone give me a general gude (or a link to some resources) on the subject of different image formats? But let me explain more specifically: I have a control that shows a lot of text items whose size & format depend on the content itself. This means that every time the control is repainted, a lot of text rendering occurs. To go around this problem I use a very simple idea - render the text to an image an draw the image until the text changes. The only problem with this idea is the consumption of a lot of RAM. What can I do to reduce the amount of memory I use? GDI+ offeres only the abstract Image class (Bitmap & Metafile as its descendents) for Drawing Images on the screen. Is there a way to reduce the colors or perhaps use some sort of compression when I save the Images in the in-memory buffer? Thank you.

Hi. I am developing a graphics intensive application where I need to save a certain state of the grapfics object in an Image (much like when you save someting you have drawn in PhotoShop for example). Does anyone know how I can do that?

I'd like to know I can create my own user control that acts like a panel control. What I mean is that when I place my user control on a form and drag say a picture box from the toolbox over it, it has to behave like a panel control would - if I set the Dock property of the PictureBox to Fill, the PictureBox should fill my control and not the form.

When you use a panel in the designer, you can drag&drop controls in it and they are contained by the panel and not the form containing the panel. Does anyone know the secret behind this kind of behaviour?

Hi. Does anyone know haw exactly does the Windows OnScreenKeyboard work? To be more specific, I'm interested in how it simulates the actual keystrokes (not like SendKeys.SendWait(), SnedMessage() or PostMessage() work, but like you're really working with the keyboard). Another thing of interest is how it never takes the focus when you click the keys? I've tried to simulate it using SendKeys,SendMessage or PostMessage, but I always need to transfer the focus back on the receiving form, which is obviously not a good approach. Can anyone give me a hint?

Hi. Does anyone know how can I make a control work without recieving the focus? The thing is that I'm trying to simulate a kyboard (on a UserControl) which is added to a form. Whenevet a key is clicked, I use the SendKeys.SendWait method to simulate a keystroke. In order to process the simulated keystroke, the recieving form should be in focus. To achieve this, I use the SetFocus function (from User32.dll) with the handler of the recieving form. So far so good - it all works fine except for the slight occasional control bar flicker when changing the focus. So - is there a way to avoid all that focus transfer?

Hi. Does anyone know how can I make a control work without recieving the focus? The thing is that I'm trying to simulate a kyboard (on a UserControl) which is added to a form. Whenevet a key is clicked, I use the SendKeys.SendWait method to simulate a keystroke. In order to process the simulated keystroke, the recieving form should be in focus. To achieve this, I use the SetFocus function (from User32.dll) with the handler of the recieving form. So far so good - it all works fine except for the slight occasional control bar flicker when changing the focus. So - is there a way to avoid all that focus transfer?

Hi. I'm having trouble with setting the focus with WindowsForms. I'm trying to achieve the Windows OnScreenKeyBoard functionllity - achieving some action without getting the focus. I use the SendKeys.SendWait method to send keys to the window in focus, but in my case it is always the form containing the keyboard that is in focus:-) Can anyone give me a hint?

Hi. Everyone is still learning:-D If you need to make an inventory program, you will almost certainly need to make a database. The first thing is to choose your DBMS (DataBase Management System) and take it from there. After you're done with the database, it's not so difficult to make that form. I could send you some samples if you like. Best regards.

Hi there. I have the following problem: I need to make a control that has an irregular shape. So far so good - I have no problem drawing it using something like this: Private Sub TabPage4_Paint(ByVal sender As Object, ByVal e As System.Windows.Forms.PaintEventArgs) Handles TabPage4.Paint Dim myPointArray As Point() = {New Point(50, 50), New Point(100, 120), New Point(140, 100)} Dim MyGraphics As Graphics = e.Graphics Dim MyPen As New Pen(Color.Azure, 2) Dim mySolidBrush As New SolidBrush(Color.Aqua) myGraphics.DrawClosedCurve(myPen, myPointArray) MyGraphics.FillClosedCurve(mySolidBrush, myPointArray) End Sub So now I have drawn part of the control. The problem comes when I try to raise an event regarding the irregular shape I've drawn, not the ractangle containing it. Can anyone help me with an idea, or maybe a hole new different approach to make such a control?

Thank you for the reply. I am not used to using any of the macromedia products but here's a good reason to try them out :-) As soon as I finish the control i will write you back. Thanks once again.

Hi. I have a general question about custom controls. I want to make a control on a windows form that has a nonrectangular shape and the control itself is divided into several nonrectangular shapes. I need to divide the control because i want the different areas in it to have different properties. I'd be very grateful if someone gives me a general advice on how to achieve that. I've already tried with transparent labels over a picture representing the control, but it is not nearly as good as i need it to be. Thank you in advance.