redshock's Q&A profile

• SQL Server 'Other' segment in a pie chart

  Hello everybody, I am creating a pie chart report from a cube . This report may contain unknown number of segments. Here is the thing; if more than 1 data slice is generated with a value less than 5% of the total, then a segment labelled 'other' will be generated, and data from all slices with value < 5% will be added to this 'Other' segment. Is it possible to implement this functionality with out writing a complex MDX query If not can anybody give me a sample MDX query which implements similar issue(i.e. 'Other-ing' rule.) For your information, this feature can be implemented using a third pary software such as 'Dundas chart for Reporting Service'. This is answered here: http://forums.mic ...Show All

• .NET Development Performance counters

  Hi, I am trying to figure out how the performance counters work and I'm having some difficulties understanding some of the types. I have a very simple application that creates a counter instance and then I use perfmon.exe to see the values generated by my program. I successfully tried the AverageCount64 type, using the AverageBase. Although I continuously increment the counter I see the average in perfmon, as expected. When I try RateOfCountsPerSecond32 for instance, I increment the counter in the same way, but instead of seeing the rate per second in perfmon, I see the raw value of the counter being displayed. The curve keeps going up as long as my applications is running. Now since RateOfCountsPerSecond32 doesn't have a base typ ...Show All

• SQL Server full, differential, transaction hwo to rotate the differential?

  Being of the "point and click"-generation I managed to create some sort of a fairly simple backup plan for our databases. There are hourly transactional backups and daily full backups, which were set up with a database maintenance plan. As the databases store event records they are ever increasing around the hour. The daily backups are now of a size that holding them is not feasable anymore and I want to move to a differential backup scheme: Weekly full backups Daily differential backups Hourly transactional log backups The problem I have is that the database maintenance plans allow me to rotate backup files automatically as they included the date and time of the backup. For differential backups there is no option ...Show All

• SQL Server Need advice on how to optimize table.

  I have a ledger table that will have many entries for a given invoice, I need a good way to identify the most recent entry for the invoice. I've thought about putting an IsMostRecent flag in the column, but it would still require a table scan to identify the most recent records for invoices. I thought I could build a view over that table that had the invoiceID and max(tableID) and build an index on it, but you can't use the max() function in this instance. The only other thing I can think of us to build another lookup table, with the invoiceID and the tableID, but I don't think that is the best solution. Any tips would be greatly appreciated. Could you post your table definition and any indexes you current ...Show All

• Visual C++ Can't find entry point for function in C++ Dll called by Visual Basic 6.0

  Does anyone know why I would be getting the above type of error (Run time error '453') when I try to call a function in a Dll created in Visual C++ from a Visual Basic project I've tried just about every method of creating it that I could find on the internet and I would like to get some new ideas. I can send code to be looked at if necessary, but it wouldn't be the only method I've tried. I didn't save all of them. Feel free to send me an email. If it doesn't help add .def file to your project with following content. LIBRARY "dll1" ; You lib name EXPORTS fndll1 ; functions need to export fndll2 ; functions need to export fndll3 ; functions need to export ...Show All

• Silverlight (formerly WPF/E) WPF/E Namespace Confusion 2006? 2007?

  While dissecting the WPFEPad application I found on Mike Harsh's blog, I noticed that all the XAML files used in that example use the namespace declarations: <Canvas xmlns='http://schemas.microsoft.com/winfx/2006/xaml/presentation'   xmlns:x='http://schemas.microsoft.com/winfx/2006/xaml'> etc Up to now I had always thought that the agControl would only accept XAML files with the following namespace declarations: < Canvas xmlns='http://schemas.microsoft.com/client/2007' xmlns:x='http://schemas.microsoft.com/winfx/2006/xaml' > But alas, the former works as does the latter. Now, using the former is fantastic, since I can now author the xaml in Blend, and, as long as I'm careful not to add schematic const ...Show All

• Windows Forms DataGridView/DataSet problems

  Hi, In my application, I have a main form which opens another form (I will call this the child form). The child form is a sort of browser to allow me to look at the contents of a SQL database (there are many different databases in my application). I have set up my DataSet as a public static on my main form. When the child form is opened, it accesses this DataSet by accessing the class of the parent form and populates the DataGridView. When the child form is closed, I clear the DataSet by doing this: dSet1.Clear(); dSet1.Dispose(); When I breakpoint the code, it looks good. The DataSet variable shows clear. If I use my ListBox to browse to another table and open the child form again, I have a bizzare problem. All the columns ...Show All

• Windows Forms How do I create a backshadow of a line of text

  I've been asked to create a drop shadow effect of a line of text on a form. When I was coding VB 6.0, this was easy as I would create twoi labels and set one to transparent and drop the other behind the first. When the app ran, a drop-shadow effect would be apparent. But I'm having fits trying that in V.S. 2005. I've set the forms Transperancy Key to a color and set the label back color to the same color but what I got for that was being able to see the desktop! And setting the top label back color to transperant apparently does not work either, unless there was something else I failed to do Is there a way of doing this or will I have to convince the user that this is no longer possible Thanks; Rhubarb Hi Duck; I'm e ...Show All

• Visual C++ where the vtable memory will be sotred?

  hello , where the vtable memory will be created . Virtual functions callings are resolved at runtime . but when i write the class which has a virtual functions iam getting the size of the class = data + vptr but where the vtable memory is stored When you make any function virtual, the compiler will insert a vptr inside your class. As a result, the size of the class will grow by 4 bytes (on Win32).This pointer holds the address of the virtual table (vtable). vtable is constructed by the compiler at compile time and is basically nothing but an array of function pointers. The function pointers are actually pointers to the virtual functions of that particular class. To be more exact, the vi ...Show All

• Game Technologies: DirectX, XNA, XACT, etc. isometric view

  i can use a isometric view with the xna Yes, there is nothing stopping you from writing a game with an isometric view. You will either accomplish that by setting a particular camera position or by creating sprites that use an isometric view. But yes, both methods are entirely possible with XNA but XNA does not do anything in particular to help you accomplish an isometric view. How you achieve the view is entirely up to you. ...Show All

• Visual Studio Unable To Load Symbols

  This has happened 3 times already. Each time I had to completely uninstall VS 2005 Pro and the 2.0 framework from my computer to correct this issue. I am not able to hit any breakpoints. The tool tip on the breakpoint states "Unable to Load Symbols". It worked 5 minutes before, now it wont work at all. I deleted the temp files in the framework 2.0 folder, checked the IIS settings, killed the aspnet_wp.exe process, rebooted, checked my debug configuration to make sure I wasn't running in Release mode. I have tried everything I can think of (I even tried things I found online) and nothing seems to help. I have lost days of productivity because of this constantly happening. I cannot reinstall again and lose even more time. I h ...Show All

• Visual Studio Team System Sql Computed Value Generator

  Hi, The documentation that comes with CTP5 refers to a SQL Computed Value Generator for Primary Key and Foreign Key columns, but I cannot find this generator. I this something that still needs to be added, or is there a mistake in the documentation Also, how can I make my own custom generator available for use on Primary Key and Foreign Key columns Jerrie Hi Jerrie, The SQL Computed Value generator cannot actually be selected from the drop-down list of generators. It is auto-assigned (read-only) to all identity and foreign key columns. For example, if you import the Northwind sample database you should notice that the generator assigned to identity column dbo.Categories.CategoryID is the SQL Computed ...Show All

• .NET Development "Work around" the one base-class limit

  Hi all, I would like to add some extra functionality to several existing classes. The implementation of this extra functionality is exactly the same for all the classes. Unlike some other OO languages (like c++), the .NET framework only allows one baseclass to be used, so I cannot put this implementation in a single class, and derrive my new class from the both the original class AND the class with my extra implementation. One way to work around this, is to add one property to each of the derrived classes which contains an instance of a class with my new implmentation. But, I would rather extend my classes directly with the new properties and methods. Is there any way I can accomplish this without have to resolve to copy-paste ...Show All

• Visual Basic System.Timers.Timer()

  SERVER: The .exe is running on a Windows XP server. DEVELOPMENT: Visual Studio 2005 Standard Edition LANGUAGE: VB.Net 2005 ERROR RECIEVED: The wait completed due to an abandoned mutex ERROR DESCRIPTION: I'm using a System.Timers.Timer() object inside a windows form. The application is started each day in the morning around 7:30. It runs smoothly all day, but errors out(the log shows it is at 7:31AM, which would be the call to the IfxRealTimeAppointmentLoad routine). Basically the application calls the IfxLoadTodaysAppointment() once and then continually calls the IfxRealTimeAppointmentLoad() routine every 5 seconds. What I'm trying to do is have the application stop calling both routines at 12:00AM and then start the entire ...Show All

• SQL Server where are store Proc & Functions and so on in 2005?

  In 2000 you could look at templates and find templates for global or system functions where are they in 05 If you want to see the definition of the system stored procedure and function, you can open Management Studio, connect to the sql2005 instance and click Databases -> System Databases -> master -> Programmability -> Stored Procedure -> System Stored Procedure. ...Show All